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_BORROWERS_SUMMARY_PUB dependencies on HZ_PARTIES

Line 162: from hz_parties party,

158: party.PRIMARY_PHONE_AREA_CODE,
159: party.PRIMARY_PHONE_NUMBER,
160: party.PRIMARY_PHONE_EXTENSION,
161: party.CURR_FY_POTENTIAL_REVENUE
162: from hz_parties party,
163: HZ_CODE_ASSIGNMENTS ass
164: where party.party_id = P_PARTY_ID and
165: ass.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' and
166: ass.OWNER_TABLE_ID(+) = party.party_id and

Line 165: ass.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' and

161: party.CURR_FY_POTENTIAL_REVENUE
162: from hz_parties party,
163: HZ_CODE_ASSIGNMENTS ass
164: where party.party_id = P_PARTY_ID and
165: ass.OWNER_TABLE_NAME(+) = 'HZ_PARTIES' and
166: ass.OWNER_TABLE_ID(+) = party.party_id and
167: ass.CLASS_CATEGORY(+) = 'CUSTOMER_CATEGORY'and
168: ass.PRIMARY_FLAG(+) = 'Y' and
169: ass.START_DATE_ACTIVE(+) <= sysdate and

Line 957: hz_parties party,

953: party.PARTY_NUMBER,
954: party.party_name
955: from
956: lns_participants par,
957: hz_parties party,
958: lns_loan_headers_all head
959: where
960: party.party_id = nvl(P_BORROWER_ID, party.party_id) and
961: party.party_id = par.hz_party_id and