APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDERS

Line 898: FROM ahl_workorders WO, ahl_visits_b VS, ahl_visit_tasks_b VST, ahl_unit_effectivities_b UE

894: -- Contrast this with the earlier cursor valid_deferral_csr, which handles SRs with no MRs and plain MRs
895: CURSOR valid_sr_deferral_csr (p_ue_id in number)
896: IS
897: SELECT 'x'
898: FROM ahl_workorders WO, ahl_visits_b VS, ahl_visit_tasks_b VST, ahl_unit_effectivities_b UE
899: WHERE WO.master_workorder_flag = 'Y'
900: /* to filter out draft / deleted WOs */
901: AND WO.STATUS_CODE NOT IN ( '17' , '22' )
902: /* to check whether visit available in client's organization */

Line 3711: FROM ahl_workorders wo, ahl_visit_tasks_b vts,

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
3711: FROM ahl_workorders wo, ahl_visit_tasks_b vts,
3712: ahl_visits_b vst,
3713: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V
3714: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
3715: WHERE wo.visit_task_id = vts.visit_task_id

Line 3734: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST

3730: WO.status_code,
3731: WO.actual_start_date,
3732: WO.actual_end_date,
3733: WO.workorder_name
3734: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST
3735: WHERE WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3736: AND WO.master_workorder_flag = 'N'
3737: AND WO.visit_task_id = VST.visit_task_id
3738: AND VST.unit_effectivity_id = UE.unit_effectivity_id

Line 3747: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST

3743: WO.status_code,
3744: WO.actual_start_date,
3745: WO.actual_end_date,
3746: WO.workorder_name
3747: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST
3748: WHERE WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3749: AND WO.master_workorder_flag = 'N'
3750: AND WO.visit_task_id = VST.visit_task_id
3751: AND VST.unit_effectivity_id = UE.unit_effectivity_id

Line 3765: SELECT object_version_number from ahl_workorders

3761: -- rroy
3762: -- ACL Changes
3763:
3764: CURSOR workorder_objver_csr(p_workorder_id IN NUMBER) IS
3765: SELECT object_version_number from ahl_workorders
3766: WHERE workorder_id = p_workorder_id;
3767:
3768: --Changes by nsikka for Bug 5324101
3769: --Cursor added to fetch UE Title to be passed as token

Line 3786: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO

3782:
3783: -- fix for bug number 6990380
3784: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3785: SELECT 'x'
3786: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3787: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3788: AND AWO.workorder_id = p_workorder_id
3789: AND ACTIVE_START_DATE <= SYSDATE
3790: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))

Line 5449: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,

5445: AND udf.unit_deferral_id = p_unit_deferral_id;
5446: */
5447:
5448: SELECT 'x'
5449: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,
5450: ahl_visit_tasks_b vts, ahl_visits_b vst,
5451: (SELECT ORGANIZATION_ID
5452: FROM INV_ORGANIZATION_INFO_V
5453: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG