APPS.GMD_QMREJ SQL Statements

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

Line: 65

   select mp.organization_code, gse.sample_type, glk.meaning
   from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk
   where gse.sampling_event_id = l_event_key
   and gse.organization_id = mp.organization_id
   and glk.lookup_type = 'GMD_QC_SPEC_TYPE'
   and gse.sample_type = glk.lookup_code;

Line: 73

   select glk.meaning
   from gmd_sampling_events gse, gem_lookups glk
   where gse.sampling_event_id = l_event_key
   and glk.lookup_type = 'GMD_QC_SOURCE'
   and gse.source = glk.lookup_code;

Line: 80

   select glk.meaning
   from gmd_sampling_events gse, gem_lookups glk
   where gse.sampling_event_id = l_event_key
   and glk.lookup_type = 'GMD_QC_MONITOR_RULE_TYPE'
   and gse.source = glk.lookup_code;

Line: 89

   SELECT gse.resources, cr.resource_desc, ri.instance_number
   from cr_rsrc_mst cr,
        gmp_resource_instances ri,
        cr_rsrc_dtl cd,
        gmd_sampling_events gse
   WHERE gse.sampling_event_id = l_event_key
   and cr.resources = gse.resources
   and cd.resources = cr.resources
   and cd.organization_id = gse.organization_id
   and ri.resource_id = cd.resource_id
   and ri.instance_id = gse.instance_id;

Line: 103

   select a.ss_no, a.description, b.concatenated_segments, b.description, a.revision
   from gmd_stability_studies a,
        mtl_system_items_b_kfv b
   where a.ss_id = ss_id_in
   and b.inventory_item_id = a.inventory_item_id
   and b.organization_id = a.organization_id;

Line: 111

   select source , c.ss_id
   from gmd_sampling_events a,
        gmd_ss_variants b,
        gmd_stability_studies_b c,
        gmd_ss_time_points d
   where d.sampling_event_id = l_event_key
   and d.variant_id = b.variant_id
   and b.ss_id = c.ss_id
   and a.sampling_event_id = d.sampling_event_id ;

Line: 123

   select gse.subinventory, mil.concatenated_segments
   from gmd_sampling_events gse, mtl_item_locations_kfv mil
   WHERE sampling_event_id = l_event_key
   and mil.inventory_location_id = gse.locator_id
   and mil.organization_id = gse.organization_id;

Line: 130

   select source
   from gmd_Sampling_Events
   where sampling_event_id = l_event_key ;

Line: 135

   select nvl( text, '')
   from wf_Resources
   where name = 'WF_ADMIN_ROLE' ;

Line: 156

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

Line: 240

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

Line: 242

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

Line: 351

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

Line: 412

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

Line: 426

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

Line: 429

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

Line: 441

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