APPS.AR_IDEP_UTILS dependencies on RA_CUSTOMER_TRX_ALL

Line 113: l_currency_code ra_customer_trx_all.invoice_currency_code%type;

109: *=======================================================================*/
110: FUNCTION get_applied_commitment_amt (p_customer_trx_id in NUMBER) RETURN NUMBER IS
111:
112: l_commitment_class ra_cust_trx_types.type%type;
113: l_currency_code ra_customer_trx_all.invoice_currency_code%type;
114: l_applied_amount NUMBER := 0;
115: l_invoiced_amount NUMBER := 0;
116: l_credit_memo_amount NUMBER := 0;
117:

Line 127: FROM ra_customer_trx_all trx,

123: SELECT type.type,
124: trx.invoice_currency_code
125: INTO l_commitment_class,
126: l_currency_code
127: FROM ra_customer_trx_all trx,
128: ra_cust_trx_types_all type
129: WHERE trx.customer_trx_id = p_customer_trx_id
130: AND trx.cust_trx_type_id = type.cust_trx_type_id
131: AND trx.org_id = type.org_id

Line 148: FROM ra_customer_trx_all trx,

144: -- Get the Adjustments
145: --
146: SELECT ( NVL(SUM( ADJ.AMOUNT),0) * -1)
147: INTO l_invoiced_amount
148: FROM ra_customer_trx_all trx,
149: ra_cust_trx_types_all type,
150: ar_adjustments_all adj
151: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
152: AND trx.org_id = type.org_id

Line 170: FROM ra_customer_trx_all trx,

166: -- Get the Credit Memos against the Commitment
167: --
168: SELECT NVL(SUM(-1 * line.extended_amount),0)
169: INTO l_credit_memo_amount
170: FROM ra_customer_trx_all trx,
171: ra_customer_trx_lines_all line
172: WHERE trx.customer_trx_id = line.customer_trx_id
173: AND trx.org_id = line.org_id
174: AND trx.previous_customer_trx_id = p_customer_trx_id