APPS.OE_ACCOUNTING SQL Statements

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

Line: 59

        SELECT
          NVL(SUM( NVL(ordered_quantity,0) * NVL(unit_selling_price,0)),0)
          INTO   l_uninv_commitment_bal
          FROM   oe_order_lines
          WHERE  commitment_id    = p_customer_trx_id
		AND	  NVL(line_category_code,'STANDARD') <> 'RETURN'
		AND	  NVL(invoice_interface_status_code,'NO') <> 'YES';

Line: 69

        SELECT
          NVL( SUM( ( NVL( ordered_quantity, 0 ) -
                      NVL( cancelled_quantity, 0 ) -
                      NVL( invoiced_quantity, 0 )
                    ) *
                      NVL( selling_price, 0 )
                   ), 0 )
          INTO   l_uninv_commitment_bal
          FROM   so_lines
          WHERE  commitment_id    = p_customer_trx_id
          AND    line_type_code  IN ( 'REGULAR', 'DETAIL');