View: OE_AR_CUSTOMER_PROFILES_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AR_CUSTOMER_PROFILES_V

View Text

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 (+)

Columns