APPS.OE_ACCOUNTING dependencies on SO_LINES

Line 40: -- from so_lines

36: -- else old OE
37: --
38: -- select sum of ((ordered_quantity - cancelled_quantity -
39: -- invoiced_quantity) * selling_price)
40: -- from so_lines
41: -- where commitment_id = p_customer_trx_id
42: -- and line_type is regular or detail
43: --
44: -- end if;

Line 77: FROM so_lines

73: ) *
74: NVL( selling_price, 0 )
75: ), 0 )
76: INTO l_uninv_commitment_bal
77: FROM so_lines
78: WHERE commitment_id = p_customer_trx_id
79: AND line_type_code IN ( 'REGULAR', 'DETAIL');
80:
81: