APPS.OE_TOTALS_GRP SQL Statements

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

Line: 104

            SELECT DECODE(line_category_code,'RETURN',-1,1)*
                   NVL(unit_selling_price,0)*
                   NVL(Ordered_Quantity,0),
                   DECODE(line_category_code,'RETURN',-1,1)*
                   NVL(tax_value,0)
            INTO   l_line_amount,
                   l_tax_amount
            FROM   oe_order_lines_all
            WHERE  line_id = p_line_id
            AND    NVL(cancelled_flag,'N')='N';

Line: 233

            SELECT DECODE(line_category_code,'RETURN',-1,1)*
                   NVL(unit_selling_price,0)*
                   NVL(Ordered_Quantity,0),
                   DECODE(line_category_code,'RETURN',-1,1)*
                   NVL(tax_value,0)
            INTO   l_line_amount,
                   l_tax_amount
            FROM   oe_order_lines_all
            WHERE  line_id = p_line_id
            AND    NVL(cancelled_flag,'N')='N';

Line: 318

SELECT 	 line_id
       , payment_term_id
FROM	 oe_order_lines_all
WHERE	 header_id = p_header_id;

Line: 359

       SELECT org_id
       INTO   l_org_id
       FROM   oe_order_lines_all
       WHERE  line_id = p_line_id;

Line: 380

      SELECT line_id
	    ,header_id
	    ,payment_term_id
      INTO   l_line_tbl(1).line_id
	    ,l_line_tbl(1).header_id
	    ,l_line_tbl(1).payment_term_id
      FROM   oe_order_lines_all
      WHERE  line_id=p_line_id;