VIEW: APPS.MRP_CUSTOMER_SITES_V

Source

View Text - Preformatted

SELECT AS1.CUST_ACCOUNT_ID , S.SITE_USE_ID , A.ADDRESS1 || '  (' || L.MEANING || ')' , A.CITY , A.STATE , S.ORG_ID FROM HZ_LOCATIONS A, HZ_PARTY_SITES PS1, HZ_CUST_ACCT_SITES_ALL AS1, HZ_CUST_SITE_USES_ALL S, AR_LOOKUPS L WHERE S.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID AND S.SITE_USE_CODE IN ('SHIP_TO', 'BILL_TO') AND L.LOOKUP_TYPE = 'SITE_USE_CODE' AND L.LOOKUP_CODE = S.SITE_USE_CODE AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID AND PS1.LOCATION_ID = A.LOCATION_ID

View Text - HTML Formatted

SELECT AS1.CUST_ACCOUNT_ID
, S.SITE_USE_ID
, A.ADDRESS1 || ' (' || L.MEANING || ')'
, A.CITY
, A.STATE
, S.ORG_ID
FROM HZ_LOCATIONS A
, HZ_PARTY_SITES PS1
, HZ_CUST_ACCT_SITES_ALL AS1
, HZ_CUST_SITE_USES_ALL S
, AR_LOOKUPS L
WHERE S.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID
AND S.SITE_USE_CODE IN ('SHIP_TO'
, 'BILL_TO')
AND L.LOOKUP_TYPE = 'SITE_USE_CODE'
AND L.LOOKUP_CODE = S.SITE_USE_CODE
AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID
AND PS1.LOCATION_ID = A.LOCATION_ID