DBA Data[Home] [Help]

APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 1036: FROM mtl_system_items_tl msi_tl,

1032: -- Bug7039409: update po_attribute_values_tlp_draft.long_description
1033: -- Bug7722053: Added the condition to check the long desc value
1034: UPDATE po_attribute_values_tlp_draft pavd_tlp
1035: SET long_description = (SELECT long_description
1036: FROM mtl_system_items_tl msi_tl,
1037: fnd_languages lang
1038: WHERE msi_tl.inventory_item_id = pavd_tlp.inventory_item_id
1039: AND msi_tl.organization_id = l_master_org_id
1040: AND msi_tl.language = NVL(pavd_tlp.language,lang.language_code)