APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 8230: FROM mtl_customer_item_xrefs xref

8226:
8227: DECLARE
8228: CURSOR cust_id_xref_cur IS
8229: SELECT xref.customer_item_id, Max(xref.preference_number) pref_number
8230: FROM mtl_customer_item_xrefs xref
8231: WHERE customer_item_id IN (
8232: SELECT ref1.customer_item_id
8233: FROM mtl_customer_item_xrefs ref1
8234: WHERE ref1.inventory_item_id = pModelId

Line 8233: FROM mtl_customer_item_xrefs ref1

8229: SELECT xref.customer_item_id, Max(xref.preference_number) pref_number
8230: FROM mtl_customer_item_xrefs xref
8231: WHERE customer_item_id IN (
8232: SELECT ref1.customer_item_id
8233: FROM mtl_customer_item_xrefs ref1
8234: WHERE ref1.inventory_item_id = pModelId
8235: )
8236: GROUP BY customer_item_id;
8237:

Line 8246: INTO mtl_customer_item_xrefs

8242: oe_debug_pub.add('Create_Item: '||'Rank:'|| cust_id_xref_rec.pref_number, 5);
8243: END IF;
8244:
8245: INSERT
8246: INTO mtl_customer_item_xrefs
8247: (
8248: Customer_Item_Id ,
8249: Inventory_Item_Id ,
8250: Master_Organization_Id,

Line 8302: FROM mtl_customer_item_xrefs xref

8298: xref.Attribute12 ,
8299: xref.Attribute13 ,
8300: xref.Attribute14 ,
8301: xref.Attribute15
8302: FROM mtl_customer_item_xrefs xref
8303: WHERE inventory_item_id = pModelId
8304: AND customer_item_id = cust_id_xref_rec.customer_item_id
8305: AND NOT EXISTS ( SELECT 'EXISTS'
8306: FROM mtl_customer_item_xrefs ref1

Line 8306: FROM mtl_customer_item_xrefs ref1

8302: FROM mtl_customer_item_xrefs xref
8303: WHERE inventory_item_id = pModelId
8304: AND customer_item_id = cust_id_xref_rec.customer_item_id
8305: AND NOT EXISTS ( SELECT 'EXISTS'
8306: FROM mtl_customer_item_xrefs ref1
8307: WHERE inventory_item_id = pConfigId
8308: AND customer_item_id = cust_id_xref_rec.customer_item_id
8309: );
8310: END LOOP;

Line 8314: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_customer_item_xrefs',2);

8310: END LOOP;
8311: END;
8312:
8313: IF PG_DEBUG <> 0 THEN
8314: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_customer_item_xrefs',2);
8315: END IF;
8316: -- End Bugfix 9288619
8317:
8318: