[Home] [Help]
155:
156: -- Actual Visit Start Date
157: CURSOR get_actual_start_date_csr(c_visit_id IN NUMBER) IS
158: SELECT ACTUAL_START_DATE
159: FROM AHL_WORKORDERS
160: WHERE VISIT_ID = c_visit_id
161: AND VISIT_TASK_ID IS NULL
162: AND MASTER_WORKORDER_FLAG = 'Y';
163:
230: --PRAKKUM :: 18/04/2012 :: Bug 13095151
231: -- To find visit master WO end date
232: CURSOR c_visit_mwo_end_date (c_id IN NUMBER) IS
233: /*SELECT WIP.scheduled_completion_date
234: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO
235: WHERE WO.VISIT_ID = c_id
236: AND WO.visit_task_id IS NULL
237: AND WO.master_workorder_flag = 'Y'
238: AND WO.wip_entity_id = WIP.wip_entity_id;*/
236: AND WO.visit_task_id IS NULL
237: AND WO.master_workorder_flag = 'Y'
238: AND WO.wip_entity_id = WIP.wip_entity_id;*/
239: SELECT max(WIP.scheduled_completion_date) AS scheduled_completion_date
240: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO
241: WHERE WO.VISIT_ID = c_id
242: AND WO.STATUS_CODE NOT IN ('7', '22') -- Exclude canceled and deleted work orders
243: AND WO.wip_entity_id = WIP.wip_entity_id;
244:
308: AND status_code = 'PLANNING';*/
309: CURSOR get_visit_tasks(x_visit_id IN NUMBER) IS
310: SELECT tsk.visit_task_id visit_task_id, tsk.stage_id stage_id
311: FROM AHL_VISIT_TASKS_B tsk
312: , ahl_workorders wo
313: WHERE tsk.visit_id = x_visit_id
314: AND tsk.status_code = 'PLANNING'
315: AND tsk.visit_task_id = wo.visit_task_id(+)
316: AND ((wo.workorder_id is NULL)
513: AND vt.visit_task_id = p_task_id;*/
514: CURSOR get_visit_dets(p_task_id IN NUMBER) IS
515: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time
516: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt
517: , ahl_workorders wo
518: WHERE v.visit_id = vt.visit_id
519: AND vt.visit_task_id = p_task_id
520: AND vt.visit_task_id = wo.visit_task_id(+)
521: AND ((wo.workorder_id is NULL)