Use of BILL_TO_FLAG in hz_cust_acct_sites_all
We are extracting bill to site for passing to AR API for creating invoice using condition BILL_TO_FLAG =P but few sites do not have this flag set to any value
though primary box is checked at bill to site, because of that we are not able to extract bill to site use id.
Thinking of removing this condition BILL_TO_FLAG =P hope this should be ok
used sql is copied below
SELECT DISTINCT hcsua1.SITE_USE_ID, hcsua1.cust_acct_site_id, HL.COUNTRY, nvl(HL.STATE,'Z'),hcsua1.TAX_CODE, hp.party_name,
hcsua1.site_use_code, hcasa1.BILL_TO_FLAG