Receivables - EBS (MOSC)

MOSC Banner

Use of BILL_TO_FLAG in hz_cust_acct_sites_all

edited Jan 28, 2013 4:21PM in Receivables - EBS (MOSC) 3 commentsAnswered
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center