APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_RELATED_ITEMS

Line 7669: Copy related items into MTL_RELATED_ITEMS table

7665:
7666: -- End Bugfix 2197842
7667:
7668: /*----------------------------------------------------+
7669: Copy related items into MTL_RELATED_ITEMS table
7670: +----------------------------------------------------*/
7671:
7672: lStmtNumber := 270;
7673:

Line 7674: insert into MTL_RELATED_ITEMS

7670: +----------------------------------------------------*/
7671:
7672: lStmtNumber := 270;
7673:
7674: insert into MTL_RELATED_ITEMS
7675: (
7676: inventory_item_id,
7677: related_item_id,
7678: relationship_type_id,

Line 7706: from mtl_related_items ri,

7702: NULL, -- program_application_id
7703: NULL, -- program_id
7704: SYSDATE, -- program_update_date
7705: ri.organization_id
7706: from mtl_related_items ri,
7707: bom_cto_src_orgs bcso
7708: where ri.inventory_item_id = pModelId
7709: and bcso.model_item_id = pModelId
7710: and bcso.line_id = pLineId

Line 7714: from mtl_related_items

7710: and bcso.line_id = pLineId
7711: and ri.organization_id = bcso.organization_id
7712: and NOT EXISTS
7713: (select NULL
7714: from mtl_related_items
7715: where inventory_item_id = pConfigId
7716: and organization_id = bcso.organization_id);
7717:
7718:

Line 7723: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_related_items',2);

7719:
7720:
7721:
7722: IF PG_DEBUG <> 0 THEN
7723: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_related_items',2);
7724: END IF;
7725:
7726: /*--------------------------------------------------+
7727: Copy substitute inventories