VIEW: APPS.RLM_RESETCUM_ITEMS_V

Source

View Text - Preformatted

SELECT customer_item_number, NULL ece_tp_location_code, customer_item_id, address_id, customer_id, item_definition_level, inactive_flag, NULL org_id FROM mtl_customer_items WHERE address_id IS NULL UNION SELECT mtl.customer_item_number, raa.ece_tp_location_code, mtl.customer_item_id, mtl.address_id, mtl.customer_id,mtl.item_definition_level, mtl.inactive_flag, org_id FROM mtl_customer_items mtl, hz_cust_acct_sites_all raa WHERE mtl.address_id = raa.cust_acct_site_id

View Text - HTML Formatted

SELECT CUSTOMER_ITEM_NUMBER
, NULL ECE_TP_LOCATION_CODE
, CUSTOMER_ITEM_ID
, ADDRESS_ID
, CUSTOMER_ID
, ITEM_DEFINITION_LEVEL
, INACTIVE_FLAG
, NULL ORG_ID
FROM MTL_CUSTOMER_ITEMS
WHERE ADDRESS_ID IS NULL UNION SELECT MTL.CUSTOMER_ITEM_NUMBER
, RAA.ECE_TP_LOCATION_CODE
, MTL.CUSTOMER_ITEM_ID
, MTL.ADDRESS_ID
, MTL.CUSTOMER_ID
, MTL.ITEM_DEFINITION_LEVEL
, MTL.INACTIVE_FLAG
, ORG_ID
FROM MTL_CUSTOMER_ITEMS MTL
, HZ_CUST_ACCT_SITES_ALL RAA
WHERE MTL.ADDRESS_ID = RAA.CUST_ACCT_SITE_ID