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_PRD_DISPOSITION_PVT dependencies on MTL_LOT_NUMBERS

Line 1360: SELECT 'x' FROM mtl_lot_numbers

1356: WHERE wo.workorder_id = p_workorder_id
1357: AND wo.visit_id = vi.visit_id;
1358:
1359: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
1360: SELECT 'x' FROM mtl_lot_numbers
1361: WHERE lot_number = p_lot_number
1362: AND inventory_item_id = p_inventory_item_id
1363: UNION
1364: SELECT 'x' FROM csi_item_instances csi

Line 2863: SELECT 'x' FROM mtl_lot_numbers

2859: WHERE serial_number = p_serial_number
2860: AND inventory_item_id = p_inventory_item_id;
2861: ******/
2862: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
2863: SELECT 'x' FROM mtl_lot_numbers
2864: WHERE lot_number = p_lot_number
2865: AND inventory_item_id = p_inventory_item_id
2866: UNION
2867: SELECT 'x' FROM csi_item_instances csi