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_ALL

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

2190: if g_multiple_lines = 'N' and l_principal_trx_id is not null then
2191:
2192: if l_interest_trx_id is not null then
2193:
2194: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2195:
2196: if (sql%notfound) then
2197: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2198: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

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

2193:
2194: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2195:
2196: if (sql%notfound) then
2197: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2198: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2199: FND_MSG_PUB.Add;
2200: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2201: RAISE FND_API.G_EXC_ERROR;

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

2204: end if;
2205:
2206: if l_fee_trx_id is not null then
2207:
2208: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2209:
2210: if (sql%notfound) then
2211: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2212: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

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

2207:
2208: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2209:
2210: if (sql%notfound) then
2211: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2212: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2213: FND_MSG_PUB.Add;
2214: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2215: RAISE FND_API.G_EXC_ERROR;

Line 5350: RA_CUSTOMER_TRX_ALL trx,

5346: lines.AMOUNT,
5347: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5348: trx.org_id
5349: from
5350: RA_CUSTOMER_TRX_ALL trx,
5351: lns_amortization_lines lines,
5352: ar_payment_schedules psa
5353: where
5354: trx.customer_trx_id = lines.CUST_TRX_ID and

Line 5770: RA_CUSTOMER_TRX_ALL trx,

5766: lines.AMOUNT,
5767: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5768: trx.org_id
5769: from
5770: RA_CUSTOMER_TRX_ALL trx,
5771: lns_amortization_lines lines,
5772: ar_payment_schedules psa
5773: where
5774: trx.customer_trx_id = lines.CUST_TRX_ID and

Line 6649: RA_CUSTOMER_TRX_ALL trx,

6645: lines.AMOUNT,
6646: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
6647: trx.org_id
6648: from
6649: RA_CUSTOMER_TRX_ALL trx,
6650: lns_amortization_lines lines,
6651: ar_payment_schedules psa
6652: where
6653: trx.customer_trx_id = lines.CUST_TRX_ID and