APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_WORKORDERS

Line 27: FROM AHL_WORKORDERS WO,

23: WDJ.scheduled_start_date,
24: WDJ.scheduled_completion_date,
25: WO.actual_start_date,
26: WO.actual_end_date
27: FROM AHL_WORKORDERS WO,
28: AHL_VISITS_B VST,
29: WIP_DISCRETE_JOBS WDJ
30: WHERE WO.workorder_id =c_workorder_id
31: AND WO.status_code <> '22'

Line 997: FROM AHL_WORKORDERS AWOS,

993: CURSOR get_wo_status(c_wo_id NUMBER)
994: IS
995: SELECT AWOS.status_code,
996: FNDL.meaning
997: FROM AHL_WORKORDERS AWOS,
998: FND_LOOKUP_VALUES_VL FNDL
999: WHERE AWOS.workorder_id = c_wo_id
1000: AND FNDL.LOOKUP_CODE(+) = AWOS.STATUS_CODE
1001: AND FNDL.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS';

Line 1009: AHL_WORKORDERS

1005: SELECT
1006: ACTUAL_START_DATE,
1007: ACTUAL_END_DATE
1008: FROM
1009: AHL_WORKORDERS
1010: WHERE
1011: WORKORDER_ID = c_wo_id;
1012: l_eam_enabled_flag VARCHAR2(1);
1013: l_return_status VARCHAR2(1);