APPS.AHL_VWP_TASKS_PVT dependencies on WIP_DISCRETE_JOBS

Line 265: WIP_DISCRETE_JOBS WIP

261: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
262: FROM AHL_WORKORDERS WO,
263: AHL_VISITS_B VST,
264: AHL_VISIT_TASKS_B VTS,
265: WIP_DISCRETE_JOBS WIP
266: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
267: AND WO.VISIT_ID = VST.VISIT_ID
268: AND WO.VISIT_ID = VTS.VISIT_ID(+)
269: AND WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID(+)

Line 822: FROM wip_discrete_jobs wdj,

818: */
819: -- AnRaj: Changed query for perf issue#2, Bug 4919465
820: wdj.scheduled_start_date scheduled_start_date,
821: wdj.scheduled_completion_date scheduled_end_date
822: FROM wip_discrete_jobs wdj,
823: ahl_workorders wo
824: WHERE wdj.wip_entity_id = wo.wip_entity_id
825: AND visit_id = p_visit_id
826: AND visit_task_id = p_visit_task_id;

Line 4941: FROM wip_discrete_jobs WHERE wip_entity_id =

4937: IS
4938: SELECT
4939: scheduled_start_date,
4940: SCHEDULED_COMPLETION_DATE
4941: FROM wip_discrete_jobs WHERE wip_entity_id =
4942: (
4943: SELECT
4944: wip_entity_id
4945: FROM ahl_workorders