eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_BILLING_BATCH_PUB dependencies on RA_CUSTOMER_TRX

Line 1202: from RA_CUSTOMER_TRX trx,

1198: psa.due_date,
1199: lines.extended_amount,
1200: lines.INTERFACE_LINE_ATTRIBUTE5,
1201: lines.INTERFACE_LINE_ATTRIBUTE6
1202: from RA_CUSTOMER_TRX trx,
1203: RA_CUSTOMER_TRX_LINES lines,
1204: ar_payment_schedules_all psa
1205: where
1206: trx.batch_id = P_BATCH_ID

Line 1203: RA_CUSTOMER_TRX_LINES lines,

1199: lines.extended_amount,
1200: lines.INTERFACE_LINE_ATTRIBUTE5,
1201: lines.INTERFACE_LINE_ATTRIBUTE6
1202: from RA_CUSTOMER_TRX trx,
1203: RA_CUSTOMER_TRX_LINES lines,
1204: ar_payment_schedules_all psa
1205: where
1206: trx.batch_id = P_BATCH_ID
1207: and trx.customer_trx_id = lines.customer_trx_id

Line 2361: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;

2357: if g_multiple_lines = 'N' and l_principal_trx_id is not null then
2358:
2359: if l_interest_trx_id is not null then
2360:
2361: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2362:
2363: if (sql%notfound) then
2364: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2365: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

Line 2364: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');

2360:
2361: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2362:
2363: if (sql%notfound) then
2364: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2365: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2366: FND_MSG_PUB.Add;
2367: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2368: RAISE FND_API.G_EXC_ERROR;

Line 2375: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;

2371: end if;
2372:
2373: if l_fee_trx_id is not null then
2374:
2375: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2376:
2377: if (sql%notfound) then
2378: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2379: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

Line 2378: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');

2374:
2375: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2376:
2377: if (sql%notfound) then
2378: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2379: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2380: FND_MSG_PUB.Add;
2381: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2382: RAISE FND_API.G_EXC_ERROR;

Line 5964: RA_CUSTOMER_TRX_ALL trx,

5960: lines.AMOUNT,
5961: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5962: trx.org_id
5963: from
5964: RA_CUSTOMER_TRX_ALL trx,
5965: lns_amortization_lines lines,
5966: ar_payment_schedules psa
5967: where
5968: trx.customer_trx_id = lines.CUST_TRX_ID and

Line 6391: RA_CUSTOMER_TRX_ALL trx,

6387: lines.AMOUNT,
6388: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
6389: trx.org_id
6390: from
6391: RA_CUSTOMER_TRX_ALL trx,
6392: lns_amortization_lines lines,
6393: ar_payment_schedules psa
6394: where
6395: trx.customer_trx_id = lines.CUST_TRX_ID and

Line 7276: RA_CUSTOMER_TRX_ALL trx,

7272: lines.AMOUNT,
7273: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
7274: trx.org_id
7275: from
7276: RA_CUSTOMER_TRX_ALL trx,
7277: lns_amortization_lines lines,
7278: ar_payment_schedules psa
7279: where
7280: trx.customer_trx_id = lines.CUST_TRX_ID and

Line 7593: RA_CUSTOMER_TRX trx,

7589: lines.REC_ADJUSTMENT_ID,
7590: nvl(lines.installment_number, 1),
7591: loan.LOAN_START_DATE
7592: from LNS_LOAN_HEADERS_VL loan,
7593: RA_CUSTOMER_TRX trx,
7594: ar_payment_schedules psa,
7595: lns_loan_lines lines
7596: where loan.loan_id = P_LOAN_ID and
7597: loan.loan_id = lines.loan_id and

Line 10940: RA_CUSTOMER_TRX trx,

10936: trx.legal_entity_id,
10937: lines.REC_ADJUSTMENT_ID,
10938: nvl(lines.installment_number, 1)
10939: from LNS_LOAN_HEADERS_VL loan,
10940: RA_CUSTOMER_TRX trx,
10941: ar_payment_schedules psa,
10942: lns_loan_lines lines
10943: where lines.LOAN_LINE_ID = P_LOAN_LINE_ID and
10944: loan.loan_id = lines.loan_id and