APPS.MSC_WF_ALLOC_ATP SQL Statements

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

Line: 30

    select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
    into DEBUG_LOC_SRC
    from v$parameter where name= 'utl_file_dir';

Line: 39

         SELECT spid
         INTO   SPID_SRC
         FROM   v$process
         WHERE  addr = (SELECT paddr FROM v$session
                        WHERE audsid=userenv('SESSIONID'));

Line: 44

         SELECT value
         INTO TRACE_LOC_SRC
         FROM v$parameter
         WHERE name = 'user_dump_dest';

Line: 57

    select p_session_id ||':'||mrp_atp_schedule_temp_s.nextval
    into l_itemkey
    from mrp_atp_details_temp
    where rownum = 1;

Line: 209

		SELECT  distinct pl.user_name, p.compile_designator
		FROM    msc_planners pl,
			msc_system_items sys,
			msc_plans p
		WHERE   sys.plan_id = p_plan_id
		AND     sys.organization_id = p_organization_id
		AND     sys.sr_instance_id = p_instance_id
		AND     sys.sr_inventory_item_id = p_inventory_item_id
		AND	sys.plan_id = p.plan_id
		--AND     pl.organization_id = sys.organization_id
		AND     pl.sr_instance_id = sys.sr_instance_id
		AND     pl.planner_code = sys.planner_code;

Line: 334

		SELECT	tp.customer_class_code, tp.partner_name,
                        tps.location, tps.partner_address
		INTO	l_customer_class, l_customer, l_location, l_address
		FROM	msc_tp_id_lid tplid,
                        msc_trading_partners tp,
                        msc_tp_site_id_lid tpslid,
			msc_trading_partner_sites tps
		WHERE	tplid.sr_tp_id  =  p_customer_id
                AND     tplid.sr_instance_id = p_instance_id
                AND     tplid.partner_type = 2
                AND     tpslid.sr_tp_site_id = p_customer_site_id
                AND     tpslid.sr_instance_id =  p_instance_id
                AND     tpslid.partner_type = 2
                AND     tp.partner_id = tplid.tp_id
                AND     tps.partner_site_id = tpslid.tp_site_id ;

Line: 535

		SELECT  distinct pl.user_name, p.compile_designator
		FROM    msc_planners pl,
			msc_system_items sys,
			msc_plans p
		WHERE   sys.plan_id = p_plan_id
		AND     sys.organization_id = p_organization_id
		AND     sys.sr_instance_id = p_instance_id
		AND     sys.sr_inventory_item_id = p_inventory_item_id
		AND	sys.plan_id = p.plan_id
		--AND     pl.organization_id = sys.organization_id
		AND     pl.sr_instance_id = sys.sr_instance_id
		AND     pl.planner_code = sys.planner_code;

Line: 624

		SELECT	tp.customer_class_code, tp.partner_name,
                        tps.location, tps.partner_address
		INTO	l_customer_class, l_customer, l_location, l_address
		FROM	msc_tp_id_lid tplid,
                        msc_trading_partners tp,
                        msc_tp_site_id_lid tpslid,
			msc_trading_partner_sites tps
		WHERE	tplid.sr_tp_id  =  p_customer_id
                AND     tplid.sr_instance_id = p_instance_id
                AND     tplid.partner_type = 2
                AND     tpslid.sr_tp_site_id = p_customer_site_id
                AND     tpslid.sr_instance_id =  p_instance_id
                AND     tpslid.partner_type = 2
                AND     tp.partner_id = tplid.tp_id
                AND     tps.partner_site_id = tpslid.tp_site_id ;