eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 634: FROM mtl_system_items_tl

630: l_update_child_rec := FALSE; --Bug: 5220205
631: -- Bug 4388141. Populate long description in l_item_rec.long_description
632: SELECT description , long_description
633: INTO l_item_rec.description , l_item_rec.long_description
634: FROM mtl_system_items_tl
635: WHERE inventory_item_id = l_item_rec.inventory_item_id
636: AND organization_id = l_item_rec.organization_id
637: AND language = userenv('LANG');
638:

Line 3984: INSERT INTO MTL_SYSTEM_ITEMS_TL(

3980: IF (P_Item_Rec.organization_id = Get_Master_Org_ID (P_Item_Rec.organization_id) ) THEN
3981: -- If the Org is master, insert the source language translated columns
3982: -- for child organizations.
3983:
3984: INSERT INTO MTL_SYSTEM_ITEMS_TL(
3985: INVENTORY_ITEM_ID,
3986: ORGANIZATION_ID,
3987: LANGUAGE,
3988: SOURCE_LANG,

Line 4012: FROM MTL_SYSTEM_ITEMS_TL T

4008: FROM FND_LANGUAGES L
4009: WHERE L.INSTALLED_FLAG in ('I', 'B')
4010: AND NOT EXISTS
4011: ( SELECT NULL
4012: FROM MTL_SYSTEM_ITEMS_TL T
4013: WHERE T.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4014: AND T.ORGANIZATION_ID = P_Item_Rec.ORGANIZATION_ID
4015: AND T.LANGUAGE = L.LANGUAGE_CODE);
4016: ELSE

Line 4019: INSERT INTO MTL_SYSTEM_ITEMS_TL (

4015: AND T.LANGUAGE = L.LANGUAGE_CODE);
4016: ELSE
4017: -- If the Org is not master, then while creating new child items,
4018: -- copy translated columns from the master item record.
4019: INSERT INTO MTL_SYSTEM_ITEMS_TL (
4020: INVENTORY_ITEM_ID,
4021: ORGANIZATION_ID,
4022: LANGUAGE,
4023: SOURCE_LANG,

Line 4044: MTL_SYSTEM_ITEMS_TL MSI,

4040: P_Item_Rec.CREATION_DATE,
4041: P_Item_Rec.CREATED_BY,
4042: P_Item_Rec.LAST_UPDATE_LOGIN
4043: FROM
4044: MTL_SYSTEM_ITEMS_TL MSI,
4045: MTL_PARAMETERS MP
4046: WHERE
4047: MSI.INVENTORY_ITEM_ID = P_Item_Rec.INVENTORY_ITEM_ID
4048: AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 5158: FROM MTL_SYSTEM_ITEMS_TL

5154: SELECT
5155: DESCRIPTION,
5156: LONG_DESCRIPTION,
5157: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
5158: FROM MTL_SYSTEM_ITEMS_TL
5159: WHERE INVENTORY_ITEM_ID = P_Item_Rec.inventory_item_id
5160: AND ORGANIZATION_ID = P_Item_rec.organization_id
5161: for update of INVENTORY_ITEM_ID nowait;
5162:

Line 5894: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T

5890:
5891: PROCEDURE ADD_LANGUAGE IS
5892: BEGIN
5893:
5894: /* DELETE FROM MTL_SYSTEM_ITEMS_TL T
5895: WHERE NOT EXISTS ( SELECT NULL
5896: FROM MTL_SYSTEM_ITEMS_B B
5897: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
5898: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);

Line 5900: UPDATE MTL_SYSTEM_ITEMS_TL T

5896: FROM MTL_SYSTEM_ITEMS_B B
5897: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
5898: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID);
5899:
5900: UPDATE MTL_SYSTEM_ITEMS_TL T
5901: SET( DESCRIPTION
5902: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
5903: , ltrim(rtrim(B.LONG_DESCRIPTION))
5904: FROM MTL_SYSTEM_ITEMS_TL B

Line 5904: FROM MTL_SYSTEM_ITEMS_TL B

5900: UPDATE MTL_SYSTEM_ITEMS_TL T
5901: SET( DESCRIPTION
5902: , LONG_DESCRIPTION) = (SELECT ltrim(rtrim(B.DESCRIPTION))
5903: , ltrim(rtrim(B.LONG_DESCRIPTION))
5904: FROM MTL_SYSTEM_ITEMS_TL B
5905: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
5906: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
5907: AND B.LANGUAGE = T.SOURCE_LANG)
5908: WHERE(T.INVENTORY_ITEM_ID

Line 5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,

5909: , T.ORGANIZATION_ID
5910: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
5911: SUBT.ORGANIZATION_ID,
5912: SUBT.LANGUAGE
5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,
5914: MTL_SYSTEM_ITEMS_TL SUBT
5915: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
5916: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
5917: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 5914: MTL_SYSTEM_ITEMS_TL SUBT

5910: , T.LANGUAGE) IN (SELECT SUBT.INVENTORY_ITEM_ID,
5911: SUBT.ORGANIZATION_ID,
5912: SUBT.LANGUAGE
5913: FROM MTL_SYSTEM_ITEMS_TL SUBB,
5914: MTL_SYSTEM_ITEMS_TL SUBT
5915: WHERE SUBB.INVENTORY_ITEM_ID = SUBT.INVENTORY_ITEM_ID
5916: AND SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
5917: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
5918: AND (( SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 5926: INSERT INTO MTL_SYSTEM_ITEMS_TL (

5922: or ( SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null )
5923: or ( SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null ))));
5924:
5925: */
5926: INSERT INTO MTL_SYSTEM_ITEMS_TL (
5927: INVENTORY_ITEM_ID,
5928: ORGANIZATION_ID,
5929: DESCRIPTION,
5930: LONG_DESCRIPTION,

Line 5950: FROM MTL_SYSTEM_ITEMS_TL B,

5946: B.CREATED_BY,
5947: B.LAST_UPDATE_LOGIN,
5948: L.LANGUAGE_CODE,
5949: B.SOURCE_LANG
5950: FROM MTL_SYSTEM_ITEMS_TL B,
5951: FND_LANGUAGES L
5952: WHERE L.INSTALLED_FLAG in ('I', 'B')
5953: AND B.LANGUAGE = userenv('LANG')
5954: AND NOT EXISTS( SELECT NULL

Line 5955: FROM MTL_SYSTEM_ITEMS_TL T

5951: FND_LANGUAGES L
5952: WHERE L.INSTALLED_FLAG in ('I', 'B')
5953: AND B.LANGUAGE = userenv('LANG')
5954: AND NOT EXISTS( SELECT NULL
5955: FROM MTL_SYSTEM_ITEMS_TL T
5956: WHERE T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
5957: AND T.ORGANIZATION_ID = B.ORGANIZATION_ID
5958: AND T.LANGUAGE = L.LANGUAGE_CODE);
5959:

Line 5982: FROM MTL_SYSTEM_ITEMS_TL

5978: ,LANGUAGE
5979: ,SOURCE_LANG
5980: ,DESCRIPTION
5981: ,LONG_DESCRIPTION
5982: FROM MTL_SYSTEM_ITEMS_TL
5983: WHERE INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
5984: AND ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
5985: FROM MTL_PARAMETERS
5986: WHERE MASTER_ORGANIZATION_ID = X_ORGANIZATION_ID

Line 6027: update mtl_system_items_tl

6023: app_exception.raise_exception;
6024: return ;
6025: end if;
6026: /*
6027: update mtl_system_items_tl
6028: set description = ltrim(rtrim(x_description)),
6029: long_description = ltrim(rtrim(x_long_description)),
6030: source_lang = x_language,
6031: last_updated_by = fnd_profile.value('USER_ID'),

Line 6040: update mtl_system_items_tl

6036: */
6037: for c1 in Item_csr
6038: loop
6039: if (l_desc_control = 1) then
6040: update mtl_system_items_tl
6041: set description = ltrim(rtrim(x_description)),
6042: source_lang = x_language,
6043: last_update_date = sysdate,
6044: last_updated_by = fnd_profile.value('USER_ID'),

Line 6051: update mtl_system_items_tl

6047:
6048: end if;
6049:
6050: if (l_longdesc_control = 1) then
6051: update mtl_system_items_tl
6052: set long_description = ltrim(rtrim(x_long_description)),
6053: source_lang = x_language,
6054: last_update_date = sysdate,
6055: last_updated_by = fnd_profile.value('USER_ID'),