APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SECONDARY_LOCATORS

Line 7657: insert into mtl_secondary_locators

7653: +--------------------------------------*/
7654:
7655: lStmtNumber := 290;
7656:
7657: insert into mtl_secondary_locators
7658: (
7659: inventory_item_id,
7660: organization_id,
7661: secondary_locator,

Line 7692: mtl_secondary_locators sl,

7688: NULL, -- program_application_id
7689: NULL, -- program_id
7690: SYSDATE -- program_update_date
7691: from
7692: mtl_secondary_locators sl,
7693: bom_cto_src_orgs bcso
7694: where sl.organization_id = bcso.organization_id
7695: and pModelId = sl.inventory_item_id
7696: and bcso.model_item_id = pModelId

Line 7700: from mtl_secondary_locators

7696: and bcso.model_item_id = pModelId
7697: and bcso.line_id = pLineId
7698: and NOT EXISTS
7699: (select NULL
7700: from mtl_secondary_locators
7701: where inventory_item_id = pConfigId
7702: and organization_id = bcso.organization_id);
7703:
7704:

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

7704:
7705:
7706:
7707: IF PG_DEBUG <> 0 THEN
7708: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_secondary_locators',2);
7709: END IF;
7710:
7711: /*----------------------------------------+
7712: Copy cross references