APPS.GMD_SS_LOT_WF_PKG SQL Statements

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

Line: 86

SELECT  DISTINCT a.lot_number ,b.meaning, e.ss_no, f.description,e.inventory_item_id,
	g.concatenated_segments item_no, e.revision item_revision,
        g.description item_desc1,  h.organization_code, e.owner, e.ss_id,
        a.sample_qty, a.sample_quantity_uom
 FROM   gmd_ss_material_sources a,
        gmd_Qc_status b,
        gmd_stability_studies_b e ,
        gmd_stability_studies_tl f ,
        mtl_system_items_kfv g,
        mtl_parameters h
 WHERE  a.source_id = l_event_key
   AND a.ss_id = e.ss_id
   AND e.ss_id = f.ss_id
  AND b.entity_type = 'STABILITY'
  AND b.status_code = e.status
  AND g.inventory_item_id = e.inventory_item_id
  AND g.organization_id = e.organization_id
  AND h.organization_id = e.organization_id
  AND f.language = userenv('LANG');

Line: 107

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

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

Line: 176

				  select user_name into l_user from fnd_user
					 where user_id = l_owner;

Line: 183

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

Line: 186

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

Line: 292

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

Line: 355

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

Line: 369

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

Line: 372

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

Line: 384

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

Line: 432

select  distinct b.batch_no,a.recipe_no, c.recipe_version,
   h.sample_qty, h.sample_quantity_uom , h.storage_subinventory, k.concatenated_segments storage_locator,
   h.resources, i.spec_name, i.spec_vers, h.scheduled_start_date
 , j.formula_no, j.formula_vers , d.package_name
 from   gmd_ss_material_sources a,
        gme_batch_header b,
        gmd_recipes c,
        gmd_ss_storage_package d,
        gmd_stability_studies_b e ,
        gmd_stability_studies_tl f ,
        gmd_ss_variants h,
        gmd_specifications i,
        fm_form_mst j,
        mtl_item_locations_kfv k
 where  a.source_id = l_source
     and a.recipe_id = c.recipe_id(+)
     and a.batch_id = b.batch_id(+)
     and a.ss_id = e.ss_id
     and h.material_source_id = a.source_id
     and h.storage_spec_id = i.spec_id
     and h.package_id = d.package_id(+)
     and d.formula_id = j.formula_id(+)
     and h.storage_locator_id = k.inventory_location_id(+) ;