DBA Data[Home] [Help]

APPS.PO_LINES_SV4_832_UPDATE dependencies on MTL_SYSTEM_ITEMS_TL

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

365: if X_item_id is not null then -- item exists in item master.
366:
367: /** Bug 5366732 If foreign language is used then item_desc comparision was always
368: Failing because derived value of X_item_description was coming from
369: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
370: from mtl_system_items_tl **/
371:
372: X_msi_item_description:=null;
373:

Line 370: from mtl_system_items_tl **/

366:
367: /** Bug 5366732 If foreign language is used then item_desc comparision was always
368: Failing because derived value of X_item_description was coming from
369: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
370: from mtl_system_items_tl **/
371:
372: X_msi_item_description:=null;
373:
374: SELECT msi.allow_item_desc_update_flag,

Line 378: FROM mtl_system_items msi, mtl_system_items_tl mtl

374: SELECT msi.allow_item_desc_update_flag,
375: mtl.description
376: INTO X_allow_item_desc_update_flag,
377: X_msi_item_description
378: FROM mtl_system_items msi, mtl_system_items_tl mtl
379: WHERE mtl.inventory_item_id = msi.inventory_item_id
380: and mtl.organization_id = msi.organization_id
381: and mtl.language = USERENV('LANG')
382: and mtl.inventory_item_id = X_item_id

Line 461: UPDATE mtl_system_items_tl

457: /* Bug 2064714 - GMudgal
458: ** Added the following update statement since we need to update
459: ** the description in the tl table as well */
460:
461: UPDATE mtl_system_items_tl
462: SET description = x_item_description
463: WHERE inventory_item_id = X_item_id
464: AND organization_id = x_def_master_org_id
465: and language = USERENV('LANG');