APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISITS_VL

Line 188: AHL_VISITS_VL VST,

184: VST.ORGANIZATION_ID organization_id,
185: VST.VISIT_ID visit_id
186: from AHL_WORKORDERS WO,
187: WIP_DISCRETE_JOBS WDJ,
188: AHL_VISITS_VL VST,
189: AHL_VISIT_TASKS_VL VTS
190: where WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID and
191: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID and
192: VST.VISIT_ID = VTS.VISIT_ID and

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

3248:
3249: --Begin Performance Tuning
3250: CURSOR get_wo_instance_id(p_workorder_id IN NUMBER) IS
3251: SELECT nvl(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
3252: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS
3253: WHERE workorder_id = p_workorder_id
3254: and WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
3255: AND VST.VISIT_ID=VTS.VISIT_ID;
3256: --End performance Tunning

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

4336:
4337: --Begin Performance Tuning
4338: CURSOR get_wo_instance_id(p_workorder_id IN NUMBER) IS
4339: SELECT nvl(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID)
4340: FROM ahl_workorders wo, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS
4341: WHERE workorder_id = p_workorder_id
4342: and WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
4343: AND VST.VISIT_ID=VTS.VISIT_ID;
4344: --End Performance Tuning