APPS.AHL_PRD_NONROUTINE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 325

         SELECT   csi.instance_number,vst.visit_number
         INTO     x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
         FROM     ahl_workorders wo,
                  ahl_visits_b   vst,
                  ahl_visit_tasks_b tsk,
                  csi_item_instances csi
         WHERE    wo.visit_task_id  =  tsk.visit_task_id
         AND      vst.visit_id      =  tsk.visit_id
         AND      NVL(tsk.instance_id,vst.item_instance_id)=csi.instance_id
         AND      wo.workorder_id   = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;

Line: 352

         SELECT   CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id
         INTO     x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
         FROM     AHL_WORKORDERS WO,
                  AHL_VISITS_B   VST,
                  AHL_VISIT_TASKS_B TSK,
                  CSI_ITEM_INSTANCES CSI
         WHERE    WO.VISIT_TASK_ID  =  TSK.VISIT_TASK_ID
         AND      VST.VISIT_ID      =  TSK.VISIT_ID
         AND      NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID
         AND      WO.WORKORDER_NAME   = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;

Line: 495

      SELECT   instance_number,
               serial_number
      FROM     csi_item_instances csi,
               ahl_unit_config_headers uch
      WHERE    uch.name = p_unit_name
      AND      uch.csi_item_instance_id = csi.instance_id;

Line: 614

      SELECT   CS.PROBLEM_CODE,FLVT.MEANING,CS.RESOLUTION_CODE ,FLVT1.MEANING
      INTO     x_create_nr_output_rec.problem_code,
               x_create_nr_output_rec.problem_code_meaning,
               x_create_nr_output_rec.resolution_code,
               x_create_nr_output_rec.resolution_code_meaning
      FROM     cs_incidents_all_b CS,
               FND_LOOKUP_VALUES FLVT,
               FND_LOOKUP_VALUES FLVT1
      WHERE    FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
      AND      FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
      AND      FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
      AND      FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE
      AND      FLVT.LANGUAGE(+) = userenv('LANG')
      AND      FLVT1.LANGUAGE(+) = userenv('LANG')
      AND      incident_id = p_nr_task_rec.INCIDENT_ID;

Line: 635

      SELECT    sts.status_code,sts.name
      INTO         x_create_nr_output_rec.service_request_status_code,x_create_nr_output_rec.service_request_status
      FROM              cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts
      WHERE             cs.incident_id = p_nr_task_rec.INCIDENT_ID
      AND      sts.INCIDENT_STATUS_ID = cs.incident_Status_id;

Line: 646

      SELECT	cit.name,cit.incident_subtype
            INTO     x_create_nr_output_rec.SERVICE_REQUEST_TYPE,x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
            FROM     cs_incidents_all_b CS,cs_incident_types_vl cit
            WHERE    cs.incident_id = p_nr_task_rec.INCIDENT_ID
      AND      cs.incident_type_id = cit.incident_type_id;

Line: 657

      SELECT    mtl.concatenated_segments,csi.serial_number
      INTO              x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
      FROm              csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
      WHERE             csi.instance_id         = cs.customer_product_id
      and               csi.inventory_item_id   = mtl.inventory_item_id
      and               mtl.organization_id     = csi.inv_master_organization_id
      AND      cs.incident_id          = p_nr_task_rec.incident_id;

Line: 670

      SELECT   ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)
      INTO     x_create_nr_output_rec.unit_name
      FROM         cs_incidents_all_b cs
      WHERE    cs.incident_id = p_nr_task_rec.incident_id;

Line: 680

      SELECT    name
      INTO              x_create_nr_output_rec.SEVERITY_NAME
      FROM              cs_incident_severities_vl
      WHERE             incident_severity_id  = p_nr_task_rec.severity_id;

Line: 755

                /*SELECT        workorder_name
                INTO            x_create_nr_output_rec.WORKORDER_NUMBER
                FROM            ahl_workorders
                WHERE           workorder_id = p_sr_task_rec.Nonroutine_wo_id;*/

Line: 760

                SELECT  WO.workorder_id,WO.workorder_name
                INTO    x_create_nr_output_rec.WORKORDER_ID,x_create_nr_output_rec.WORKORDER_NUMBER
                FROM    AHL_WORKORDERS WO,AHL_WORKORDERS WO1,
                        WIP_SCHED_RELATIONSHIPS WOR
                WHERE   WOR.parent_object_id = WO1.wip_entity_id
                AND     WOR.child_object_id = WO.wip_entity_id
                AND     WO.master_workorder_flag = 'N'
                AND     WO.status_code <> '22'
                AND     WOR.parent_object_type_id = 1
                AND     wo1.workorder_id = p_sr_task_rec.Nonroutine_wo_id
                AND rownum < 2;

Line: 780

      SELECT   workorder_name,vst.visit_id,visit_number,visit_task_id
      INTO     x_create_nr_output_rec.ORIGINATOR_WORKORDER_NUMBER,
               x_create_nr_output_rec.ORIGINATOR_VISIT_ID,
               x_create_nr_output_rec.ORIGINATOR_VISIT_NUMBER,
               x_create_nr_output_rec.ORIGINATOR_TASK
      FROM     ahl_workorders,
               ahl_visits_b vst
      WHERE    workorder_id = p_sr_task_rec.ORIGINATING_WO_ID
      AND      vst.visit_id =  ahl_workorders.visit_id(+);

Line: 799

      SELECT   CS.PROBLEM_CODE,FLVT.MEANING,CS.RESOLUTION_CODE ,FLVT1.MEANING
      INTO     x_create_nr_output_rec.problem_code,
               x_create_nr_output_rec.problem_code_meaning,
               x_create_nr_output_rec.resolution_code,
               x_create_nr_output_rec.resolution_code_meaning
      FROM     cs_incidents_all_b CS,
               FND_LOOKUP_VALUES FLVT,
               FND_LOOKUP_VALUES FLVT1
      WHERE    FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
      AND      FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
      AND      FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
      AND      FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE
      AND      FLVT.LANGUAGE(+) = userenv('LANG')
      AND      FLVT1.LANGUAGE(+) = userenv('LANG')
      AND      incident_id = x_create_nr_output_rec.SERVICE_REQUEST_ID;

Line: 823

      SELECT    status_code
      INTO              x_create_nr_output_rec.SERVICE_REQUEST_STATUS_CODE
      FROM              CS_INCIDENT_STATUSES_B
      WHERE             INCIDENT_STATUS_ID = p_sr_task_rec.Status_id;

Line: 836

                        SELECT  incident_subtype
                        INTO            x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE
                        FROM            cs_incident_types_vl
                        WHERE           incident_Type_id = p_sr_task_rec.type_id;

Line: 849

                SELECT  mtl.concatenated_segments,csi.serial_number
                INTO            x_create_nr_output_rec.ITEM_NUMBER,x_create_nr_output_rec.SERIAL_NUMBER
                FROm            csi_item_instances csi, mtl_system_items_kfv mtl
                WHERE           csi.instance_id = p_sr_task_rec.instance_id
                and                     csi.inventory_item_id = mtl.inventory_item_id
                and                     mtl.organization_id = csi.INV_MASTER_ORGANIZATION_ID;

Line: 864

                SELECT   AHL_UTIL_UC_PKG.get_unit_name(p_sr_task_rec.instance_id)
           INTO         x_create_nr_output_rec.UNIT_NAME
                FROM            DUAL;

Line: 876

      SELECT    name
      INTO              x_create_nr_output_rec.SEVERITY_NAME
      FROM              cs_incident_severities_vl
      WHERE             incident_severity_id  = p_sr_task_rec.severity_id;