eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QP_CUSTOMER_ITEMS_V

Source

View Text - Preformatted


SELECT citemsv.customer_item_number CUSTOMER_ITEM , citemsv.customer_item_id CUSTOMER_ITEM_ID , nvl(citemsv.customer_item_desc, sitems.description) ITEM_DESCRIPTION , substr(citemsv.concatenated_address,1,400) ADDRESS , sitems.inventory_item_id INVENTORY_ITEM_ID , sitems.concatenated_segments INVENTORY_ITEM , citemsv.customer_id SOLD_TO_ORG_ID , sitems.organization_id ORGANIZATION_ID , citemsv.customer_category , citemsv.address_id FROM mtl_customer_item_xrefs cxref , mtl_system_items_vl sitems , mtl_customer_items_all_v citemsv WHERE citemsv.customer_item_id = cxref.customer_item_id AND cxref.inventory_item_id = sitems.inventory_item_id AND sitems.organization_id = QP_UTIL.Get_Item_Validation_Org

View Text - HTML Formatted

SELECT CITEMSV.CUSTOMER_ITEM_NUMBER CUSTOMER_ITEM
, CITEMSV.CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, NVL(CITEMSV.CUSTOMER_ITEM_DESC
, SITEMS.DESCRIPTION) ITEM_DESCRIPTION
, SUBSTR(CITEMSV.CONCATENATED_ADDRESS
, 1
, 400) ADDRESS
, SITEMS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, CITEMSV.CUSTOMER_ID SOLD_TO_ORG_ID
, SITEMS.ORGANIZATION_ID ORGANIZATION_ID
, CITEMSV.CUSTOMER_CATEGORY
, CITEMSV.ADDRESS_ID
FROM MTL_CUSTOMER_ITEM_XREFS CXREF
, MTL_SYSTEM_ITEMS_VL SITEMS
, MTL_CUSTOMER_ITEMS_ALL_V CITEMSV
WHERE CITEMSV.CUSTOMER_ITEM_ID = CXREF.CUSTOMER_ITEM_ID
AND CXREF.INVENTORY_ITEM_ID = SITEMS.INVENTORY_ITEM_ID
AND SITEMS.ORGANIZATION_ID = QP_UTIL.GET_ITEM_VALIDATION_ORG