DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on AR_LOOKUPS

Line 1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,

1173: )
1174: )
1175: )
1176: )
1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1178: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1179: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1180: WHERE party.party_id =lp.HZ_PARTY_ID
1181: AND party.party_type = lkup.lookup_code

Line 1378: ar_lookups trx_type_lkup

1374: )
1375: from LNS_LOAN_LINES lll,
1376: RA_CUSTOMER_TRX_ALL cust_trx,
1377: RA_CUST_TRX_TYPES_ALL trx_type,
1378: ar_lookups trx_type_lkup
1379: where lll.loan_id = lh.LOAN_ID and
1380: lll.end_date is null and
1381: cust_trx.cust_trx_type_id = trx_type.CUST_TRX_TYPE_ID and
1382: trx_type.org_id = lh.org_id and