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_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 558: from ahl_workorder_operations

554:
555: --To check that the operation sequence exists for the work order.
556: CURSOR ahl_wo_Oper_csr (p_wo_id in number, p_op_seq_num in number) IS
557: select workorder_operation_id
558: from ahl_workorder_operations
559: where workorder_id= p_wo_id
560: and operation_sequence_num = p_op_seq_num;
561:
562: -- Get workorder details.

Line 3000: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo

2996: -- To get latest material issue txn for the item instance.
2997: CURSOR ahl_mtl_txn_csr (p_Item_Instance_Id IN NUMBER,
2998: p_workorder_id IN NUMBER) IS
2999: SELECT workorder_mtl_txn_id
3000: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo
3001: WHERE mt.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3002: AND TRANSACTION_TYPE_ID = 35 -- issues.
3003: AND woo.workorder_id = p_workorder_id
3004: ORDER by mt.TRANSACTION_DATE DESC, mt.LAST_UPDATE_DATE DESC;

Line 3028: FROM ahl_part_changes pc, ahl_workorder_operations woo

3024: -- To get latest removal or swap parts change txn.
3025: CURSOR ahl_part_chg_csr (p_Item_Instance_Id IN NUMBER,
3026: p_workorder_id IN NUMBER) IS
3027: SELECT pc.part_change_id, pc.object_version_number
3028: FROM ahl_part_changes pc, ahl_workorder_operations woo
3029: WHERE pc.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3030: AND pc.removed_instance_id = p_item_instance_id
3031: AND woo.workorder_id = p_workorder_id
3032: AND pc.return_mtl_txn_id IS NULL

Line 3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo

3087: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3088: loc.subinventory_code, awo.operation_sequence_num
3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3090: ahl_workorders wo, ahl_visits_b vst,
3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3092: WHERE disp.instance_id = csi.instance_id
3093: AND disp.part_change_id = p_part_change_id
3094: AND disp.workorder_id = wo.workorder_id
3095: AND wo.visit_id = vst.visit_id