View: RLM_CUM_SITE_USES_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	APPS.RLM_CUM_SITE_USES_V

View Text

SELECT SITE.ROWID ROW_ID
, SITE.SITE_USE_ID
, RAD.CUSTOMER_ID
, SITE.ADDRESS_ID
, SITE.LOCATION
, RAD.CITY
, RAD.STATE
, SITE.SITE_USE_CODE
, ARL.MEANING SITE_USE_MEANING
, TERMS.CUM_ORG_LEVEL_CODE
FROM RLM_CUST_SHIPTO_TERMS TERMS
, RA_ADDRESSES RAD
, AR_LOOKUPS ARL
, RA_SITE_USES SITE
WHERE RAD.ADDRESS_ID = SITE.ADDRESS_ID
AND TERMS.ADDRESS_ID = RAD.ADDRESS_ID
AND TERMS.CUM_ORG_LEVEL_CODE IN ('SHIP_TO_SHIP_FROM'
, 'BILL_TO_SHIP_FROM'
, 'DELIVER_TO_SHIP_FROM')
AND SITE.STATUS = 'A'
AND SITE.SITE_USE_CODE = ARL.LOOKUP_CODE
AND ARL.LOOKUP_TYPE = 'SITE_USE_CODE'

Columns