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.AHL_MM_RESERVATIONS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1512: FROM mtl_serial_numbers

1508:
1509: CURSOR get_subinv_locator_csr(c_serial_number IN VARCHAR2,c_inventory_item_id IN NUMBER, c_org_id IN NUMBER)
1510: IS
1511: SELECT current_subinventory_code,current_locator_id,lot_number,revision,reservation_id
1512: FROM mtl_serial_numbers
1513: WHERE serial_number = c_serial_number
1514: AND inventory_item_id = c_inventory_item_id
1515: AND current_organization_id = c_org_id;
1516:

Line 2262: FROM mtl_serial_numbers MSN, mtl_reservations MR

2258:
2259: CURSOR get_resrv_detials_csr(c_serial_number IN VARCHAR2,c_reservation_id IN NUMBER)
2260: IS
2261: SELECT MR.inventory_item_id,MR.primary_reservation_quantity
2262: FROM mtl_serial_numbers MSN, mtl_reservations MR
2263: WHERE MSN.serial_number = c_serial_number
2264: AND MSN.reservation_id = c_reservation_id
2265: AND MR.reservation_id = MSN.reservation_id
2266: AND MR.inventory_item_id = MSN.inventory_item_id