[Home] [Help]
1009: WriteToLog('Entering Update_Item_Data', 3);
1010: lStmtNumber := 10;
1011: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1012:
1013: insert into mtl_system_items_tl (
1014: inventory_item_id,
1015: organization_id,
1016: language,
1017: source_lang,
1034: sysdate,
1035: gUserId, --created_by
1036: gLoginId --last_update_login
1037: from
1038: mtl_system_items_tl m,
1039: bom_cto_src_orgs bcso,
1040: bom_cto_order_lines_upg bcolu,
1041: fnd_languages l
1042: where bcolu.config_item_id is not null
1048: and l.installed_flag In ('I', 'B')
1049: and l.language_code = m.language
1050: and NOT EXISTS
1051: (select NULL
1052: from mtl_system_items_tl t
1053: where t.inventory_item_id = bcolu.config_item_id
1054: and t.organization_id = bcso.organization_id
1055: and t.language = l.language_code );
1056:
1053: where t.inventory_item_id = bcolu.config_item_id
1054: and t.organization_id = bcso.organization_id
1055: and t.language = l.language_code );
1056:
1057: WriteToLog('Inserted rows into mtl_system_items_tl:: '||sql%rowcount,2);
1058:
1059: lStmtNumber := 20;
1060: insert into MTL_PENDING_ITEM_STATUS (
1061: inventory_item_id,
1192: sysdate,
1193: gUserId, --created_by
1194: gLoginId --last_update_login
1195: from
1196: mtl_system_items_tl m,
1197: bom_cto_src_orgs bcso,
1198: fnd_languages l,
1199: mtl_item_revisions_b mr --3338108
1200: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id
2682: l.language_code,
2683: userenv('lang')
2684: FROM fnd_languages l,
2685: mtl_cross_references_b mtl_cross,
2686: mtl_system_items_tl mtl
2687: WHERE mtl_cross.inventory_item_id = t_cfg_item_id(i)
2688: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
2689: AND mtl_cross.organization_id = mtl.organization_id
2690: AND l.language_code = mtl.language