APPS.PO_LINES_SV7 dependencies on MTL_SYSTEM_ITEMS_TL

Line 134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc

130: X_progress := '090';
131:
132: /** Bug 5366732 If foreign language is used then item_desc comparision was always
133: Failing because derived value of X_item_description was coming from
134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
135: from mtl_system_items_tl **/
136:
137:
138: SELECT msi.allow_item_desc_update_flag,

Line 135: from mtl_system_items_tl **/

131:
132: /** Bug 5366732 If foreign language is used then item_desc comparision was always
133: Failing because derived value of X_item_description was coming from
134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
135: from mtl_system_items_tl **/
136:
137:
138: SELECT msi.allow_item_desc_update_flag,
139: mtl.description

Line 142: FROM mtl_system_items msi, mtl_system_items_tl mtl

138: SELECT msi.allow_item_desc_update_flag,
139: mtl.description
140: INTO X_allow_item_desc_update_flag,
141: X_msi_item_description
142: FROM mtl_system_items msi, mtl_system_items_tl mtl
143: WHERE mtl.inventory_item_id = msi.inventory_item_id
144: and mtl.organization_id = msi.organization_id
145: and mtl.language = USERENV('LANG')
146: and mtl.inventory_item_id = X_item_id