APPS.BOMPINRV dependencies on MTL_ITEM_REVISIONS_TL

Line 106: -- description is stored in MTL_ITEM_REVISIONS_TL

102: new_item_revision,
103: 1) RETURNING revision_id INTO i_revision_id;
104:
105: SELECT userenv('LANG') INTO i_language_code FROM dual;
106: -- description is stored in MTL_ITEM_REVISIONS_TL
107: insert into MTL_ITEM_REVISIONS_TL (
108: inventory_item_id,
109: organization_id,
110: revision_id,

Line 107: insert into MTL_ITEM_REVISIONS_TL (

103: 1) RETURNING revision_id INTO i_revision_id;
104:
105: SELECT userenv('LANG') INTO i_language_code FROM dual;
106: -- description is stored in MTL_ITEM_REVISIONS_TL
107: insert into MTL_ITEM_REVISIONS_TL (
108: inventory_item_id,
109: organization_id,
110: revision_id,
111: language,

Line 134: from MTL_ITEM_REVISIONS_TL T

130: FROM FND_LANGUAGES lang
131: where lang.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from MTL_ITEM_REVISIONS_TL T
135: where T.INVENTORY_ITEM_ID = i_item_id
136: and T.ORGANIZATION_ID = i_org_id
137: and T.REVISION_ID = i_revision_id
138: and T.LANGUAGE = lang.LANGUAGE_CODE);