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_OPERATIONS

Line 1162: FROM AHL_WORKORDER_OPERATIONS

1158: CURSOR c_get_op_actual_dates(c_workorder_id NUMBER)
1159: IS
1160: SELECT MIN(ACTUAL_START_DATE),
1161: MAX(ACTUAL_END_DATE)
1162: FROM AHL_WORKORDER_OPERATIONS
1163: WHERE WORKORDER_ID = c_workorder_id;
1164:
1165:
1166:

Line 2454: AHL_WORKORDER_OPERATIONS AWO

2450: WIPO.last_unit_completion_date scheduled_end_date
2451:
2452: FROM AHL_WORKORDERS AHLW,
2453: WIP_OPERATIONS WIPO,
2454: AHL_WORKORDER_OPERATIONS AWO
2455:
2456: WHERE AHLW.workorder_id = c_workorder_id
2457: AND AHLW.wip_entity_id = WIPO.wip_entity_id
2458: AND AHLW.workorder_id = AWO.workorder_id

Line 2460: -- clause added in order to use index AHL_WORKORDER_OPERATIONS_N1 (workorder_id, status_code)

2456: WHERE AHLW.workorder_id = c_workorder_id
2457: AND AHLW.wip_entity_id = WIPO.wip_entity_id
2458: AND AHLW.workorder_id = AWO.workorder_id
2459: AND WIPO.operation_seq_num = AWO.operation_sequence_num
2460: -- clause added in order to use index AHL_WORKORDER_OPERATIONS_N1 (workorder_id, status_code)
2461: AND AWO.status_code = G_OP_STATUS_UNCOMPLETE;
2462:
2463: -- Cursor for getting BOM resource details given workorder operation id and BOM resource id
2464: CURSOR get_oper_bom_res_csr (c_wo_oper_id NUMBER,

Line 2706: FROM AHL_WORKORDER_OPERATIONS

2702: -- Cursor for getting details of default Stage workorder operation
2703: CURSOR get_wo_oper_csr (c_workorder_id NUMBER)
2704: IS
2705: SELECT workorder_operation_id
2706: FROM AHL_WORKORDER_OPERATIONS
2707: WHERE workorder_id = c_workorder_id
2708: -- clause added in order to use index AHL_WORKORDER_OPERATIONS_N1 (workorder_id, status_code)
2709: AND status_code = G_OP_STATUS_UNCOMPLETE;
2710:

Line 2708: -- clause added in order to use index AHL_WORKORDER_OPERATIONS_N1 (workorder_id, status_code)

2704: IS
2705: SELECT workorder_operation_id
2706: FROM AHL_WORKORDER_OPERATIONS
2707: WHERE workorder_id = c_workorder_id
2708: -- clause added in order to use index AHL_WORKORDER_OPERATIONS_N1 (workorder_id, status_code)
2709: AND status_code = G_OP_STATUS_UNCOMPLETE;
2710:
2711: -- Cursor for getting all the BOM resource requirements for a workorder operation
2712: CURSOR get_oper_bom_res_csr (c_wo_operation_id NUMBER)

Line 3638: From AHL_WORKORDER_OPERATIONS AWO,

3634: AS
3635: (Select ARO.route_operation_id,
3636: AWO.operation_sequence_num
3637:
3638: From AHL_WORKORDER_OPERATIONS AWO,
3639: AHL_ROUTE_OPERATIONS ARO
3640:
3641: Where AWO.workorder_id = c_workorder_id
3642: AND AWO.operation_id = ARO.operation_id

Line 11122: from ahl_workorders awo, ahl_workorder_operations awop

11118: CURSOR op_complete_csr( c_visit_id NUMBER ) IS
11119: select 'x'
11120: from dual
11121: where exists (select 'x'
11122: from ahl_workorders awo, ahl_workorder_operations awop
11123: where awo.workorder_id = awop.workorder_id
11124: and awo.visit_id = c_visit_id
11125: and awop.status_code = '1'
11126: );

Line 11133: from ahl_workorders awo, ahl_workorder_operations awop, ahl_part_changes apc

11129: CURSOR part_chg_txn_csr( c_visit_id NUMBER ) IS
11130: select 'x'
11131: from dual
11132: where exists (select 'x'
11133: from ahl_workorders awo, ahl_workorder_operations awop, ahl_part_changes apc
11134: where awo.workorder_id = awop.workorder_id
11135: and awop.workorder_operation_id = apc.workorder_operation_id
11136: and awo.visit_id = c_visit_id
11137: );

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

Line 12168: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts,ahl_workorder_operations oper

12164: and wo.workorder_id = c_workorder_id;
12165: --Cursor to get Operation organization_id, seq_num and status_code
12166: CURSOR Get_Op_Details(c_workorder_op_id NUMBER) IS
12167: select vst.organization_id, oper.operation_sequence_num, oper.status_code, wo.workorder_id
12168: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts,ahl_workorder_operations oper
12169: where
12170: wo.visit_task_id = vts.visit_task_id
12171: and vts.visit_id = vst.visit_id
12172: and oper.workorder_id = wo.workorder_id