APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISITS_VL

Line 186: AHL_VISITS_VL VST,

182: WO.workorder_name job_number,
183: VST.ORGANIZATION_ID organization_id
184: from AHL_WORKORDERS WO,
185: WIP_DISCRETE_JOBS WDJ,
186: AHL_VISITS_VL VST,
187: AHL_VISIT_TASKS_VL VTS
188: where WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID and
189: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID and
190: VST.VISIT_ID = VTS.VISIT_ID and

Line 2829: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS

2825:
2826: --Begin Performance Tuning
2827: CURSOR get_wo_instance_id(p_workorder_id IN NUMBER) IS
2828: SELECT nvl(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
2829: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS
2830: WHERE workorder_id = p_workorder_id
2831: and WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
2832: AND VST.VISIT_ID=VTS.VISIT_ID;
2833: --End performance Tunning

Line 3880: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS

3876:
3877: --Begin Performance Tuning
3878: CURSOR get_wo_instance_id(p_workorder_id IN NUMBER) IS
3879: SELECT nvl(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
3880: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS
3881: WHERE workorder_id = p_workorder_id
3882: and WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
3883: AND VST.VISIT_ID=VTS.VISIT_ID;
3884: --End Performance Tuning