APPS.AHL_VWP_RULES_PVT dependencies on AHL_WORKORDERS

Line 3334: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3330:
3331: -- To find if job exists for the visit at shop floor not in Cancelled-7 Or Deleted-22
3332: CURSOR c_job(x_id IN NUMBER) IS
3333: SELECT AWO.STATUS_CODE, FLV.MEANING
3334: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3335: WHERE AWO.VISIT_ID = x_id
3336: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3337: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3338: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+)

Line 3345: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3341:
3342: -- To find if job exists for the Task/MR at shop floor not in Cancelled-7 Or Deleted-22
3343: CURSOR c_job_tsk(x_id IN NUMBER)IS
3344: SELECT AWO.STATUS_CODE, FLV.MEANING
3345: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3346: WHERE AWO.VISIT_TASK_ID = x_id
3347: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3348: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3349: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+);

Line 4802: SELECT wip_entity_id FROM ahl_workorders

4798: -- When the first RTS workorder is added to a visit
4799: -- move the items in the repair batch to the inrepair locator
4800: -- Cursor to get the RTS workorder for a repair batch
4801: CURSOR c_get_rts_wo_id(p_rpr_batch_task_id NUMBER, p_instance_id NUMBER) IS
4802: SELECT wip_entity_id FROM ahl_workorders
4803: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
4804: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
4805: AND visit_task_id IN
4806: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt