View: RLM_CUM_SHIPFR_CUST_ITEMS_V

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

View Text

SELECT MTL.CUSTOMER_ITEM_ID
, MTL.CUSTOMER_ID
, MTL.CUSTOMER_ITEM_NUMBER
, MTL.CUSTOMER_ITEM_DESC
, MTL.ADDRESS_ID
, MTL.ITEM_DEFINITION_LEVEL
, MTL.CUSTOMER_CATEGORY_CODE
, MTL.LAST_UPDATE_DATE
, MTL.LAST_UPDATED_BY
, MTL.CREATION_DATE
, MTL.CREATED_BY
, MTL.LAST_UPDATE_LOGIN
, MTL.REQUEST_ID
, MTL.PROGRAM_APPLICATION_ID
, MTL.PROGRAM_ID
, MTL.PROGRAM_UPDATE_DATE
FROM MTL_CUSTOMER_ITEMS MTL
WHERE EXISTS (SELECT CUSTOMER_ITEM_ID
FROM RLM_CUST_ITEM_CUM_KEYS
WHERE CUSTOMER_ITEM_ID = MTL.CUSTOMER_ITEM_ID
AND (SHIP_TO_ADDRESS_ID = NVL(MTL.ADDRESS_ID
, SHIP_TO_ADDRESS_ID) OR SHIP_TO_ADDRESS_ID IS NULL))
AND MTL.INACTIVE_FLAG = 'N'

Columns