eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MOBILE_LOVS dependencies on MTL_RESERVATIONS

Line 91: FROM mtl_reservations mr,

87: NVL(RTRIM(lpn.LICENSE_PLATE_NUMBER),' '), /*Bug9483781*/
88: nvl(mr.secondary_reservation_quantity,0), /*Bug7041074*/
89: mr.reservation_id,
90: lo.inventory_location_id
91: FROM mtl_reservations mr,
92: wms_item_locations_kfv lo,
93: wms_license_plate_numbers lpn
94: WHERE lo.inventory_location_id(+) = mr.locator_id
95: AND mr.organization_id = p_org_id

Line 2405: mtl_reservations mr

2401: SELECT DISTINCT msi.secondary_inventory_name
2402: , msi.description
2403: , NVL(msi.locator_type, 1)
2404: FROM mtl_secondary_inventories msi,
2405: mtl_reservations mr
2406: WHERE mr.organization_id = p_organization_id
2407: AND mr.inventory_item_id = p_item_id
2408: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2409: AND demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2442: mtl_reservations mr

2438: , msi.description
2439: , NVL(msi.locator_type, 1)
2440: , mr.revision
2441: FROM mtl_secondary_inventories msi,
2442: mtl_reservations mr
2443: WHERE mr.subinventory_code = msi.secondary_inventory_name
2444: AND mr.organization_id = p_organization_id
2445: AND mr.inventory_item_id = p_item_id
2446: AND demand_source_header_id = p_batch_id

Line 2665: mtl_reservations mr

2661: SELECT a.concatenated_segments,
2662: a.description,
2663: a.inventory_location_id
2664: FROM wms_item_locations_kfv a,
2665: mtl_reservations mr
2666: WHERE mr.organization_id = p_organization_id
2667: AND mr.inventory_item_id = p_item_id
2668: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2669: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2701: mtl_reservations mr

2697: SELECT a.concatenated_segments,
2698: a.description,
2699: a.inventory_location_id
2700: FROM wms_item_locations_kfv a,
2701: mtl_reservations mr
2702: WHERE mr.locator_id = a.inventory_location_id
2703: AND mr.organization_id = p_organization_id
2704: AND mr.inventory_item_id = p_item_id
2705: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2871: FROM mtl_reservations mr,

2867: SELECT DISTINCT mln.lot_number
2868: i, TO_CHAR(mln.expiration_date, l_date_format)
2869: , mln.grade_code
2870: , mln.parent_lot_number
2871: FROM mtl_reservations mr,
2872: mtl_lot_numbers mln
2873: WHERE mr.organization_id = p_organization_id
2874: AND mr.organization_id = mln.organization_id
2875: AND mr.inventory_item_id = p_item_id

Line 2894: FROM mtl_reservations mr,

2890: SELECT DISTINCT mln.lot_number
2891: i, TO_CHAR(mln.expiration_date, l_date_format)
2892: , mln.grade_code
2893: , mln.parent_lot_number
2894: FROM mtl_reservations mr,
2895: mtl_lot_numbers mln
2896: WHERE mr.organization_id = p_organization_id
2897: AND mr.organization_id = mln.organization_id
2898: AND mr.inventory_item_id = p_item_id

Line 3833: FROM mtl_reservations

3829: IS
3830: BEGIN
3831: OPEN x_revision_cursor FOR
3832: SELECT DISTINCT revision
3833: FROM mtl_reservations
3834: WHERE organization_id = p_org_id
3835: AND demand_source_header_id = p_batch_id
3836: AND demand_source_line_id = p_material_detail_id
3837: AND demand_source_type_id = 5