APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISIT_TASKS_VL

Line 189: AHL_VISIT_TASKS_VL VTS

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
193: WO.WORKORDER_ID = p_workorder_id;

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