APPS.GME_MOBILE_LOVS dependencies on GME_MATERIAL_DISPENSING_GTMP

Line 140: FROM gme_material_dispensing_gtmp d,

136: NULL, /*Bug9483781*/
137: d.secondary_dispensed_qty,
138: d.dispense_id,
139: lo.inventory_location_id
140: FROM gme_material_dispensing_gtmp d,
141: wms_item_locations_kfv lo
142: WHERE lo.inventory_location_id(+) = d.locator_id
143: AND lo.subinventory_code(+) = d.subinventory_code
144: ORDER BY d.dispense_id;

Line 2354: gme_material_dispensing_gtmp d

2350: , dispense_id
2351: ,d.revision
2352: FROM mtl_secondary_inventories s,
2353: wms_item_locations_kfv b,
2354: gme_material_dispensing_gtmp d
2355: WHERE
2356: d.subinventory_code LIKE (p_subinv_code)
2357: AND s.secondary_inventory_name = d.subinventory_code
2358: AND s.organization_id = p_organization_id

Line 2752: ||' gme_material_dispensing_gtmp t '

2748: ||' ,dispense_uom '
2749: ||' ,dispense_id '
2750: ||' ,t.revision '
2751: ||' FROM wms_item_locations_kfv a, '
2752: ||' gme_material_dispensing_gtmp t '
2753: ||' WHERE '
2754: ||' t.subinventory_code = :p_subinv_code '
2755: ||' AND a.subinventory_code = t.subinventory_code '
2756: ||' AND a.concatenated_segments LIKE (:p_locator_code) '

Line 3260: GME_MATERIAL_DISPENSING_GTMP

3256: dispense_uom,
3257: dispense_id,
3258: revision
3259: FROM
3260: GME_MATERIAL_DISPENSING_GTMP
3261: WHERE subinventory_code = NVL(p_subinv_code, subinventory_code)
3262: AND NVL(locator_id,-1) = NVL(p_locator_id, -1)
3263: AND lot_number LIKE (p_lot_number)
3264: ORDER BY lot_number;