APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_SUB_INVENTORIES

Line 7732: insert into mtl_item_sub_inventories

7728: +--------------------------------------------------*/
7729:
7730: lStmtNumber := 280;
7731:
7732: insert into mtl_item_sub_inventories
7733: (
7734: inventory_item_id,
7735: organization_id,
7736: secondary_inventory,

Line 7817: mtl_item_sub_inventories isi,

7813: NULL, -- program_id
7814: SYSDATE, -- program_update_date
7815: isi.ENCUMBRANCE_ACCOUNT
7816: from
7817: mtl_item_sub_inventories isi,
7818: bom_cto_src_orgs bcso
7819: where isi.organization_id = bcso.organization_id
7820: and isi.inventory_item_id = pModelId
7821: and bcso.model_item_id = pModelId

Line 7825: from mtl_item_sub_inventories

7821: and bcso.model_item_id = pModelId
7822: and bcso.line_id = pLineId
7823: and NOT EXISTS
7824: (select NULL
7825: from mtl_item_sub_inventories
7826: where inventory_item_id = pConfigId
7827: and organization_id = bcso.organization_id);
7828:
7829:

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

7829:
7830:
7831:
7832: IF PG_DEBUG <> 0 THEN
7833: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_item_sub_inventories',2);
7834: END IF;
7835:
7836: /*--------------------------------------+
7837: Copy secondary locators