APPS.OE_PARTY_TOTALS dependencies on OE_ORDER_LINES_ALL

Line 65: FROM oe_order_lines_all l

61:
62: CURSOR C_LINE_TOTALS(p_header_id NUMBER) IS
63: SELECT SUM(DECODE(l.line_category_code,'RETURN',-1,1)*
64: l.unit_selling_price*l.ordered_quantity)
65: FROM oe_order_lines_all l
66: WHERE l.header_id = p_header_id
67: AND l.cancelled_flag <> 'Y'
68: AND l.charge_periodicity_code IS NULL; -- Added for Recurring Charges
69:

Line 82: oe_order_lines_all l

78: P.OPERAND,
79: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
80: )))
81: FROM oe_price_adjustments p,
82: oe_order_lines_all l
83: WHERE p.header_id = p_header_id
84: AND p.list_line_type_code = 'FREIGHT_CHARGE'
85: AND p.applied_flag = 'Y'
86: AND p.line_id = l.line_id(+)