APPS.GMD_QMTES SQL Statements

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

Line: 83

SELECT D.CONCATENATED_SEGMENTS,D.description,D.primary_uom_code,C.PARENT_LOT_NUMBER,C.LOT_NUMBER, wlpn.license_plate_number lpn,
       to_char(GR.RESULT_ID),A.TEST_CODE,A.TEST_DESC,A.TEST_CLASS,
       B.TEST_METHOD_CODE, B.TEST_METHOD_DESC,B.RESOURCES,B.TEST_REPLICATE,
	     C.LAB_ORGANIZATION_ID, C.SAMPLE_ID,C.SAMPLE_NO,C.SAMPLE_DESC,
	     C.SUBINVENTORY, gr.test_by_date, gr.planned_Resource, gr.planned_result_date,
       MIL.concatenated_segments, c.revision,
       c.source_subinventory, MIL1.concatenated_segments,c.source  --RLNAGARA B5738147
		from    GMD_RESULTS GR,
	        GMD_QC_TESTS_VL A,
	        GMD_TEST_METHODS B,
	        GMD_SAMPLES C,
	        mtl_system_items_kfv D,
--        mtl_lot_numbers E,
          mtl_parameters MP,
          mtl_item_locations_kfv MIL,
          mtl_item_locations_kfv MIL1,             --RLNAGARA B5738147
	  wms_license_plate_numbers wlpn   --RLNAGARA LPN ME 7027149
	WHERE       GR.SAMPLE_ID = l_event_key AND
	            GR.SAMPLE_ID=C.SAMPLE_ID AND
	            NVL(L_TEST_ID,GR.TEST_ID)=A.TEST_ID AND
	            A.TEST_METHOD_ID=B.TEST_METHOD_ID AND
	            C.ORGANIZATION_ID=D.ORGANIZATION_ID AND
--	            C.INVENTORY_ITEM_ID=E.INVENTORY_ITEM_ID(+) AND
	            C.INVENTORY_ITEM_ID= D.INVENTORY_ITEM_ID AND
--	            C.ORGANIZATION_ID = E.ORGANIZATION_ID AND
--	            C.LOT_NUMBER = E.LOT_NUMBER AND
                    C.organization_id = mp.organization_id AND
                    MIL.organization_id(+) = C.organization_id AND
                    MIL.inventory_location_id(+) = C.locator_id AND
                  MIL1.organization_id(+) = C.organization_id AND           --RLNAGARA B5738147
                  MIL1.inventory_location_id(+) = C.source_locator_id AND   --RLNAGARA B5738147
		  wlpn.lpn_id(+) = c.lpn_id;     -- RLNAGARA LPN ME 7027149

Line: 118

	  select nvl( text, '')
	from wf_Resources where name = 'WF_ADMIN_ROLE'
	and language = userenv('LANG')   ;

Line: 124

   SELECT organization_code
   FROM   mtl_parameters
   WHERE  organization_id = l_qc_lab_org_id;

Line: 146

      select application_id into l_application_id
        from fnd_application where application_short_name='GMD';

Line: 207

               select user_name into l_user from fnd_user
        			 where user_id=Approver.user_id;

Line: 210

               select user_name into l_user from fnd_user
      	       where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line: 215

            Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
		Into l_sequence_id
		From dual;

Line: 224

	--insert into rg_debug(vdata) values(l_itemkey);

Line: 344

      	    ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
                                       transactionIdIn => l_result_id,
                                       approverIn => Approver,
                                       transactionTypeIn => l_transaction_type,
                                       forwardeeIn => ame_util.emptyApproverRecord);

Line: 404

         select application_id into l_application_id
           from fnd_application where application_short_name='GMD';

Line: 417

         select user_name into l_user from fnd_user
           where user_id=Approver.user_id;

Line: 420

	  select user_name into l_user from fnd_user
          where
          user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line: 432

          ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
                                       transactionIdIn => l_event_key,
                                       approverIn => Approver,
                                       transactionTypeIn => l_transaction_type,
                                       forwardeeIn => ame_util.emptyApproverRecord);