APPS.OE_ACCOUNTING dependencies on OE_ORDER_LINES

Line 31: -- from oe_order_lines

27: --
28: -- if new OE then
29: --
30: -- select sum of (ordered_quantity)* unit_selling_price
31: -- from oe_order_lines
32: -- where commitement_id = p_customer_trx_id
33: -- and line is not RETURN line
34: -- and invoice_interface_status_code <> 'YES' -- never been AR interfaced
35: --

Line 62: FROM oe_order_lines

58:
59: SELECT
60: NVL(SUM( NVL(ordered_quantity,0) * NVL(unit_selling_price,0)),0)
61: INTO l_uninv_commitment_bal
62: FROM oe_order_lines
63: WHERE commitment_id = p_customer_trx_id
64: AND NVL(line_category_code,'STANDARD') <> 'RETURN'
65: AND NVL(invoice_interface_status_code,'NO') <> 'YES';
66: