APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDERS

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

920: -- Contrast this with the earlier cursor valid_deferral_csr, which handles SRs with no MRs and plain MRs
921: CURSOR valid_sr_deferral_csr (p_ue_id in number)
922: IS
923: SELECT 'x'
924: FROM ahl_workorders WO, ahl_visits_b VS, ahl_visit_tasks_b VST, ahl_unit_effectivities_b UE
925: WHERE WO.master_workorder_flag = 'Y'
926: /* to filter out draft / deleted WOs */
927: AND WO.STATUS_CODE NOT IN ( '17' , '22' )
928: /* to check whether visit available in client's organization */

Line 1007: FROM ahl_workorders wo,

1003:
1004: -- to detemine whether deferral is done from UMP
1005: CURSOR wo_exists_csr(p_unit_effectivity_id IN NUMBER) IS
1006: SELECT 'x'
1007: FROM ahl_workorders wo,
1008: ahl_visit_tasks_b vts
1009: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
1010: AND wo.STATUS_CODE NOT IN ( '17' , '22' )
1011: AND vts.unit_effectivity_id = p_unit_effectivity_id

Line 3867: FROM ahl_workorders wo, ahl_visit_tasks_b vts,

3863: WHERE WO.job_status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3864: AND WO.unit_effectivity_id = p_unit_effectivity_id; */
3865:
3866: SELECT WO.workorder_id
3867: FROM ahl_workorders wo, ahl_visit_tasks_b vts,
3868: ahl_visits_b vst,
3869: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V
3870: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
3871: WHERE wo.visit_task_id = vts.visit_task_id

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

3886: WO.status_code,
3887: WO.actual_start_date,
3888: WO.actual_end_date,
3889: WO.workorder_name
3890: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST
3891: WHERE WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3892: AND WO.master_workorder_flag = 'N'
3893: AND WO.visit_task_id = VST.visit_task_id
3894: AND VST.unit_effectivity_id = UE.unit_effectivity_id

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

3899: WO.status_code,
3900: WO.actual_start_date,
3901: WO.actual_end_date,
3902: WO.workorder_name
3903: FROM ahl_workorders WO , ahl_unit_effectivities_b UE, ahl_visit_tasks_b VST
3904: WHERE WO.status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3905: AND WO.master_workorder_flag = 'N'
3906: AND WO.visit_task_id = VST.visit_task_id
3907: AND VST.unit_effectivity_id = UE.unit_effectivity_id

Line 3921: SELECT object_version_number from ahl_workorders

3917: -- rroy
3918: -- ACL Changes
3919:
3920: CURSOR workorder_objver_csr(p_workorder_id IN NUMBER) IS
3921: SELECT object_version_number from ahl_workorders
3922: WHERE workorder_id = p_workorder_id;
3923:
3924: --Changes by nsikka for Bug 5324101
3925: --Cursor added to fetch UE Title to be passed as token

Line 3942: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO

3938:
3939: -- fix for bug number 6990380
3940: CURSOR chk_inst_in_job (p_workorder_id IN NUMBER) IS
3941: SELECT 'x'
3942: FROM CSI_ITEM_INSTANCES CII, AHL_WORKORDERS AWO
3943: WHERE CII.WIP_JOB_ID = AWO.WIP_ENTITY_ID
3944: AND AWO.workorder_id = p_workorder_id
3945: AND ACTIVE_START_DATE <= SYSDATE
3946: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))

Line 5922: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,

5918: AND udf.unit_deferral_id = p_unit_deferral_id;
5919: */
5920:
5921: SELECT 'x'
5922: FROM ahl_workorders wo, ahl_unit_deferrals_b udf,
5923: ahl_visit_tasks_b vts, ahl_visits_b vst,
5924: (SELECT ORGANIZATION_ID
5925: FROM INV_ORGANIZATION_INFO_V
5926: WHERE NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG