APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SECONDARY_LOCATORS

Line 7842: insert into mtl_secondary_locators

7838: +--------------------------------------*/
7839:
7840: lStmtNumber := 290;
7841:
7842: insert into mtl_secondary_locators
7843: (
7844: inventory_item_id,
7845: organization_id,
7846: secondary_locator,

Line 7877: mtl_secondary_locators sl,

7873: NULL, -- program_application_id
7874: NULL, -- program_id
7875: SYSDATE -- program_update_date
7876: from
7877: mtl_secondary_locators sl,
7878: bom_cto_src_orgs bcso
7879: where sl.organization_id = bcso.organization_id
7880: and pModelId = sl.inventory_item_id
7881: and bcso.model_item_id = pModelId

Line 7885: from mtl_secondary_locators

7881: and bcso.model_item_id = pModelId
7882: and bcso.line_id = pLineId
7883: and NOT EXISTS
7884: (select NULL
7885: from mtl_secondary_locators
7886: where inventory_item_id = pConfigId
7887: and organization_id = bcso.organization_id);
7888:
7889:

Line 7893: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_secondary_locators',2);

7889:
7890:
7891:
7892: IF PG_DEBUG <> 0 THEN
7893: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_secondary_locators',2);
7894: END IF;
7895:
7896: /*----------------------------------------+
7897: Copy cross references