DBA Data[Home] [Help]

APPS.LNS_REP_UTILS dependencies on AR_LOOKUPS

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

1267: )
1268: )
1269: )
1270: )
1271: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1272: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1273: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1274: WHERE party.party_id =lp.HZ_PARTY_ID
1275: AND party.party_type = lkup.lookup_code

Line 1472: ar_lookups trx_type_lkup

1468: )
1469: from LNS_LOAN_LINES lll,
1470: RA_CUSTOMER_TRX_ALL cust_trx,
1471: RA_CUST_TRX_TYPES_ALL trx_type,
1472: ar_lookups trx_type_lkup
1473: where lll.loan_id = lh.LOAN_ID and
1474: lll.end_date is null and
1475: cust_trx.cust_trx_type_id = trx_type.CUST_TRX_TYPE_ID and
1476: trx_type.org_id = lh.org_id and