APPS.OKL_BILLING_UTIL_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 44: FROM ra_customer_trx_all ractrx

40:
41: -- Cursor to obtain the last invoice date for a contract
42: CURSOR c_last_invoice_date(p_contract_id IN NUMBER) IS
43: SELECT max(ractrx.trx_date)
44: FROM ra_customer_trx_all ractrx
45: WHERE EXISTS (
46: SELECT 'x'
47: FROM ra_customer_trx_lines_all ractrl
48: WHERE ractrl.customer_trx_id = ractrx.customer_trx_id

Line 287: RA_CUSTOMER_TRX_ALL RACTRX

283: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
284: CURSOR invoice_amount_orig_csr(p_header_id NUMBER) IS
285: SELECT SUM(NVL(APS.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_DUE_ORIGINAL
286: FROM AR_PAYMENT_SCHEDULES_ALL APS,
287: RA_CUSTOMER_TRX_ALL RACTRX
288: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
289: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
290: l_invoice_amount_orig NUMBER;
291: BEGIN

Line 345: RA_CUSTOMER_TRX_ALL RACTRX

341: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
342: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
343: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
344: FROM AR_PAYMENT_SCHEDULES_ALL APS,
345: RA_CUSTOMER_TRX_ALL RACTRX
346: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
347: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
348: l_invoice_amount_remaining NUMBER;
349: BEGIN

Line 699: RA_CUSTOMER_TRX_ALL HDR

695:
696: CURSOR cust_trx_csr(p_cust_trx_number VARCHAR2, p_contract_number VARCHAR2) IS
697: SELECT LNS.CUSTOMER_TRX_ID
698: FROM RA_CUSTOMER_TRX_LINES_ALL LNS,
699: RA_CUSTOMER_TRX_ALL HDR
700: WHERE LNS.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number
701: AND HDR.TRX_NUMBER = p_cust_trx_number
702: AND HDR.CUSTOMER_TRX_ID = LNS.CUSTOMER_TRX_ID;
703:

Line 1166: RA_CUSTOMER_TRX_ALL RACTRX

1162: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1163: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
1164: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
1165: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1166: RA_CUSTOMER_TRX_ALL RACTRX
1167: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1168: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1169: l_invoice_amount_remaining NUMBER;
1170: BEGIN

Line 1262: RA_CUSTOMER_TRX_ALL RACTRX

1258: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1259: CURSOR invoice_amount_adj_csr(p_header_id NUMBER) IS
1260: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1261: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1262: RA_CUSTOMER_TRX_ALL RACTRX
1263: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1264: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1265: l_invoice_amount_adj NUMBER;
1266: BEGIN