APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_WORKORDERS

Line 350: FROM ahl_workorders wo,

346: x_sr_task_rec.Originating_wo_id := p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
347: BEGIN
348: SELECT csi.instance_number,vst.visit_number
349: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
350: FROM ahl_workorders wo,
351: ahl_visits_b vst,
352: ahl_visit_tasks_b tsk,
353: csi_item_instances csi
354: WHERE wo.visit_task_id = tsk.visit_task_id

Line 377: FROM AHL_WORKORDERS WO,

373: THEN
374: BEGIN
375: SELECT CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id
376: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
377: FROM AHL_WORKORDERS WO,
378: AHL_VISITS_B VST,
379: AHL_VISIT_TASKS_B TSK,
380: CSI_ITEM_INSTANCES CSI
381: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID

Line 772: FROM ahl_workorders

768: END IF;
769: BEGIN
770: SELECT workorder_name
771: INTO x_create_nr_output_rec.WORKORDER_NUMBER
772: FROM ahl_workorders
773: WHERE workorder_id = p_sr_task_rec.Nonroutine_wo_id;
774: EXCEPTION
775: WHEN OTHERS THEN
776: NULL;

Line 788: FROM ahl_workorders,

784: INTO x_create_nr_output_rec.ORIGINATOR_WORKORDER_NUMBER,
785: x_create_nr_output_rec.ORIGINATOR_VISIT_ID,
786: x_create_nr_output_rec.ORIGINATOR_VISIT_NUMBER,
787: x_create_nr_output_rec.ORIGINATOR_TASK
788: FROM ahl_workorders,
789: ahl_visits_b vst
790: WHERE workorder_id = p_sr_task_rec.ORIGINATING_WO_ID
791: AND vst.visit_id = ahl_workorders.visit_id(+);
792: EXCEPTION

Line 791: AND vst.visit_id = ahl_workorders.visit_id(+);

787: x_create_nr_output_rec.ORIGINATOR_TASK
788: FROM ahl_workorders,
789: ahl_visits_b vst
790: WHERE workorder_id = p_sr_task_rec.ORIGINATING_WO_ID
791: AND vst.visit_id = ahl_workorders.visit_id(+);
792: EXCEPTION
793: WHEN OTHERS THEN
794: NULL;
795: END;