DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_SYSTEM_ITEMS_B

Line 2200: FROM mtl_system_items_b msi, gme_material_details gmd

2196:
2197: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2198: CURSOR get_item_duom_ctl IS
2199: SELECT NVL(tracking_quantity_ind, 'P')
2200: FROM mtl_system_items_b msi, gme_material_details gmd
2201: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2202: gmd.organization_id = msi.organization_id AND
2203: gmd.material_detail_id = p_material_detail_id;
2204:

Line 2328: FROM mtl_system_items_b msi, gme_material_details gmd

2324:
2325: -- nsinghi bug#5236702. Set secondary qty only if item is DUOM controlled.
2326: CURSOR get_item_duom_ctl IS
2327: SELECT NVL(tracking_quantity_ind, 'P')
2328: FROM mtl_system_items_b msi, gme_material_details gmd
2329: WHERE gmd.inventory_item_id = msi.inventory_item_id AND
2330: gmd.organization_id = msi.organization_id AND
2331: gmd.material_detail_id = p_material_detail_id;
2332: