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_LOAN_PUB dependencies on AR_LOOKUPS

Line 606: ar_lookups lkup,

602: SELECT rel.subject_id
603: INTO l_contact_person_party_id
604: FROM hz_relationships rel,
605: hz_parties rel_party,
606: ar_lookups lkup,
607: hz_relationship_types rel_type
608: WHERE rel.party_id = P_Loan_Details_Rec.contact_rel_party_id
609: AND rel.object_id = P_Loan_Details_Rec.primary_borrower_party_id
610: AND rel.relationship_code = rel_type.forward_rel_code

Line 679: FROM ar_lookups alk

675: AND l_product_rec.loan_class_code = 'ERS' THEN
676: BEGIN
677: SELECT 'Y'
678: INTO l_dummy
679: FROM ar_lookups alk
680: ,RA_CUST_TRX_TYPES_ALL rtyp
681: WHERE rtyp.CUST_TRX_TYPE_ID = P_Loan_Details_Rec.trx_type_id
682: AND alk.lookup_code = rtyp.type
683: AND alk.lookup_type = 'INV/CM';

Line 1049: ar_lookups trx_type_lkup,

1045: FROM
1046: ar_payment_schedules_all pmt_sch,
1047: hz_cust_accounts account,
1048: RA_CUST_TRX_TYPES trx_type,
1049: ar_lookups trx_type_lkup,
1050: ar_lookups trx_class_lkup
1051: WHERE
1052: pmt_sch.class in ('INV','DM') and
1053: pmt_sch.status = 'OP' and

Line 1050: ar_lookups trx_class_lkup

1046: ar_payment_schedules_all pmt_sch,
1047: hz_cust_accounts account,
1048: RA_CUST_TRX_TYPES trx_type,
1049: ar_lookups trx_type_lkup,
1050: ar_lookups trx_class_lkup
1051: WHERE
1052: pmt_sch.class in ('INV','DM') and
1053: pmt_sch.status = 'OP' and
1054: pmt_sch.amount_due_remaining > 0 and