APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_RELATED_ITEMS

Line 2485: Copy related items into MTL_RELATED_ITEMS table

2481: END IF; /* p_cat_id = -99 */
2482:
2483:
2484: /*----------------------------------------------------+
2485: Copy related items into MTL_RELATED_ITEMS table
2486: +----------------------------------------------------*/
2487:
2488: lStmtNumber := 140;
2489:

Line 2490: insert into MTL_RELATED_ITEMS

2486: +----------------------------------------------------*/
2487:
2488: lStmtNumber := 140;
2489:
2490: insert into MTL_RELATED_ITEMS
2491: (
2492: inventory_item_id,
2493: related_item_id,
2494: relationship_type_id,

Line 2523: from mtl_related_items ri,

2519: NULL, -- program_application_id
2520: NULL, -- program_id
2521: SYSDATE, -- program_update_date
2522: ri.organization_id
2523: from mtl_related_items ri,
2524: bom_cto_src_orgs bcso,
2525: bom_cto_order_lines_upg bcolu
2526: where bcolu.config_item_id is not null
2527: and bcolu.status = 'BCSO'

Line 2534: from mtl_related_items

2530: and bcso.line_id = bcolu.line_id
2531: and ri.organization_id = bcso.organization_id
2532: and NOT EXISTS
2533: (select NULL
2534: from mtl_related_items
2535: where inventory_item_id = bcolu.config_item_id
2536: and organization_id = bcso.organization_id);
2537:
2538: WriteToLog('Inserted rows into mtl_related_items:: '||sql%rowcount,2);

Line 2538: WriteToLog('Inserted rows into mtl_related_items:: '||sql%rowcount,2);

2534: from mtl_related_items
2535: where inventory_item_id = bcolu.config_item_id
2536: and organization_id = bcso.organization_id);
2537:
2538: WriteToLog('Inserted rows into mtl_related_items:: '||sql%rowcount,2);
2539:
2540: /*--------------------------------------------------+
2541: Copy substitute inventories
2542: +--------------------------------------------------*/