APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SYSTEM_ITEMS_TL

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

5687:
5688: -- end bugfix 1811007
5689:
5690:
5691: oe_debug_pub.add('Create_Item: ' || 'going to insert:mtl_system_items_tl',2);
5692:
5693: /*----------------------------------------+
5694: R11.5 MLS
5695: +----------------------------------------*/

Line 5699: insert into mtl_system_items_tl (

5695: +----------------------------------------*/
5696:
5697: lStmtNumber := 90;
5698:
5699: insert into mtl_system_items_tl (
5700: inventory_item_id,
5701: organization_id,
5702: language,
5703: source_lang,

Line 5726: mtl_system_items_tl m, -- 2457514

5722: gLoginId --last_update_login
5723: /*
5724: commented for reintroduction of bcso
5725: from
5726: mtl_system_items_tl m, -- 2457514
5727: fnd_languages l
5728: where m.inventory_item_id = pModelId
5729: and l.installed_flag In ('I', 'B')
5730: and l.language_code = m.language -- 2457514

Line 5733: from mtl_system_items_tl t

5729: and l.installed_flag In ('I', 'B')
5730: and l.language_code = m.language -- 2457514
5731: and NOT EXISTS
5732: (select NULL
5733: from mtl_system_items_tl t
5734: where t.inventory_item_id = pConfigId
5735: and t.organization_id = m.organization_id
5736: and t.language = m.language );
5737: */

Line 5740: mtl_system_items_tl m, -- 2457514

5736: and t.language = m.language );
5737: */
5738: from
5739: -- bugfix 2457514 mtl_system_items_b m, -- Model
5740: mtl_system_items_tl m, -- 2457514
5741: bom_cto_src_orgs bcso,
5742: fnd_languages l
5743: where
5744: --m.inventory_item_id = pModelId -- bugfix 12809414

Line 5753: from mtl_system_items_tl t

5749: and l.installed_flag In ('I', 'B')
5750: and l.language_code = m.language -- 2457514
5751: and NOT EXISTS
5752: (select NULL
5753: from mtl_system_items_tl t
5754: where t.inventory_item_id = pConfigId
5755: and t.organization_id = m.organization_id
5756: and t.language = l.language_code );
5757:

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

5756: and t.language = l.language_code );
5757:
5758:
5759: IF PG_DEBUG <> 0 THEN
5760: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_tl',2);
5761: END IF;
5762:
5763:
5764:

Line 8038: mtl_system_items_tl mtl

8034: l.language_code,
8035: userenv('lang')
8036: FROM fnd_languages l,
8037: mtl_cross_references_b mtl_cross,
8038: mtl_system_items_tl mtl
8039: WHERE mtl_cross.inventory_item_id = pConfigId
8040: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
8041: AND mtl_cross.organization_id = mtl.organization_id
8042: AND l.language_code = mtl.language

Line 9377: mtl_system_items_tl m,

9373: gUserId, --created_by
9374: gLoginId --last_update_login
9375: from
9376: mtl_parameters mp1,
9377: mtl_system_items_tl m,
9378: bom_cto_src_orgs bcso,
9379: fnd_languages l,
9380: mtl_item_revisions_b mr, --3338108
9381: mtl_parameters mp2 --4109427

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

9408:
9409: --EXECUTE IMMEDIATE sql_stmt USING pConfigId,gUserId, gUserId, gLoginId, pModelId, pLineId, pConfigId,pConfigId; Bugfix 6063990
9410:
9411: IF PG_DEBUG <> 0 THEN
9412: oe_debug_pub.add('Inserted into mtl_system_items_tl.');
9413: END IF;
9414:
9415: EXCEPTION
9416: when OTHERS then