VIEW: APPS.RLM_CUM_SHIPFR_CUST_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'