VIEW: APPS.GMF_XLA_CUSTOMER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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