DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 11: FROM mtl_system_items_vl msi,

7: IS
8: l_return_value Varchar2(240);
9: CURSOR C_GET_BATCH_PRODUCT IS
10: SELECT msi.concatenated_segments
11: FROM mtl_system_items_vl msi,
12: gme_material_details gme
13: WHERE gme.organization_id = msi.organization_id
14: AND gme.inventory_item_id = msi.inventory_item_id
15: AND gme.line_type = 1

Line 30: FROM mtl_system_items_vl msi,

26: IS
27: l_return_value Varchar2(240);
28: CURSOR C_GET_BATCH_PRODUCT IS
29: SELECT msi.description
30: FROM mtl_system_items_vl msi,
31: gme_material_details gme
32: WHERE gme.organization_id = msi.organization_id
33: AND gme.inventory_item_id = msi.inventory_item_id
34: AND gme.line_type = 1