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.

[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 1204: ar_payment_schedules_all psa

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

Line 2727: from ar_payment_schedules

2723: +-----------------------------------------------------------------------*/
2724:
2725: CURSOR receipt_cur(P_RECEIPT_ID number) IS
2726: select ABS(AMOUNT_DUE_REMAINING)
2727: from ar_payment_schedules
2728: where CASH_RECEIPT_ID = P_RECEIPT_ID
2729: and status = 'OP'
2730: and class = 'PMT';
2731:

Line 5966: ar_payment_schedules psa

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

Line 6393: ar_payment_schedules psa

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

Line 7278: ar_payment_schedules psa

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

Line 7594: ar_payment_schedules psa,

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

Line 8410: ar_payment_schedules psa

8406: psa.org_id,
8407: loan.LOAN_CURRENCY
8408: from LNS_LOAN_HEADERS_VL loan,
8409: lns_amortization_scheds am,
8410: ar_payment_schedules psa
8411: where
8412: loan.loan_id = P_LOAN_ID and
8413: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and
8414: loan.loan_id = am.loan_id and

Line 9376: ar_payment_schedules psa,

9372: nvl(loan.EXCHANGE_RATE, 1)
9373: from
9374: lns_amortization_scheds am,
9375: lns_loan_headers loan,
9376: ar_payment_schedules psa,
9377: lns_lookups look
9378: where
9379: am.loan_id = P_LOAN_ID and
9380: am.amortization_schedule_id = P_AMORTIZATION_SCHED_ID and

Line 10017: ar_payment_schedules psa,

10013: trx_type.name
10014: from
10015: lns_amortization_scheds am,
10016: lns_loan_headers loan,
10017: ar_payment_schedules psa,
10018: RA_CUST_TRX_TYPES_ALL trx_type
10019: where
10020: am.loan_id = P_LOAN_ID and
10021: am.amortization_schedule_id = P_AMORTIZATION_SCHED_ID and

Line 10941: ar_payment_schedules psa,

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