DBA Data[Home] [Help]

APPS.GME_MOBILE_RSRV dependencies on WMS_ITEM_LOCATIONS_KFV

Line 129: wms_item_locations_kfv loc

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
133: AND mr.demand_source_line_id = p_material_detail_id

Line 213: wms_item_locations_kfv loc

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
217: AND mr.demand_source_line_id = p_material_detail_id

Line 289: wms_item_locations_kfv loc

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
293: AND mr.demand_source_line_id = p_material_detail_id