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 73: FROM mtl_reservations mr,

69: TO_CHAR(mr.requirement_date,l_date_format),
70: nvl(mr.secondary_reservation_quantity,0), /*Bug7041074*/
71: mr.reservation_id,
72: lo.inventory_location_id
73: FROM mtl_reservations mr,
74: wms_item_locations_kfv lo
75: WHERE lo.inventory_location_id(+) = mr.locator_id
76: AND mr.organization_id = p_org_id
77: AND mr.demand_source_type_id = 5

Line 2378: mtl_reservations mr

2374: SELECT DISTINCT msi.secondary_inventory_name
2375: , msi.description
2376: , NVL(msi.locator_type, 1)
2377: FROM mtl_secondary_inventories msi,
2378: mtl_reservations mr
2379: WHERE mr.organization_id = p_organization_id
2380: AND mr.inventory_item_id = p_item_id
2381: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2382: AND demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2415: mtl_reservations mr

2411: , msi.description
2412: , NVL(msi.locator_type, 1)
2413: , mr.revision
2414: FROM mtl_secondary_inventories msi,
2415: mtl_reservations mr
2416: WHERE mr.subinventory_code = msi.secondary_inventory_name
2417: AND mr.organization_id = p_organization_id
2418: AND mr.inventory_item_id = p_item_id
2419: AND demand_source_header_id = p_batch_id

Line 2638: mtl_reservations mr

2634: SELECT a.concatenated_segments,
2635: a.description,
2636: a.inventory_location_id
2637: FROM wms_item_locations_kfv a,
2638: mtl_reservations mr
2639: WHERE mr.organization_id = p_organization_id
2640: AND mr.inventory_item_id = p_item_id
2641: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2642: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2674: mtl_reservations mr

2670: SELECT a.concatenated_segments,
2671: a.description,
2672: a.inventory_location_id
2673: FROM wms_item_locations_kfv a,
2674: mtl_reservations mr
2675: WHERE mr.locator_id = a.inventory_location_id
2676: AND mr.organization_id = p_organization_id
2677: AND mr.inventory_item_id = p_item_id
2678: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

Line 2844: FROM mtl_reservations mr,

2840: SELECT DISTINCT mln.lot_number
2841: i, TO_CHAR(mln.expiration_date, l_date_format)
2842: , mln.grade_code
2843: , mln.parent_lot_number
2844: FROM mtl_reservations mr,
2845: mtl_lot_numbers mln
2846: WHERE mr.organization_id = p_organization_id
2847: AND mr.organization_id = mln.organization_id
2848: AND mr.inventory_item_id = p_item_id

Line 2867: FROM mtl_reservations mr,

2863: SELECT DISTINCT mln.lot_number
2864: i, TO_CHAR(mln.expiration_date, l_date_format)
2865: , mln.grade_code
2866: , mln.parent_lot_number
2867: FROM mtl_reservations mr,
2868: mtl_lot_numbers mln
2869: WHERE mr.organization_id = p_organization_id
2870: AND mr.organization_id = mln.organization_id
2871: AND mr.inventory_item_id = p_item_id

Line 3749: FROM mtl_reservations

3745: IS
3746: BEGIN
3747: OPEN x_revision_cursor FOR
3748: SELECT DISTINCT revision
3749: FROM mtl_reservations
3750: WHERE organization_id = p_org_id
3751: AND demand_source_header_id = p_batch_id
3752: AND demand_source_line_id = p_material_detail_id
3753: AND demand_source_type_id = 5