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.

APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_CUSTOMER_ITEMS_ALL_V

Line 2690: FROM mtl_customer_item_xrefs xref, mtl_customer_items_all_v ci

2686: --the query below will ensure that a unique customer_item_number is selected.
2687: BEGIN
2688: SELECT ci.customer_item_number
2689: INTO l_customer_item_number
2690: FROM mtl_customer_item_xrefs xref, mtl_customer_items_all_v ci
2691: WHERE xref.inventory_item_id = p_item_number
2692: AND xref.master_organization_id = l_master_org
2693: AND xref.inactive_flag = 'N'
2694: AND ci.customer_item_id = xref.customer_item_id

Line 2738: -- Replaceing mtl_customer_items_all_v with the view definition for

2734: END;
2735:
2736: --Per M. Antyakula of INV team specifying master org filter as well in
2737: --the query below will ensure that a unique record is selected.
2738: -- Replaceing mtl_customer_items_all_v with the view definition for
2739: -- fix for sql id 17903884
2740: BEGIN
2741: SELECT MCI.CUSTOMER_ITEM_DESC
2742: INTO l_customer_item_desc