View: GMF_XLA_CUSTOMER_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from customers
Implementation/DBA Data:	APPS.GMF_XLA_CUSTOMER_V

View Text

SELECT OL.LINE_ID AS ORDER_LINE_ID
, S.SITE_USE_ID AS CUST_ID
, NVL(S.ATTRIBUTE1
, NVL(C.ATTRIBUTE1
, NULL)) CUSTGL_CLASS
FROM HZ_CUST_ACCOUNTS C
, HZ_CUST_SITE_USES_ALL S
, HZ_CUST_ACCT_SITES_ALL A
, HZ_PARTIES PR
, OE_ORDER_LINES_ALL OL
WHERE C.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
AND S.CUST_ACCT_SITE_ID = A.CUST_ACCT_SITE_ID
AND S.SITE_USE_CODE IN ('SHIP_TO')
AND A.ORG_ID = S.ORG_ID
AND C.PARTY_ID = PR.PARTY_ID
AND S.SITE_USE_ID = OL.SHIP_TO_ORG_ID

Columns