APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SYSTEM_ITEMS_TL

Line 5535: oe_debug_pub.add('Create_Item: ' || 'going to insert:mtl_system_items_tl',2);

5531:
5532: -- end bugfix 1811007
5533:
5534:
5535: oe_debug_pub.add('Create_Item: ' || 'going to insert:mtl_system_items_tl',2);
5536:
5537: /*----------------------------------------+
5538: R11.5 MLS
5539: +----------------------------------------*/

Line 5543: insert into mtl_system_items_tl (

5539: +----------------------------------------*/
5540:
5541: lStmtNumber := 90;
5542:
5543: insert into mtl_system_items_tl (
5544: inventory_item_id,
5545: organization_id,
5546: language,
5547: source_lang,

Line 5569: mtl_system_items_tl m, -- 2457514

5565: gLoginId --last_update_login
5566: /*
5567: commented for reintroduction of bcso
5568: from
5569: mtl_system_items_tl m, -- 2457514
5570: fnd_languages l
5571: where m.inventory_item_id = pModelId
5572: and l.installed_flag In ('I', 'B')
5573: and l.language_code = m.language -- 2457514

Line 5576: from mtl_system_items_tl t

5572: and l.installed_flag In ('I', 'B')
5573: and l.language_code = m.language -- 2457514
5574: and NOT EXISTS
5575: (select NULL
5576: from mtl_system_items_tl t
5577: where t.inventory_item_id = pConfigId
5578: and t.organization_id = m.organization_id
5579: and t.language = m.language );
5580: */

Line 5583: mtl_system_items_tl m, -- 2457514

5579: and t.language = m.language );
5580: */
5581: from
5582: -- bugfix 2457514 mtl_system_items_b m, -- Model
5583: mtl_system_items_tl m, -- 2457514
5584: bom_cto_src_orgs bcso,
5585: fnd_languages l
5586: where m.inventory_item_id = pModelId
5587: and bcso.model_item_id = pModelId

Line 5594: from mtl_system_items_tl t

5590: and l.installed_flag In ('I', 'B')
5591: and l.language_code = m.language -- 2457514
5592: and NOT EXISTS
5593: (select NULL
5594: from mtl_system_items_tl t
5595: where t.inventory_item_id = pConfigId
5596: and t.organization_id = m.organization_id
5597: and t.language = l.language_code );
5598:

Line 5601: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_tl',2);

5597: and t.language = l.language_code );
5598:
5599:
5600: IF PG_DEBUG <> 0 THEN
5601: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_tl',2);
5602: END IF;
5603:
5604:
5605:

Line 7853: mtl_system_items_tl mtl

7849: l.language_code,
7850: userenv('lang')
7851: FROM fnd_languages l,
7852: mtl_cross_references_b mtl_cross,
7853: mtl_system_items_tl mtl
7854: WHERE mtl_cross.inventory_item_id = pConfigId
7855: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
7856: AND mtl_cross.organization_id = mtl.organization_id
7857: AND l.language_code = mtl.language

Line 9076: mtl_system_items_tl m,

9072: gUserId, --created_by
9073: gLoginId --last_update_login
9074: from
9075: mtl_parameters mp1,
9076: mtl_system_items_tl m,
9077: bom_cto_src_orgs bcso,
9078: fnd_languages l,
9079: mtl_item_revisions_b mr, --3338108
9080: mtl_parameters mp2 --4109427

Line 9111: oe_debug_pub.add('Inserted into mtl_system_items_tl.');

9107:
9108: --EXECUTE IMMEDIATE sql_stmt USING pConfigId,gUserId, gUserId, gLoginId, pModelId, pLineId, pConfigId,pConfigId; Bugfix 6063990
9109:
9110: IF PG_DEBUG <> 0 THEN
9111: oe_debug_pub.add('Inserted into mtl_system_items_tl.');
9112: END IF;
9113:
9114: EXCEPTION
9115: when OTHERS then