APPS.MSC_SCATP_PUB SQL Statements

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

Line: 18

SELECT ship_method,
       ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
FROM   msc_interorg_ship_methods mism,
       msc_regions_temp mrt
WHERE  plan_id = -1
AND    from_location_id = p_from_location_id
AND    sr_instance_id = p_from_instance_id
AND    mism.to_region_id = mrt.region_id
AND    mrt.session_id = p_session_id
AND    mrt.partner_site_id = p_partner_site_id
AND    sr_instance_id2 = p_to_instance_id
AND    default_flag = 1
ORDER BY 2;

Line: 36

        SELECT ship_method
        INTO   l_ship_method
        FROM   msc_interorg_ship_methods
        WHERE  plan_id = -1
        AND    from_location_id = p_from_location_id
        AND    sr_instance_id = p_from_instance_id
        AND    to_location_id = p_to_location_id
        AND    sr_instance_id2 = p_to_instance_id
        and    to_region_id is null
        AND    default_flag = 1
        AND    rownum = 1;

Line: 53

        /*SELECT ship_method
        INTO   l_ship_method
        FROM   msc_interorg_ship_methods mism,
               msc_regions_temp mrt
        WHERE  plan_id = -1
        AND    from_location_id = p_from_location_id
        AND    sr_instance_id = p_from_instance_id
        AND    mism.to_region_id = mrt.region_id
        AND    mrt.session_id = p_session_id
        AND    mrt.partner_site_id = p_partner_site_id
        AND    sr_instance_id2 = p_to_instance_id
        AND    default_flag = 1
        AND    rownum = 1; */

Line: 91

SELECT  intransit_time,
        ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
FROM    msc_interorg_ship_methods,
        msc_regions_temp mrt
WHERE   plan_id = -1
AND     from_location_id = p_from_location_id
AND     sr_instance_id = p_from_instance_id
AND     to_region_id =  mrt.region_id
AND mrt.session_id = p_session_id
AND mrt.partner_site_id = p_partner_site_id
AND sr_instance_id2 = p_to_instance_id
AND     default_flag = 1
ORDER BY 2;

Line: 109

        SELECT  intransit_time
        INTO    l_intransit_time
        FROM    msc_interorg_ship_methods
        WHERE   plan_id = -1
        AND     from_location_id = p_from_location_id
        AND     sr_instance_id = p_from_instance_id
        AND     to_location_id = p_to_location_id
        AND     sr_instance_id2 = p_to_instance_id
        AND     to_region_id is null
        AND     default_flag = 1
        AND     rownum = 1;

Line: 126

            SELECT  intransit_time
            INTO    l_intransit_time
            FROM    msc_interorg_ship_methods,
	    	    msc_regions_temp mrt
            WHERE   plan_id = -1
            AND     from_location_id = p_from_location_id
            AND     sr_instance_id = p_from_instance_id
            AND     to_region_id =  mrt.region_id
            AND	mrt.session_id = p_session_id
            AND	mrt.partner_site_id = p_partner_site_id
            AND	sr_instance_id2 = p_to_instance_id
            AND     default_flag = 1
            AND     rownum = 1; */

Line: 172

	select  ship_method
	into 	l_ship_method
	from    msc_interorg_ship_methods
	where   plan_id = -1
        and     from_organization_id = p_from_org_id
        and     sr_instance_id = p_from_org_instance_id
	and     to_organization_id = p_to_org_id
        and     sr_instance_id2 = p_to_org_instance_id
        and     to_region_id is null
	and     default_flag = 1
	and	rownum = 1;

Line: 207

			select  intransit_time
			into	l_intransit_time
			from    msc_interorg_ship_methods
			where   plan_id = -1
                        and     from_organization_id = p_from_org_id
                        and     sr_instance_id = p_from_org_instance_id
			and     to_organization_id = p_to_org_id
                        and     sr_instance_id2 = p_to_org_instance_id
			and     ship_method = p_source_ship_method
                        and     to_region_id is null
			and     rownum = 1;

Line: 231

		select  intransit_time
		into    l_intransit_time
		from    msc_interorg_ship_methods
		where   plan_id = -1
                and     from_organization_id = p_from_org_id
                and     sr_instance_id = p_from_org_instance_id
		and     to_organization_id = p_to_org_id
                and     sr_instance_id2 = p_to_org_instance_id
                and     to_region_id is null
		and     default_flag = 1
		and     rownum = 1;

Line: 268

			select  cost_per_weight_unit
			into	l_weight_cost
			from    msc_interorg_ship_methods
			where   plan_id = -1
                        and     from_organization_id = p_from_org_id
                        and     sr_instance_id = p_from_org_instance_id
			and     to_organization_id = p_to_org_id
                        and     sr_instance_id2 = p_to_org_instance_id
			and     ship_method = p_source_ship_method
                        and     to_region_id is null
			and     rownum = 1;

Line: 290

		select  cost_per_weight_unit
		into    l_weight_cost
		from    msc_interorg_ship_methods
		where   plan_id = -1
                and     from_organization_id = p_from_org_id
                and     sr_instance_id = p_from_org_instance_id
		and     to_organization_id = p_to_org_id
                and     sr_instance_id2 = p_to_org_instance_id
		and     default_flag = 1
                and     to_region_id is null
		and     rownum = 1;

Line: 326

			select  transport_cap_over_util_cost
			into	l_transport_cost
			from    msc_interorg_ship_methods
			where   plan_id = -1
                        and     from_organization_id = p_from_org_id
                        and     sr_instance_id = p_from_org_instance_id
			and     to_organization_id = p_to_org_id
                        and     sr_instance_id2 = p_to_org_instance_id
			and     ship_method = p_source_ship_method
                        and     to_region_id is null
			and     rownum = 1;

Line: 348

		select  transport_cap_over_util_cost
		into    l_transport_cost
		from    msc_interorg_ship_methods
		where   plan_id = -1
                and     from_organization_id = p_from_org_id
                and     sr_instance_id = p_from_org_instance_id
		and     to_organization_id = p_to_org_id
                and     sr_instance_id2 = p_to_org_instance_id
		and     default_flag = 1
                and     to_region_id is null
		and     rownum = 1;