APPS.GME_MOBILE_LOVS dependencies on GME_MATERIAL_DISPENSING_GTMP

Line 113: FROM gme_material_dispensing_gtmp d,

109: TO_CHAR(SYSDATE,l_date_format),
110: d.secondary_dispensed_qty,
111: d.dispense_id,
112: lo.inventory_location_id
113: FROM gme_material_dispensing_gtmp d,
114: wms_item_locations_kfv lo
115: WHERE lo.inventory_location_id(+) = d.locator_id
116: AND lo.subinventory_code(+) = d.subinventory_code
117: ORDER BY d.dispense_id;

Line 2327: gme_material_dispensing_gtmp d

2323: , dispense_id
2324: ,d.revision
2325: FROM mtl_secondary_inventories s,
2326: wms_item_locations_kfv b,
2327: gme_material_dispensing_gtmp d
2328: WHERE
2329: d.subinventory_code LIKE (p_subinv_code)
2330: AND s.secondary_inventory_name = d.subinventory_code
2331: AND s.organization_id = p_organization_id

Line 2725: ||' gme_material_dispensing_gtmp t '

2721: ||' ,dispense_uom '
2722: ||' ,dispense_id '
2723: ||' ,t.revision '
2724: ||' FROM wms_item_locations_kfv a, '
2725: ||' gme_material_dispensing_gtmp t '
2726: ||' WHERE '
2727: ||' t.subinventory_code = :p_subinv_code '
2728: ||' AND a.subinventory_code = t.subinventory_code '
2729: ||' AND a.concatenated_segments LIKE (:p_locator_code) '

Line 3176: GME_MATERIAL_DISPENSING_GTMP

3172: dispense_uom,
3173: dispense_id,
3174: revision
3175: FROM
3176: GME_MATERIAL_DISPENSING_GTMP
3177: WHERE subinventory_code = NVL(p_subinv_code, subinventory_code)
3178: AND NVL(locator_id,-1) = NVL(p_locator_id, -1)
3179: AND lot_number LIKE (p_lot_number)
3180: ORDER BY lot_number;