APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_CUSTOMER_ITEMS

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

Line 2743: FROM MTL_CUSTOMER_ITEMS MCI,

2739: -- fix for sql id 17903884
2740: BEGIN
2741: SELECT MCI.CUSTOMER_ITEM_DESC
2742: INTO l_customer_item_desc
2743: FROM MTL_CUSTOMER_ITEMS MCI,
2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,
2745: ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
2746: FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,

Line 2756: MTL_CUSTOMER_ITEMS MCIM, ( SELECT B.TERRITORY_CODE

2752: AND NVL(ACCT_SITE.ORG_ID,- 99) = NVL(LOC_ASSIGN.ORG_ID,- 99)
2753: AND NVL(ACCT_SITE.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1, 10))),- 99)) =
2754: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1, 1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),- 99)) RAD,
2755: MTL_COMMODITY_CODES MCC,
2756: MTL_CUSTOMER_ITEMS MCIM, ( SELECT B.TERRITORY_CODE
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,

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 =