APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDERS

Line 227: ahl_workorders

223: IS
224: SELECT
225: workorder_id
226: FROM
227: ahl_workorders
228: WHERE
229: visit_id = p_visit_id AND
230: status_code not in (22, 7, 17) AND
231: master_workorder_flag <> 'Y';

Line 246: ahl_workorders wo

242: vtk.instance_id
243: FROM
244: ahl_visit_tasks_b vtk,
245: ahl_visits_b vst,
246: ahl_workorders wo
247: WHERE
248: wo.workorder_id = p_workorder_id AND
249: vtk.visit_task_id = wo.visit_task_id AND
250: vtk.visit_id = vst.visit_id;

Line 353: ahl_workorders

349: CURSOR c_validate_wo_status(p_workorder_id IN NUMBER) IS
350: SELECT
351: 'X'
352: FROM
353: ahl_workorders
354: WHERE
355: workorder_id = p_workorder_id AND
356: status_code in (7, 12, 22);
357:

Line 423: ahl_workorders

419: IS
420: SELECT
421: 'X'
422: FROM
423: ahl_workorders
424: WHERE
425: workorder_id = p_workorder_id AND
426: status_code in (4, 5, 7, 12, 22);
427: /*

Line 660: AHL_WORKORDERS AWOS,

656: IS
657: SELECT AWOS.STATUS_CODE,
658: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID)
659: FROM
660: AHL_WORKORDERS AWOS,
661: AHL_VISITS_B VST,
662: AHL_VISIT_TASKS_B VTS
663: WHERE
664: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND

Line 818: ahl_workorders

814: CURSOR c_validate_wo_status(p_workorder_id IN NUMBER) IS
815: SELECT
816: 'X'
817: FROM
818: ahl_workorders
819: WHERE
820: workorder_id = p_workorder_id AND
821: status_code in (1,4,5,7, 12,21, 22);
822:

Line 909: FROM AHL_WORKORDERS

905: -- cursor to retrieve the workorder status
906: CURSOR get_wo_status (c_wo_id NUMBER)
907: IS
908: SELECT STATUS_CODE
909: FROM AHL_WORKORDERS
910: WHERE WORKORDER_ID = c_wo_id;
911:
912: l_return_value VARCHAR2(1);
913: l_wo_status VARCHAR2(30);

Line 975: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP

971: -- cursor to retrieve whether workorder is released
972: CURSOR is_workorders_released(c_wo_id NUMBER)
973: IS
974: SELECT 'x'
975: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP
976: WHERE WO.wip_entity_id = WIP.wip_entity_id
977: AND WIP.date_released IS NOT NULL AND
978: WO.WORKORDER_ID = c_wo_id;
979:

Line 1495: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1491: p_workorder_id IN NUMBER,
1492: p_operation_seq_num IN NUMBER) IS
1493: SELECT MIN(AWAS.ASSIGN_START_DATE)
1494: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1495: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1496: WHERE WOR.resource_id = AOR.resource_id
1497: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1498: AND AOR.operation_resource_id = AWAS.operation_resource_id
1499: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1578: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1574: p_workorder_id IN NUMBER,
1575: p_operation_seq_num IN NUMBER) IS
1576: SELECT MAX(AWAS.ASSIGN_END_DATE)
1577: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1578: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1579: WHERE WOR.resource_id = AOR.resource_id
1580: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1581: AND AOR.operation_resource_id = AWAS.operation_resource_id
1582: AND WOR.wip_entity_id = AW.wip_entity_id