APPS.AHL_PRD_NONROUTINE_PUB SQL Statements

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

Line: 18

select user_id from fnd_user where user_name = p_user_id;

Line: 24

select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;

Line: 348

         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: 375

         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: 510

      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: 629

      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: 650

      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: 661

      SELECT	name,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
      WHERE    cs.incident_id = p_nr_task_rec.INCIDENT_ID
      AND      cs.incident_type_id = cs_incident_types_vl.incident_type_id;

Line: 672

      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: 685

      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: 695

      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: 770

		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: 783

      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: 802

      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: 826

      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: 839

			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: 852

		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: 867

		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: 879

      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;