DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 938: * So, we have to fetch the description from mtl_system_items_vl instead of

934: RETURN NULL;
935: END IF;
936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description

Line 939: * mtl_item_flexfields, because mtl_system_items_vl view is based on

935: END IF;
936: /** Bug: 5504176
937: * Item description field is MLS(multi lingual support) complaint field.
938: * So, we have to fetch the description from mtl_system_items_vl instead of
939: * mtl_item_flexfields, because mtl_system_items_vl view is based on
940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description

Line 944: FROM mtl_system_items_vl --5504176

940: * mtl_system_items_tl table.
941: */
942: SELECT description
943: INTO x_item_description
944: FROM mtl_system_items_vl --5504176
945: WHERE organization_id = p_org_id
946: AND inventory_item_id = p_item_id;
947:
948: RETURN x_item_description;