APPS.MRP_SCATP_PVT SQL Statements

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

Line: 9

        SELECT ship_method
        INTO   l_ship_method
        FROM   mtl_interorg_ship_methods
        WHERE  from_location_id = p_from_location_id
        AND    to_location_id = p_to_location_id
        AND    default_flag = 1
        AND    rownum = 1;

Line: 29

    SELECT  intransit_time
    INTO    l_intransit_time
    FROM    mtl_interorg_ship_methods
    WHERE   from_location_id = p_from_location_id
    AND     to_location_id = p_to_location_id
    AND     default_flag = 1
    AND     rownum = 1;

Line: 59

	select  ship_method
	into 	l_ship_method
	from    mtl_interorg_ship_methods
	where   from_organization_id = p_from_org_id
	and     to_organization_id = p_to_org_id
	and     default_flag = 1
	and		rownum = 1;

Line: 87

			select  intransit_time
			into	l_intransit_time
			from    mtl_interorg_ship_methods
			where   from_organization_id = p_from_org_id
			and		to_organization_id = p_to_org_id
			and     ship_method = p_source_ship_method
			and		rownum = 1;

Line: 106

				select  intransit_time
				into    l_intransit_time
				from    mtl_interorg_ship_methods
				where   from_organization_id = p_from_org_id
				and     to_organization_id = p_to_org_id
				and     default_flag = 1
				and     rownum = 1;