APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_CUSTOMER_ITEM_XREFS

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 2761: MFG_LOOKUPS MFL, mtl_customer_item_xrefs xref

2757: FROM FND_TERRITORIES_TL T, FND_TERRITORIES B
2758: WHERE B.TERRITORY_CODE = T.TERRITORY_CODE
2759: AND T.LANGUAGE = USERENV('LANG')) TERR,
2760: AR_LOOKUPS ARL,
2761: MFG_LOOKUPS MFL, mtl_customer_item_xrefs xref
2762: WHERE MCI.CUSTOMER_ID = HZC.CUST_ACCOUNT_ID
2763: AND MCI.ADDRESS_ID = RAD.ADDRESS_ID(+)
2764: AND MCI.COMMODITY_CODE_ID = MCC.COMMODITY_CODE_ID
2765: AND MCI.MODEL_CUSTOMER_ITEM_ID = MCIM.CUSTOMER_ITEM_ID(+)

Line 3082: FROM MTL_CUSTOMER_ITEM_XREFS x, MTL_CUSTOMER_ITEMS i

3078: SELECT inventory_item_id
3079: INTO x_prod_attr_value
3080: FROM (
3081: SELECT Inventory_Item_Id
3082: FROM MTL_CUSTOMER_ITEM_XREFS x, MTL_CUSTOMER_ITEMS i
3083: WHERE i.customer_id = p_customer_id
3084: AND i.customer_item_number = p_item_number_cust
3085: AND i.Customer_Item_Id = x.customer_item_id
3086: AND x.Master_Organization_Id =