View: MRP_CUSTOMER_SITES_V

Product:	MRP - Master Scheduling/MRP
Description:	Not currently used
Implementation/DBA Data:	APPS.MRP_CUSTOMER_SITES_V

View Text

SELECT A.CUSTOMER_ID
, S.SITE_USE_ID
, A.ADDRESS1 || ' (' || L.MEANING || ')'
, A.CITY
, A.STATE
, S.ORG_ID
FROM RA_ADDRESSES_ALL A
, RA_SITE_USES_ALL S
, AR_LOOKUPS L
WHERE A.ADDRESS_ID = S.ADDRESS_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

Columns