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 999: FROM AHL_WORKORDERS AWOS,

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

Line 1011: AHL_WORKORDERS

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