APPS.MSC_RP_RELEASE_PUB SQL Statements

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

Line: 77

select organization_id,sr_instance_id,compile_designator
from msc_plans
where plan_id=p_plan_id;

Line: 82

      SELECT sum(decode(ms.load_type,20,0,1)),
             sum(decode(ms.load_type,20,1,0)),
             sum(decode(mai.lrtype, 'I', 0,
                  decode(nvl(mai.st_status,0),3,1,0)))
      FROM msc_supplies ms,
           msc_apps_instances mai
      where ms.plan_id = pid
       and  ms.release_errors is null
       and  ms.load_type is not null
       and  ms.sr_instance_id = mai.instance_id
       and  ms.last_updated_by = decode(p_release_by_user,'Y', user_id,
                ms.last_updated_by)
       and ms.status = 0
       and ms.applied =2;

Line: 109

select 1 from dual
where exists  ( SELECT  /*+ first_rows */ 1
   FROM msc_demands md
      where md.plan_id = p_plan_id
       and  md.release_errors is null
       and  md.load_type =30
       and  MD.ORIGINATION_TYPE = 30
       and  md.last_updated_by = decode(p_release_by_user,'Y', user_id,
                md.last_updated_by)
       and md.status = 0
       and md.applied =2
     );

Line: 123

	  SELECT unique sr_instance_id
	  from MSC_PLAN_ORGANIZATIONS
	  where plan_id = p_plan_id;

Line: 186

   insert into msc_rp_release_status (
 		    release_session_id,
		    completion_pcnt,
		    status,
		    last_update_date,
		    last_updated_by,
		    creation_date,
		    created_by,
		    last_update_login)
	    values(
		    psid,
		    0,
                    1, --- releasing
		    sysdate,
		    user_id,
		    sysdate,
		    user_id,
		    1);

Line: 228

	     insert into msc_rp_release_results(
			    release_session_id,
			    instance_id,
			    release_code,
			    release_order_count,
			    release_request_id,
			    last_update_date,
			    last_updated_by,
			    creation_date,
			    created_by,
			    last_update_login)
		    values(
			    psid,
			    l_sr_instance_id ,
			    i,
			    null ,
			    null,
			    sysdate,
			    user_id,
			    sysdate,
			    user_id,
			    1);

Line: 303

   update  msc_rp_release_status set completion_pcnt=40
   where release_session_id=psid;

Line: 309

	    update msc_rp_release_results
	    set	release_order_count=loaded_jobs(i),
		release_request_id =wip_req_id(i)
	    where  release_session_id=psid
	    and    release_code=1
	    and instance_id = release_instance(i);

Line: 317

	    update msc_rp_release_results
	    set	release_order_count=resched_jobs(i),
		release_request_id =wip_req_id(i)
	    where  release_session_id=psid
	    and    release_code=2
	    and instance_id = release_instance(i);

Line: 325

	    update msc_rp_release_results
	    set	release_order_count=loaded_lot_jobs(i),
		release_request_id =osfm_req_id(i)
	    where  release_session_id=psid
	    and    release_code=3
	    and instance_id = release_instance(i);

Line: 332

	    update msc_rp_release_results
	    set	release_order_count=resched_lot_jobs(i),
		release_request_id =osfm_req_id(i)
	    where  release_session_id=psid
	    and    release_code=4
	    and instance_id = release_instance(i);

Line: 339

            update msc_rp_release_results
	    set	release_order_count=loaded_reqs(i),
		release_request_id =po_req_load_id(i)
	    where  release_session_id=psid
	    and    release_code=5
	    and instance_id = release_instance(i);

Line: 347

            update msc_rp_release_results
	    set	release_order_count=resched_reqs(i),
		release_request_id =po_req_resched_id(i)
	    where  release_session_id=psid
	    and    release_code=6
	    and instance_id = release_instance(i);

Line: 354

            update msc_rp_release_results
	    set	release_order_count=loaded_int_reqs(i),
		release_request_id =int_req_load_id(i)
	    where  release_session_id=psid
	    and    release_code=7
	    and instance_id = release_instance(i);

Line: 362

            update msc_rp_release_results
	    set	release_order_count=resched_int_reqs(i),
		release_request_id =int_req_resched_id(i)
	    where  release_session_id=psid
	    and    release_code=8
	    and instance_id = release_instance(i);

Line: 369

            update msc_rp_release_results
	    set	release_order_count=loaded_scheds(i),
		release_request_id =wip_req_id(i)
	    where  release_session_id=psid
	    and    release_code=9
	    and instance_id = release_instance(i);

Line: 405

   update  msc_rp_release_status set completion_pcnt=60
   where release_session_id=psid;

Line: 411

	    update msc_rp_release_results
	    set	release_order_count=p_po_res_count(i),
		release_request_id =p_po_res_id(i)
	    where  release_session_id=psid
	    and    release_code=10
	    and instance_id = p_released_inst(i);

Line: 447

	    update msc_rp_release_results
	    set	release_order_count=p_so_rel_count(i),
		release_request_id =p_so_rel_id(i)
	    where  release_session_id=psid
	    and    release_code=11
	    and instance_id = p_so_released_inst(i);

Line: 458

   update  msc_rp_release_status set completion_pcnt=100,status=2
   where release_session_id=psid;

Line: 466

   update  msc_rp_release_status set completion_pcnt=100,status=4
   where release_session_id=psid;

Line: 485

	select decode(apps_ver,3,nvl(allow_release_flag ,2)
                         ,4,nvl(allow_release_flag ,2)
   		      ,1) allow_release_flag,
	instance_code
	from msc_apps_instances
	where instance_id = nvl(p_sr_instance_id,-1);

Line: 512

   SELECT nvl(postprocessing_lead_time, 0)
      FROM  msc_system_items
      WHERE plan_id = p_plan_id
      AND   sr_instance_id = p_inst_id
      AND   ORGANIZATION_ID = p_org_id
      AND   INVENTORY_ITEM_ID = p_item_id;

Line: 582

     SELECT MRP.mrp_atp_schedule_temp_s.nextval
      INTO l_session_id
     FROM dual;

Line: 657

	SELECT employee_id
	FROM msc_planners
	WHERE planner_code = p_planner_code
	AND organization_id = p_org_id
	AND sr_instance_id = p_inst_id
	AND current_employee_flag = 1;

Line: 665

	 SELECT employee_id
	 FROM msc_planners mp,
	 msc_system_items msi
	 WHERE mp.planner_code = msi.planner_code
	 AND mp.organization_id = msi.organization_id
	 AND mp.sr_instance_id = msi.sr_instance_id
	 AND mp.current_employee_flag = 1
	 AND msi.plan_id = p_plan_id
	 AND msi.organization_id = p_org_id
	 AND msi.sr_instance_id = p_inst_id
	 AND msi.inventory_item_id = p_item_id;

Line: 707

	 SELECT count(1)
	 FROM msc_trading_partners
	 WHERE sr_tp_id = p_org_id
	 AND sr_instance_id = p_inst_id
	 AND (modeled_customer_id is not null
	 OR  modeled_supplier_id is not null);

Line: 770

      SELECT mp.employee_id
  FROM msc_planners mp
  WHERE mp.planner_code = p_planner_code
  AND mp.organization_id = p_org_id
  AND mp.sr_instance_id = p_inst_id
  AND mp.current_employee_flag = 1;

Line: 778

  select mtps.sr_tp_site_id
  from msc_trading_partners mtp,
         msc_trading_partner_sites mtps
  where mtp.sr_tp_id = p_org_id
  AND mtp.sr_instance_id = p_inst_id
  AND mtp.partner_type =3
  AND mtps.partner_id = mtp.partner_id;

Line: 907

         p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
                    p_plan_id, p_transaction_id);

Line: 949

select critical_component_flag
from msc_system_items
where plan_id  = arg_plan_id
and inventory_item_id = arg_item_id
and organization_id = arg_org_id
and sr_instance_id = arg_sr_instance_id;

Line: 991

SELECT partner_id
FROM msc_trading_partners
WHERE partner_type = 3
AND sr_tp_id = p_org_id
AND sr_instance_id = p_inst_id;

Line: 1000

SELECT s.sr_tp_site_id, s.location
FROM msc_trading_partner_sites s
where s.partner_id = l_partner_id;

Line: 1042

select sr_inventory_item_id
from msc_system_items
where plan_id = p_plan_id
and organization_id = p_org_id
and sr_instance_id = p_instance_id
and inventory_item_id = p_item_id;

Line: 1125

select profile_value
from msc_plan_profiles
where plan_id=p_plan_id
and profile_code=p_profile_code;