APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_SUB_INVENTORIES

Line 7547: insert into mtl_item_sub_inventories

7543: +--------------------------------------------------*/
7544:
7545: lStmtNumber := 280;
7546:
7547: insert into mtl_item_sub_inventories
7548: (
7549: inventory_item_id,
7550: organization_id,
7551: secondary_inventory,

Line 7632: mtl_item_sub_inventories isi,

7628: NULL, -- program_id
7629: SYSDATE, -- program_update_date
7630: isi.ENCUMBRANCE_ACCOUNT
7631: from
7632: mtl_item_sub_inventories isi,
7633: bom_cto_src_orgs bcso
7634: where isi.organization_id = bcso.organization_id
7635: and isi.inventory_item_id = pModelId
7636: and bcso.model_item_id = pModelId

Line 7640: from mtl_item_sub_inventories

7636: and bcso.model_item_id = pModelId
7637: and bcso.line_id = pLineId
7638: and NOT EXISTS
7639: (select NULL
7640: from mtl_item_sub_inventories
7641: where inventory_item_id = pConfigId
7642: and organization_id = bcso.organization_id);
7643:
7644:

Line 7648: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_item_sub_inventories',2);

7644:
7645:
7646:
7647: IF PG_DEBUG <> 0 THEN
7648: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_item_sub_inventories',2);
7649: END IF;
7650:
7651: /*--------------------------------------+
7652: Copy secondary locators