APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_WORKORDERS

Line 327: FROM ahl_workorders wo,

323: x_sr_task_rec.Originating_wo_id := p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
324: BEGIN
325: SELECT csi.instance_number,vst.visit_number
326: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
327: FROM ahl_workorders wo,
328: ahl_visits_b vst,
329: ahl_visit_tasks_b tsk,
330: csi_item_instances csi
331: WHERE wo.visit_task_id = tsk.visit_task_id

Line 354: FROM AHL_WORKORDERS WO,

350: THEN
351: BEGIN
352: SELECT CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id
353: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
354: FROM AHL_WORKORDERS WO,
355: AHL_VISITS_B VST,
356: AHL_VISIT_TASKS_B TSK,
357: CSI_ITEM_INSTANCES CSI
358: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID

Line 757: FROM ahl_workorders

753: END IF;
754: BEGIN
755: /*SELECT workorder_name
756: INTO x_create_nr_output_rec.WORKORDER_NUMBER
757: FROM ahl_workorders
758: WHERE workorder_id = p_sr_task_rec.Nonroutine_wo_id;*/
759:
760: SELECT WO.workorder_id,WO.workorder_name
761: INTO x_create_nr_output_rec.WORKORDER_ID,x_create_nr_output_rec.WORKORDER_NUMBER

Line 762: FROM AHL_WORKORDERS WO,AHL_WORKORDERS WO1,

758: WHERE workorder_id = p_sr_task_rec.Nonroutine_wo_id;*/
759:
760: SELECT WO.workorder_id,WO.workorder_name
761: INTO x_create_nr_output_rec.WORKORDER_ID,x_create_nr_output_rec.WORKORDER_NUMBER
762: FROM AHL_WORKORDERS WO,AHL_WORKORDERS WO1,
763: WIP_SCHED_RELATIONSHIPS WOR
764: WHERE WOR.parent_object_id = WO1.wip_entity_id
765: AND WOR.child_object_id = WO.wip_entity_id
766: AND WO.master_workorder_flag = 'N'

Line 785: FROM ahl_workorders,

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

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

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