APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_RELATED_ITEMS

Line 7484: Copy related items into MTL_RELATED_ITEMS table

7480:
7481: -- End Bugfix 2197842
7482:
7483: /*----------------------------------------------------+
7484: Copy related items into MTL_RELATED_ITEMS table
7485: +----------------------------------------------------*/
7486:
7487: lStmtNumber := 270;
7488:

Line 7489: insert into MTL_RELATED_ITEMS

7485: +----------------------------------------------------*/
7486:
7487: lStmtNumber := 270;
7488:
7489: insert into MTL_RELATED_ITEMS
7490: (
7491: inventory_item_id,
7492: related_item_id,
7493: relationship_type_id,

Line 7521: from mtl_related_items ri,

7517: NULL, -- program_application_id
7518: NULL, -- program_id
7519: SYSDATE, -- program_update_date
7520: ri.organization_id
7521: from mtl_related_items ri,
7522: bom_cto_src_orgs bcso
7523: where ri.inventory_item_id = pModelId
7524: and bcso.model_item_id = pModelId
7525: and bcso.line_id = pLineId

Line 7529: from mtl_related_items

7525: and bcso.line_id = pLineId
7526: and ri.organization_id = bcso.organization_id
7527: and NOT EXISTS
7528: (select NULL
7529: from mtl_related_items
7530: where inventory_item_id = pConfigId
7531: and organization_id = bcso.organization_id);
7532:
7533:

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

7534:
7535:
7536:
7537: IF PG_DEBUG <> 0 THEN
7538: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_related_items',2);
7539: END IF;
7540:
7541: /*--------------------------------------------------+
7542: Copy substitute inventories