APPS.AHL_PRD_DF_PVT dependencies on AHL_VISITS_B

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 956: from ahl_visits_b vst, ahl_simulation_plans_b sim

952: WHERE vts.unit_effectivity_id = UE.unit_effectivity_id
953: AND NVL(vts.status_code,'x') IN ('PLANNING')
954: AND vts.task_type_code = 'SUMMARY'
955: AND EXISTS (select 'x'
956: from ahl_visits_b vst, ahl_simulation_plans_b sim
957: where vst.simulation_plan_id = sim.simulation_plan_id(+)
958: and vst.visit_id = vts.visit_id
959: and sim.primary_plan_flag(+) = 'Y')
960: );

Line 3868: ahl_visits_b vst,

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
3872: AND vts.visit_id = vst.visit_id

Line 5402: SELECT VS.visit_id, VS.visit_number FROM ahl_visits_b VS,ahl_visit_tasks_b VST

5398: AND lookup_type = 'AHL_UNIT_EFFECTIVITY_STATUS';
5399:
5400: -- to fetch visit info
5401: CURSOR visit_info_csr(p_unit_effectivity_id IN NUMBER) IS
5402: SELECT VS.visit_id, VS.visit_number FROM ahl_visits_b VS,ahl_visit_tasks_b VST
5403: WHERE VST.visit_id = VS.visit_id
5404: AND VST.unit_effectivity_id = p_unit_effectivity_id;
5405:
5406: -- to check whether MR or any of its children has resettable counters

Line 5923: ahl_visit_tasks_b vts, ahl_visits_b vst,

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
5927: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID