APPS.MSC_X_CP_FLOW SQL Statements

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

Line: 14

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;

Line: 122

      SELECT fu.user_name name
	FROM fnd_responsibility resp
	, fnd_user_resp_groups furg
	, msc_company_users mcu
	, fnd_user fu
	WHERE resp.responsibility_key = p_resp_key
	AND furg.responsibility_id = resp.responsibility_id
	and furg.user_id = mcu.user_id
	and mcu.user_id = fu.user_id
	and mcu.company_id = 1
      ;

Line: 138

    SELECT count(1)
    FROM wf_local_roles
    WHERE name = p_role_name
    ;

Line: 145

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;

Line: 295

     SELECT map.tp_key
      FROM msc_trading_partner_maps map
      , msc_company_relationships cr
      WHERE map.map_type = 1 -- company level mapping
      AND cr.object_id = p_customer_id
      AND map.company_key = cr.relationship_id
      AND cr.relationship_type = 1 -- customer
      AND cr.subject_id = 1 -- OEM
      ;

Line: 384

      SELECT fu.user_name name
	FROM fnd_responsibility resp
	, fnd_user_resp_groups furg
	, msc_company_users mcu
	, fnd_user fu
	WHERE resp.responsibility_key = p_resp_key
	AND furg.responsibility_id = resp.responsibility_id
	and furg.user_id = mcu.user_id
	and mcu.user_id = fu.user_id
	and mcu.company_id = 1
      ;

Line: 400

    SELECT count(1)
    FROM wf_local_roles
    WHERE name = p_role_name
    ;

Line: 407

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;

Line: 558

     SELECT map.tp_key
      FROM msc_trading_partner_maps map
      , msc_company_relationships cr
      WHERE map.map_type = 1 -- company level mapping
      AND cr.object_id = p_supplier_id
      AND map.company_key = cr.relationship_id
      AND cr.relationship_type = 2 -- supplier
      AND cr.subject_id = 1 -- OEM
      ;

Line: 570

    	select distinct mtp.calendar_code
    	into l_calendar_code
    	from msc_designators des, msc_plans p, msc_trading_partners mtp
    	where des.designator = p.compile_designator and
    		des.sr_instance_id = p.sr_instance_id and
    		des.organization_id = p.organization_id and
    		des.production = 1 and
    		p.sr_instance_id = mtp.sr_instance_id and
    		p.organization_id = mtp.sr_tp_id and
    		mtp.partner_type = 3 and
    		des.sr_instance_id = mtp.sr_instance_id and
    		des.organization_id = mtp.sr_tp_id
    		and rownum = 1 order by mtp.calendar_code;

Line: 657

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;

Line: 711

  SELECT plan_id
    FROM msc_plans
    WHERE compile_designator = p_default_plan_name
  ;

Line: 814

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;

Line: 933

    SELECT 'CP_FLOW-' || TO_CHAR(msc_sup_dem_entries_s.nextval)
      INTO l_wf_key FROM DUAL;