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_WORKORDER_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 11190: FROM ahl_workorder_mtl_txns amt, ahl_workorder_operations awo, ahl_workorders aw

11186: --allow cancelation if material have not been returned.
11187: -- check issue txns with return txns.
11188: CURSOR wo_material_csr(c_visit_id NUMBER ) IS
11189: SELECT INVENTORY_ITEM_ID, REVISION, LOT_NUMBER, SERIAL_NUMBER, sum(quantity) quantity
11190: FROM ahl_workorder_mtl_txns amt, ahl_workorder_operations awo, ahl_workorders aw
11191: WHERE aw.visit_id = c_visit_id
11192: and aw.workorder_id = awo.workorder_id
11193: and awo.workorder_operation_id = amt.workorder_operation_id
11194: and TRANSACTION_TYPE_ID = 35

Line 11198: FROM ahl_workorder_mtl_txns amt, ahl_workorder_operations awo, ahl_workorders aw

11194: and TRANSACTION_TYPE_ID = 35
11195: group by INVENTORY_ITEM_ID, REVISION, LOT_NUMBER, SERIAL_NUMBER
11196: MINUS
11197: SELECT INVENTORY_ITEM_ID, REVISION, LOT_NUMBER, SERIAL_NUMBER, sum(quantity) quantity
11198: FROM ahl_workorder_mtl_txns amt, ahl_workorder_operations awo, ahl_workorders aw
11199: WHERE aw.visit_id = c_visit_id
11200: and aw.workorder_id = awo.workorder_id
11201: and awo.workorder_operation_id = amt.workorder_operation_id
11202: and TRANSACTION_TYPE_ID = 43