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 591: from ahl_workorder_operations

587:
588: --To check that the operation sequence exists for the work order.
589: CURSOR ahl_wo_Oper_csr (p_wo_id in number, p_op_seq_num in number) IS
590: select workorder_operation_id
591: from ahl_workorder_operations
592: where workorder_id= p_wo_id
593: and operation_sequence_num = p_op_seq_num;
594:
595: -- Get workorder details.

Line 3057: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo

3053: -- To get latest material issue txn for the item instance.
3054: CURSOR ahl_mtl_txn_csr (p_Item_Instance_Id IN NUMBER,
3055: p_workorder_id IN NUMBER) IS
3056: SELECT workorder_mtl_txn_id
3057: FROM ahl_workorder_mtl_txns mt, ahl_workorder_operations woo
3058: WHERE mt.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3059: AND TRANSACTION_TYPE_ID = 35 -- issues.
3060: AND woo.workorder_id = p_workorder_id
3061: ORDER by mt.TRANSACTION_DATE DESC, mt.LAST_UPDATE_DATE DESC;

Line 3085: FROM ahl_part_changes pc, ahl_workorder_operations woo

3081: -- To get latest removal or swap parts change txn.
3082: CURSOR ahl_part_chg_csr (p_Item_Instance_Id IN NUMBER,
3083: p_workorder_id IN NUMBER) IS
3084: SELECT pc.part_change_id, pc.object_version_number
3085: FROM ahl_part_changes pc, ahl_workorder_operations woo
3086: WHERE pc.WORKORDER_OPERATION_ID = woo.WORKORDER_OPERATION_ID
3087: AND pc.removed_instance_id = p_item_instance_id
3088: AND woo.workorder_id = p_workorder_id
3089: AND pc.return_mtl_txn_id IS NULL

Line 3148: mtl_item_locations_kfv loc, ahl_workorder_operations awo

3144: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3145: loc.subinventory_code, awo.operation_sequence_num
3146: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3147: ahl_workorders wo, ahl_visits_b vst,
3148: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3149: WHERE disp.instance_id = csi.instance_id
3150: AND disp.part_change_id = p_part_change_id
3151: AND disp.workorder_id = wo.workorder_id
3152: AND wo.visit_id = vst.visit_id