VIEW: APPS.OE_AR_CUSTOMER_PROFILES_V

Source

View Text - Preformatted

SELECT PROF.STANDARD_TERMS PAYMENT_TERM_ID , CUST_ACCT.CUST_ACCOUNT_ID SOLD_TO_ORG_ID , INV_SITE.SITE_USE_ID INVOICE_TO_ORG_ID , SHIP_SITE.SITE_USE_ID SHIP_TO_ORG_ID FROM HZ_CUSTOMER_PROFILES PROF, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_CUST_SITE_USES INV_SITE, HZ_CUST_SITE_USES SHIP_SITE WHERE PROF.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID AND INV_SITE.SITE_USE_CODE(+) = 'BILL_TO' AND PROF.SITE_USE_ID = INV_SITE.SITE_USE_ID (+) AND SHIP_SITE.SITE_USE_CODE(+) = 'SHIP_TO' AND PROF.SITE_USE_ID = SHIP_SITE.SITE_USE_ID (+)

View Text - HTML Formatted

SELECT PROF.STANDARD_TERMS PAYMENT_TERM_ID
, CUST_ACCT.CUST_ACCOUNT_ID SOLD_TO_ORG_ID
, INV_SITE.SITE_USE_ID INVOICE_TO_ORG_ID
, SHIP_SITE.SITE_USE_ID SHIP_TO_ORG_ID
FROM HZ_CUSTOMER_PROFILES PROF
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_SITE_USES INV_SITE
, HZ_CUST_SITE_USES SHIP_SITE
WHERE PROF.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND INV_SITE.SITE_USE_CODE(+) = 'BILL_TO'
AND PROF.SITE_USE_ID = INV_SITE.SITE_USE_ID (+)
AND SHIP_SITE.SITE_USE_CODE(+) = 'SHIP_TO'
AND PROF.SITE_USE_ID = SHIP_SITE.SITE_USE_ID (+)