APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 870: SELECT 'x' from ahl_workorder_tasks_v WO,AHL_UNIT_EFFECTIVITIES_B UE --Undid App usage related BLIND changes

866: AND unit_effectivity_id = p_unit_effectivity_id;
867:
868: -- to check whether ue is in production
869: CURSOR valid_deferral_csr(p_unit_effectivity_id IN NUMBER) IS
870: SELECT 'x' from ahl_workorder_tasks_v WO,AHL_UNIT_EFFECTIVITIES_B UE --Undid App usage related BLIND changes
871: WHERE WO.unit_effectivity_id = UE.unit_effectivity_id
872: AND NVL(UE.status_code,'x') NOT IN('ACCOMPLISHED','DEFERRED','EXCEPTION','TERMINATED','CANCELLED','MR-TERMINATE')
873: AND UE.unit_effectivity_id = p_unit_effectivity_id;
874:

Line 3706: FROM ahl_workorder_tasks_v WO

3702: CURSOR validate_approver_privilages(p_unit_effectivity_id IN NUMBER)IS
3703:
3704: /* replaced as this query does not pick up master workorders.
3705: SELECT WO.workorder_id
3706: FROM ahl_workorder_tasks_v WO
3707: WHERE WO.job_status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3708: AND WO.unit_effectivity_id = p_unit_effectivity_id; */
3709:
3710: SELECT WO.workorder_id

Line 5443: FROM ahl_workorder_tasks_v wo, ahl_unit_deferrals_b udf

5439: IS
5440: CURSOR wo_exists_csr(p_unit_deferral_id IN NUMBER) IS
5441: /* -- fix for bug# 6849943 (FP for Bug # 6815689).
5442: SELECT 'x'
5443: FROM ahl_workorder_tasks_v wo, ahl_unit_deferrals_b udf
5444: WHERE wo.unit_effectivity_id = udf.unit_effectivity_id
5445: AND udf.unit_deferral_id = p_unit_deferral_id;
5446: */
5447: