APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_RELATED_ITEMS

Line 2316: Copy related items into MTL_RELATED_ITEMS table

2312: END IF; /* p_cat_id = -99 */
2313:
2314:
2315: /*----------------------------------------------------+
2316: Copy related items into MTL_RELATED_ITEMS table
2317: +----------------------------------------------------*/
2318:
2319: lStmtNumber := 140;
2320:

Line 2321: insert into MTL_RELATED_ITEMS

2317: +----------------------------------------------------*/
2318:
2319: lStmtNumber := 140;
2320:
2321: insert into MTL_RELATED_ITEMS
2322: (
2323: inventory_item_id,
2324: related_item_id,
2325: relationship_type_id,

Line 2354: from mtl_related_items ri,

2350: NULL, -- program_application_id
2351: NULL, -- program_id
2352: SYSDATE, -- program_update_date
2353: ri.organization_id
2354: from mtl_related_items ri,
2355: bom_cto_src_orgs bcso,
2356: bom_cto_order_lines_upg bcolu
2357: where bcolu.config_item_id is not null
2358: and bcolu.status = 'BCSO'

Line 2365: from mtl_related_items

2361: and bcso.line_id = bcolu.line_id
2362: and ri.organization_id = bcso.organization_id
2363: and NOT EXISTS
2364: (select NULL
2365: from mtl_related_items
2366: where inventory_item_id = bcolu.config_item_id
2367: and organization_id = bcso.organization_id);
2368:
2369: WriteToLog('Inserted rows into mtl_related_items:: '||sql%rowcount,2);

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

2365: from mtl_related_items
2366: where inventory_item_id = bcolu.config_item_id
2367: and organization_id = bcso.organization_id);
2368:
2369: WriteToLog('Inserted rows into mtl_related_items:: '||sql%rowcount,2);
2370:
2371: /*--------------------------------------------------+
2372: Copy substitute inventories
2373: +--------------------------------------------------*/