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_PAYOFF_PUB dependencies on RA_CUST_TRX_TYPES

Line 773: ,ra_cust_trx_types tty

769: ,ps.TRX_DATE
770: ,ps.GL_DATE
771: from lns_amortization_scheds am
772: ,ar_payment_schedules ps
773: ,ra_cust_trx_types tty
774: where (am.principal_trx_id = ps.customer_trx_id OR
775: am.interest_trx_id = ps.customer_trx_id OR
776: am.fee_trx_id = ps.customer_trx_id) and
777: ps.cust_trx_type_id = tty.cust_trx_type_id and

Line 1490: RA_CUST_TRX_TYPES trx_type,

1486: lines.REQUESTED_AMOUNT,
1487: lines.INSTALLMENT_NUMBER
1488: from lns_loan_lines lines,
1489: RA_CUSTOMER_TRX_ALL cust_trx,
1490: RA_CUST_TRX_TYPES trx_type,
1491: ar_lookups trx_type_lkup
1492: where lines.status = 'APPROVED'
1493: and lines.REFERENCE_ID <> -1
1494: and lines.LOAN_ID = P_LOAN_ID

Line 1515: ,ra_cust_trx_types tty

1511: ,ps.TRX_DATE
1512: ,ps.GL_DATE
1513: from lns_amortization_scheds am
1514: ,ar_payment_schedules ps
1515: ,ra_cust_trx_types tty
1516: where (am.principal_trx_id = ps.customer_trx_id OR
1517: am.interest_trx_id = ps.customer_trx_id OR
1518: am.fee_trx_id = ps.customer_trx_id) and
1519: ps.cust_trx_type_id = tty.cust_trx_type_id and