APPS.OE_SHIPPING_TOLERANCES_PUB SQL Statements

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

Line: 100

	SELECT	ship_tolerance_below,
		ship_tolerance_above,
		line_set_id,
		ordered_quantity,
		shipped_quantity,
		ordered_quantity2,
		shipped_quantity2,
                top_model_line_id,
                ato_line_id,
                order_quantity_uom,
                ship_from_org_id,
                inventory_item_id
	INTO	l_ship_tolerance_below,
		l_ship_tolerance_above,
		l_line_set_id,
		l_ordered_quantity,
		l_shipped_quantity,
		l_ordered_quantity2,
		l_shipped_quantity2,
                l_top_model_line_id,
                l_ato_line_id,
                l_order_quantity_uom,
                l_ship_from_org_id,
                l_inventory_item_id
	FROM	OE_ORDER_LINES_ALL
	WHERE	line_id = p_line_id;

Line: 132

            SELECT  line_set_id
            INTO    l_line_set_id
            FROM    OE_ORDER_LINES_ALL
            WHERE   line_id = l_top_model_line_id;

Line: 146

		SELECT	SUM(ordered_quantity)
		,	SUM(nvl(shipped_quantity,0))
		,	SUM(nvl(shipping_quantity,0))
		,       SUM(nvl(ordered_quantity2,0))
		,	SUM(nvl(shipped_quantity2,0))
		,	SUM(nvl(shipping_quantity2,0))
		INTO    l_ordered_quantity
		,	l_shipped_quantity
		,	l_shipping_quantity
		,       l_ordered_quantity2
		,	l_shipped_quantity2
		,	l_shipping_quantity2
		FROM	oe_order_lines_all
		WHERE 	line_set_id	= l_line_set_id;

Line: 165

                SELECT  count(*)
                INTO    l_count_unshipped
                FROM    oe_order_lines_all
                WHERE   line_set_id = l_line_set_id
                AND     shipped_quantity IS NULL
                AND     line_id <> p_line_id ;

Line: 180

                    SELECT nvl(sum(shipped_quantity),0),requested_quantity_uom
                    INTO   l_del_shipping_quantity,l_shipping_quantity_uom
                    FROM   wsh_delivery_details
                    where  source_line_id in (SELECT line_id
                                              FROM   oe_order_lines_all
                                              WHERE  line_set_id = l_line_set_id
                                              AND     shipped_quantity IS NULL
                                              AND     line_id <> p_line_id)
                    and   source_code = 'OE'
                    group by requested_quantity_uom;

Line: 459

        SELECT order_quantity_uom,
               ordered_quantity_uom2
        INTO   x_quantity_uom,
               x_quantity_uom2
        FROM   oe_order_lines_all
        WHERE  line_id = p_line_id;