APPS.GMD_QM_UOM SQL Statements

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

Line: 89

	SELECT  H.INVENTORY_ITEM_ID,
        	K.concatenated_segments, -- Item Number
		H.parent_lot_number,
        	K.description,
        	H.lot_number,
        	I.organization_code,
		H.organization_id,
		H.revision,
        	H.subinventory,
        	MIL.concatenated_segments , -- Locator
        	H.disposition,
        	h.source,
        	h.sample_taken_cnt,
		h.receipt_id,
        	H.RECEIPT_LINE_ID,
        	H.PO_HEADER_ID ,
	        H.PO_LINE_ID ,
        	H.SUPPLIER_ID ,
		H.SUPPLIER_LOT_NO ,
	        E.test_id ,
	        F.spec_id ,
	        E.from_qty_uom,
	        E.to_qty_uom,
		E.CURRENT_CONVERSION ,
	        E.PROPOSED_CONVERSION ,
	        E.from_qty_uom_base ,
	        E.to_qty_uom_base ,
		E.PROPOSED_CONVERSION_BASE,
                E.result_id
        from    GMD_UOM_CONVERSIONS E,
		gmd_event_spec_disp F,
		gmd_sampling_events H,
		mtl_parameters  I,
		mtl_item_locations_kfv MIL,
		mtl_system_items_kfv K
 	where   e.EVENT_SPEC_DISP_ID = l_event_key and
       		e.EVENT_SPEC_DISP_ID = f.event_spec_disp_id and
	   	f.sampling_event_id = h.SAMPLING_EVENT_ID and
       		I.organization_id = H.organization_id and
       		MIL.organization_id(+) = H.organization_id and
       		MIL.inventory_location_id(+) = H.locator_id and
       		K.organization_id = H.organization_id and
       		K.inventory_item_id = H.inventory_item_id and
       		e.recommended_ind = 'Y';

Line: 137

	select spec_name , spec_vers, owner_id
	from gmd_specifications
	where spec_id = spec_id_in ;

Line: 142

	select test_desc
	from gmd_qc_tests
	where test_id = test_id_in;

Line: 147

	select vendor_name
	from po_vendors
	where vendor_id = vendor_id_in ;

Line: 152

	select segment1
	from po_headers_all
	where po_header_id = po_header_in ;

Line: 157

	select line_num
	from po_lines_all
	where po_line_id = po_line_in ;

Line: 162

	select receipt_num
	from rcv_shipment_headers
	where shipment_header_id = receipt_in ;

Line: 167

	select line_num
	from rcv_shipment_lines
	where shipment_line_id = receipt_line_in ;

Line: 175

	select   conversion_id
	from MTL_LOT_UOM_CLASS_CONVERSIONS
        where inventory_item_id = item_id_in
        and   organization_id = org_id_in
	and   lot_number = lot_number_in
	and   from_uom_code = from_uom_in
	and   to_uom_code = to_uom_in;

Line: 189

       SELECT meaning
       FROM   fnd_lookup_values
       WHERE  lookup_TYPE = 'GMD_QC_SAMPLE_DISP'
       AND    language = USERENV('LANG')
       AND    lookup_code = disp_in ;

Line: 197

       SELECT description
       FROM   fnd_lookup_values
       WHERE  lookup_TYPE like 'GMD_QC_SOURCE'
       AND    language = USERENV('LANG')
       AND    lookup_code = item_source_in ;

Line: 204

       SELECT description
       FROM   fnd_lookup_values
       WHERE  lookup_TYPE like 'GMD_QC_MONITOR_RULE_TYPE'
       AND    language = USERENV('LANG')
       AND    lookup_code = mon_source_in ;

Line: 211

        select LOT_CONTROL_CODE
        from mtl_system_items_kfv
        where inventory_item_id = item_no_in;

Line: 217

	select 	lot_number
	from 	mtl_lot_numbers
	where 	parent_lot_number = l_parent_lot_number_in  and
      		organization_id = l_organization_id_in   and
      		inventory_item_id = l_item_id_in ;

Line: 225

       select user_name
	 from fnd_user
     	 where user_id = owner_id_in;

Line: 230

	select UOM_CLASS from mtl_units_of_measure  -- SCHANDRU INVCONV
	where uom_code = uom_code_in ;

Line: 235

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

Line: 262

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

Line: 398

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

Line: 401

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

Line: 571

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

Line: 734

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

Line: 798

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

Line: 812

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

Line: 815

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

Line: 827

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