APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_LOC_DEFAULTS

Line 7941: insert into mtl_item_loc_defaults

7937: Copy Locator Defaults
7938: +--------------------------------------*/
7939:
7940: lStmtNumber := 302;
7941: insert into mtl_item_loc_defaults
7942: (
7943: inventory_item_id,
7944: organization_id,
7945: locator_id,

Line 7974: mtl_item_loc_defaults ld,

7970: NULL, -- program_application_id
7971: NULL, -- program_id
7972: SYSDATE -- program_update_date
7973: from
7974: mtl_item_loc_defaults ld,
7975: bom_cto_src_orgs bcso
7976: where ld.organization_id = bcso.organization_id
7977: and ld.inventory_item_id = bcso.model_item_id
7978: and bcso.model_item_id = pModelId

Line 7982: from mtl_item_loc_defaults

7978: and bcso.model_item_id = pModelId
7979: and bcso.line_id = pLineId
7980: and NOT EXISTS
7981: (select NULL
7982: from mtl_item_loc_defaults
7983: where inventory_item_id = pConfigId
7984: and organization_id = ld.organization_id);
7985:
7986:

Line 7989: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_loc_defaults',2);

7985:
7986:
7987:
7988: IF PG_DEBUG <> 0 THEN
7989: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_loc_defaults',2);
7990: END IF;
7991:
7992: -- end 2786934
7993: