APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_LOC_DEFAULTS

Line 8126: insert into mtl_item_loc_defaults

8122: Copy Locator Defaults
8123: +--------------------------------------*/
8124:
8125: lStmtNumber := 302;
8126: insert into mtl_item_loc_defaults
8127: (
8128: inventory_item_id,
8129: organization_id,
8130: locator_id,

Line 8159: mtl_item_loc_defaults ld,

8155: NULL, -- program_application_id
8156: NULL, -- program_id
8157: SYSDATE -- program_update_date
8158: from
8159: mtl_item_loc_defaults ld,
8160: bom_cto_src_orgs bcso
8161: where ld.organization_id = bcso.organization_id
8162: and ld.inventory_item_id = bcso.model_item_id
8163: and bcso.model_item_id = pModelId

Line 8167: from mtl_item_loc_defaults

8163: and bcso.model_item_id = pModelId
8164: and bcso.line_id = pLineId
8165: and NOT EXISTS
8166: (select NULL
8167: from mtl_item_loc_defaults
8168: where inventory_item_id = pConfigId
8169: and organization_id = ld.organization_id);
8170:
8171:

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

8170:
8171:
8172:
8173: IF PG_DEBUG <> 0 THEN
8174: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_loc_defaults',2);
8175: END IF;
8176:
8177: -- end 2786934
8178: