APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDERS

Line 240: ahl_workorders

236: IS
237: SELECT
238: workorder_id
239: FROM
240: ahl_workorders
241: WHERE
242: visit_id = p_visit_id AND
243: status_code not in (22, 7, 17) AND
244: master_workorder_flag <> 'Y';

Line 259: ahl_workorders wo

255: vtk.instance_id
256: FROM
257: ahl_visit_tasks_b vtk,
258: ahl_visits_b vst,
259: ahl_workorders wo
260: WHERE
261: wo.workorder_id = p_workorder_id AND
262: vtk.visit_task_id = wo.visit_task_id AND
263: vtk.visit_id = vst.visit_id;

Line 366: ahl_workorders

362: CURSOR c_validate_wo_status(p_workorder_id IN NUMBER) IS
363: SELECT
364: 'X'
365: FROM
366: ahl_workorders
367: WHERE
368: workorder_id = p_workorder_id AND
369: status_code in (7, 12, 22);
370:

Line 436: ahl_workorders

432: IS
433: SELECT
434: 'X'
435: FROM
436: ahl_workorders
437: WHERE
438: workorder_id = p_workorder_id AND
439: status_code in (4, 5, 7, 12, 22);
440: /*

Line 680: AHL_WORKORDERS AWOS,

676: IS
677: SELECT AWOS.STATUS_CODE,
678: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID)
679: FROM
680: AHL_WORKORDERS AWOS,
681: AHL_VISITS_B VST,
682: AHL_VISIT_TASKS_B VTS
683: WHERE
684: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND

Line 838: ahl_workorders

834: CURSOR c_validate_wo_status(p_workorder_id IN NUMBER) IS
835: SELECT
836: 'X'
837: FROM
838: ahl_workorders
839: WHERE
840: workorder_id = p_workorder_id AND
841: status_code in (1,4,5,7, 12,21, 22);
842:

Line 929: FROM AHL_WORKORDERS

925: -- cursor to retrieve the workorder status
926: CURSOR get_wo_status (c_wo_id NUMBER)
927: IS
928: SELECT STATUS_CODE
929: FROM AHL_WORKORDERS
930: WHERE WORKORDER_ID = c_wo_id;
931:
932: l_return_value VARCHAR2(1);
933: l_wo_status VARCHAR2(30);

Line 995: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP

991: -- cursor to retrieve whether workorder is released
992: CURSOR is_workorders_released(c_wo_id NUMBER)
993: IS
994: SELECT 'x'
995: FROM AHL_WORKORDERS WO,wip_discrete_jobs WIP
996: WHERE WO.wip_entity_id = WIP.wip_entity_id
997: AND WIP.date_released IS NOT NULL AND
998: WO.WORKORDER_ID = c_wo_id;
999:

Line 1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1515: p_workorder_id IN NUMBER,
1516: p_operation_seq_num IN NUMBER) IS
1517: SELECT MIN(AWAS.ASSIGN_START_DATE)
1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1520: WHERE WOR.resource_id = AOR.resource_id
1521: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1522: AND AOR.operation_resource_id = AWAS.operation_resource_id
1523: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1598: p_workorder_id IN NUMBER,
1599: p_operation_seq_num IN NUMBER) IS
1600: SELECT MAX(AWAS.ASSIGN_END_DATE)
1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1603: WHERE WOR.resource_id = AOR.resource_id
1604: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1605: AND AOR.operation_resource_id = AWAS.operation_resource_id
1606: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1717: AHL_WORKORDERS AHLW,

1713: WIPO.organization_id,
1714: WIPO.department_id
1715:
1716: FROM WIP_OPERATIONS WIPO,
1717: AHL_WORKORDERS AHLW,
1718: AHL_WORKORDER_OPERATIONS AWO,
1719: AHL_OPERATION_RESOURCES AOR
1720:
1721: WHERE WIPO.wip_entity_id = AHLW.wip_entity_id

Line 1741: AHL_WORKORDERS AHLW,

1737: WIPO.organization_id,
1738: WIPO.department_id
1739: FROM
1740: WIP_OPERATIONS WIPO,
1741: AHL_WORKORDERS AHLW,
1742: AHL_WORKORDER_OPERATIONS AWO,
1743: AHL_OPERATION_RESOURCES AOR
1744: WHERE
1745: WIPO.wip_entity_id = AHLW.wip_entity_id

Line 1845: select plan_id,collection_id from ahl_workorders where workorder_id = P_workorder_id;

1841: l_plan_id NUMBER;
1842: l_qa_status VARCHAR2(25);
1843:
1844: CURSOR get_qa_info_csr(P_workorder_id NUMBER) IS
1845: select plan_id,collection_id from ahl_workorders where workorder_id = P_workorder_id;
1846:
1847: begin
1848: OPEN get_qa_info_csr(P_workorder_id);
1849: FETCH get_qa_info_csr INTO l_plan_id,l_qa_collection_id;