APPS.GME_MOBILE_RSRV dependencies on MTL_RESERVATIONS

Line 78: FROM mtl_reservations mr

74: ,NVL(mr.SECONDARY_RESERVATION_QUANTITY,0)
75: ,mr.SECONDARY_UOM_CODE
76: ,mr.inventory_item_id
77: ,mr.revision
78: FROM mtl_reservations mr
79: WHERE mr.organization_id = p_organization_id
80: AND mr.inventory_item_id = p_item_id
81: AND mr.lot_number = p_lot_number;
82:

Line 128: FROM mtl_reservations mr,

124: OPEN x_rsrv_cursor FOR
125:
126: SELECT
127: mr.RESERVATION_ID
128: FROM mtl_reservations mr,
129: wms_item_locations_kfv loc
130: WHERE mr.organization_id = p_organization_id
131: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
132: AND mr.demand_source_header_id = p_batch_id

Line 212: FROM mtl_reservations mr,

208: ,mr.SECONDARY_UOM_CODE
209: ,mr.inventory_item_id
210: ,loc.concatenated_segments
211: ,mr.revision
212: FROM mtl_reservations mr,
213: wms_item_locations_kfv loc
214: WHERE mr.organization_id = p_organization_id
215: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
216: AND mr.demand_source_header_id = p_batch_id

Line 288: FROM mtl_reservations mr,

284: ,mr.SECONDARY_UOM_CODE
285: ,mr.inventory_item_id
286: ,loc.concatenated_segments
287: ,mr.revision
288: FROM mtl_reservations mr,
289: wms_item_locations_kfv loc
290: WHERE mr.organization_id = p_organization_id
291: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
292: AND mr.demand_source_header_id = p_batch_id