APPS.AHL_VWP_TASKS_PVT dependencies on WIP_DISCRETE_JOBS

Line 289: WIP_DISCRETE_JOBS WIP

285: NVL2( WO.VISIT_TASK_ID,VTS.SERVICE_REQUEST_ID,TO_NUMBER(NULL)) INCIDENT_ID
286: FROM AHL_WORKORDERS WO,
287: AHL_VISITS_B VST,
288: AHL_VISIT_TASKS_B VTS,
289: WIP_DISCRETE_JOBS WIP
290: WHERE WIP.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
291: AND WO.VISIT_ID = VST.VISIT_ID
292: AND WO.VISIT_ID = VTS.VISIT_ID(+)
293: AND WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID(+)

Line 940: FROM wip_discrete_jobs wdj,

936: */
937: -- AnRaj: Changed query for perf issue#2, Bug 4919465
938: wdj.scheduled_start_date scheduled_start_date,
939: wdj.scheduled_completion_date scheduled_end_date
940: FROM wip_discrete_jobs wdj,
941: ahl_workorders wo
942: WHERE wdj.wip_entity_id = wo.wip_entity_id
943: AND visit_id = p_visit_id
944: AND visit_task_id = p_visit_task_id;

Line 5895: FROM wip_discrete_jobs WHERE wip_entity_id =

5891: IS
5892: SELECT
5893: scheduled_start_date,
5894: SCHEDULED_COMPLETION_DATE
5895: FROM wip_discrete_jobs WHERE wip_entity_id =
5896: (
5897: SELECT
5898: wip_entity_id
5899: FROM ahl_workorders