DBA Data[Home] [Help]

APPS.AR_RAXCBR_XMLP_PKG dependencies on OE_PAYMENTS

Line 123: oe_amount := NVL(OE_PAYMENTS_UTIL.Get_Uninvoiced_Commitment_Bal(customer_trx_id1), 0);

119: /*srw.reference(customer_trx_id);*/null;
120:
121:
122:
123: oe_amount := NVL(OE_PAYMENTS_UTIL.Get_Uninvoiced_Commitment_Bal(customer_trx_id1), 0);
124:
125:
126:
127: if p_unbooked = 'N' then

Line 133: oe_payments pay

129: nvl(sum(nvl(pay.commitment_applied_amount, 0) -
130: nvl(pay.commitment_interfaced_amount,0)),0) om_commitment_amt
131: into unbooked_amt
132: from oe_order_lines lin,
133: oe_payments pay
134: where lin.header_id = pay.header_id(+)
135: and lin.line_id = pay.line_id(+)
136: and lin.commitment_id = customer_trx_id1
137: and NVL(lin.open_flag,'Y') = 'Y'