APPS.GMD_SS_LATETEST_WF_PKG SQL Statements

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

Line: 75

select  distinct k.organization_code, b.meaning, e.ss_no, h.variant_no,f.description,
   h.samples_per_time_point , h.storage_subinventory, j.concatenated_segments storage_locator,
   h.resources, i.spec_name, i.spec_vers, c.scheduled_date,
   d.concatenated_segments item_no, d.description item_desc1, e. revision, c.sampling_event_id,
   e.owner , c.name
 from   gmd_ss_material_sources a,
        gmd_Qc_status b,
        gmd_ss_time_points c,
        mtl_system_items_b_kfv d,
        gmd_stability_studies_b e ,
        gmd_stability_studies_tl f ,
        gmd_ss_variants h,
        gmd_specifications i,
        mtl_item_locations_kfv j,
        mtl_parameters k
 where  c.time_point_id = l_event_key
       and c.variant_id = h.variant_id
       and h.material_source_id = a.source_id
       and a.ss_id = e.ss_id
       and d.inventory_item_id = e.inventory_item_id
       and d.organization_id = e.organization_id
       and h.material_source_id = a.source_id
       and c.spec_id = i.spec_id
       and e.ss_id = f.ss_id
       and b.entity_type = 'STABILITY'
       and b.status_code = e.status
       and h.storage_locator_id = j.inventory_location_id(+)
       and h.storage_organization_id = j.organization_id(+)
       and e.organization_id = k.organization_id ;

Line: 106

  select sample_no from gmd_samples
  where sampling_event_id = se_id ;

Line: 110

    select nvl( text, '')
	from wf_Resources where name = 'WF_ADMIN_ROLE'   --RLNAGARA B5654562 Changed from WF_ADMIN to WF_ADMIN_ROLE
   	and language = userenv('LANG');

Line: 136

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

Line: 182

      			  select user_name into l_user from fnd_user
        			 where user_id = l_owner;

Line: 189

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

Line: 192

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

Line: 305

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

Line: 360

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

Line: 374

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

Line: 377

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

Line: 389

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