1155: psa.due_date,
1156: lines.extended_amount,
1157: lines.INTERFACE_LINE_ATTRIBUTE5,
1158: lines.INTERFACE_LINE_ATTRIBUTE6
1159: from RA_CUSTOMER_TRX trx,
1160: RA_CUSTOMER_TRX_LINES lines,
1161: ar_payment_schedules_all psa
1162: where
1163: trx.batch_id = P_BATCH_ID
1156: lines.extended_amount,
1157: lines.INTERFACE_LINE_ATTRIBUTE5,
1158: lines.INTERFACE_LINE_ATTRIBUTE6
1159: from RA_CUSTOMER_TRX trx,
1160: RA_CUSTOMER_TRX_LINES lines,
1161: ar_payment_schedules_all psa
1162: where
1163: trx.batch_id = P_BATCH_ID
1164: and trx.customer_trx_id = lines.customer_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');
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;
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');
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;
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
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
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
6951: trx.legal_entity_id,
6952: lines.REC_ADJUSTMENT_ID,
6953: nvl(lines.installment_number, 1)
6954: from LNS_LOAN_HEADERS loan,
6955: RA_CUSTOMER_TRX trx,
6956: ar_payment_schedules psa,
6957: lns_loan_lines lines
6958: where loan.loan_id = P_LOAN_ID and
6959: loan.loan_id = lines.loan_id and