APPS.MRP_GET_PROJECT SQL Statements

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

Line: 7

				select	segment1
				from	pa_projects_all
				where 	project_id = arg_project_id
				union
				select	project_number
				from	mrp_seiban_numbers
				where 	project_id = arg_project_id;

Line: 38

	select	task_number
	into	var_task_num
	from	pa_tasks
	where	task_id = arg_task_id;

Line: 55

	select	DISTINCT planning_group
	into	var_plng_grp
	from	mrp_project_parameters
	where	project_id = arg_project_id;

Line: 68

               select meaning
               from   fnd_lookups
               where  lookup_type = arg_lookup_type and lookup_code = arg_lookup_code;

Line: 91

   select lv.meaning
   into meaning_text
   from mfg_lookups lv
   where   lv.lookup_type = arg_lookup_type
   and   lv.lookup_code = arg_lookup_code;

Line: 110

   select organization_code
   into org_code
   from mtl_parameters
   where  organization_id = arg_org_id;

Line: 130

   select concatenated_segments
   into item_text
   from mtl_system_items_kfv
   where  organization_id = arg_org_id
     and  inventory_item_id = arg_item_id;

Line: 151

   select description
   into item_desc
   from mtl_system_items_kfv
   where  organization_id = arg_org_id
     and  inventory_item_id = arg_item_id;

Line: 172

   select mcvl.description
   into category_desc
   from mtl_categories_vl mcvl,
        mtl_category_sets mcs
   where  mcs.category_set_id = arg_cat_set_id
     and  mcs.structure_id = mcvl.structure_id
     and  mcvl.category_id = arg_cat_id;

Line: 194

   select concatenated_segments
   into category_name
   from mtl_categories_kfv
   where  category_id = arg_cat_id;

Line: 212

   select P.party_name
   into cust_name
   from HZ_CUST_ACCOUNTS  A,
        HZ_PARTIES P
   where  A.cust_account_id = arg_cust_id
   AND    A.PARTY_ID = P.PARTY_ID ;

Line: 232

   select A.address1
   into address_name
   from   hz_locations A,
          HZ_PARTY_SITES PS1,
          HZ_CUST_ACCT_SITES_ALL AS1,
          hz_cust_site_uses_all SU
   where  SU.site_use_id = arg_site_id
    AND SU.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID
    AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID
    AND PS1.LOCATION_ID = A.LOCATION_ID ;

Line: 257

   SELECT vendor_site_code INTO v_vendor_site_code
   FROM po_vendor_sites_all site,
        org_organization_definitions ood
   WHERE site.vendor_site_id = arg_vendor_site_id
   AND     nvl(site.org_id,nvl(ood.operating_unit,-1)) =
                                 nvl(ood.operating_unit,-1)
   AND     ood.organization_id = arg_org_id;