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 AR_PAYMENT_SCHEDULES

Line 1161: ar_payment_schedules_all psa

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
1165: and trx.customer_trx_id = psa.customer_trx_id(+) -- outer join is for case when invoice is created incomplete

Line 2534: from ar_payment_schedules

2530: +-----------------------------------------------------------------------*/
2531:
2532: CURSOR receipt_cur(P_RECEIPT_ID number) IS
2533: select ABS(AMOUNT_DUE_REMAINING)
2534: from ar_payment_schedules
2535: where CASH_RECEIPT_ID = P_RECEIPT_ID
2536: and status = 'OP'
2537: and class = 'PMT';
2538:

Line 5352: ar_payment_schedules psa

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
5355: trx.customer_trx_id = psa.customer_trx_id and
5356: lines.LOAN_ID = P_LOAN_ID and

Line 5772: ar_payment_schedules psa

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
5775: trx.customer_trx_id = psa.customer_trx_id and
5776: lines.LOAN_ID = P_LOAN_ID and

Line 6651: ar_payment_schedules psa

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
6654: trx.customer_trx_id = psa.customer_trx_id and
6655: lines.LOAN_ID = P_LOAN_ID and

Line 6956: ar_payment_schedules psa,

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
6960: lines.reference_type = 'RECEIVABLE' and

Line 7613: ar_payment_schedules psa

7609: psa.org_id,
7610: loan.LOAN_CURRENCY
7611: from LNS_LOAN_HEADERS loan,
7612: lns_amortization_scheds am,
7613: ar_payment_schedules psa
7614: where
7615: loan.loan_id = P_LOAN_ID and
7616: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and
7617: loan.loan_id = am.loan_id and