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

Line 202: l_borrower_name hz_parties.party_name%TYPE;

198: l_rows_processed NUMBER;
199: l_new_line VARCHAR2(1);
200: l_org_id hr_operating_units.organization_id%TYPE;
201: l_org_name hr_operating_units.NAME%TYPE;
202: l_borrower_name hz_parties.party_name%TYPE;
203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

Line 276: 'hz_parties hp, ' ||

272: 'where loan_id = lh.LOAN_ID ' ||
273: 'and end_date is null ) AS ORIGINAL_RECEIVABLES ' ||
274: 'from ' ||
275: 'lns_loan_headers_all lh, ' ||
276: 'hz_parties hp, ' ||
277: 'lns_terms t, ' ||
278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||

Line 384: FROM hz_parties

380: IF borrower_id is NOT NULL
381: THEN
382: SELECT PARTY_NAME
383: INTO l_borrower_name
384: FROM hz_parties
385: WHERE party_id = borrower_id;
386: END IF;
387:
388: IF cust_account_id is NOT NULL

Line 568: l_borrower_name hz_parties.party_name%TYPE;

564: l_rows_processed NUMBER;
565: l_new_line VARCHAR2(1);
566: l_org_id hr_operating_units.organization_id%TYPE;
567: l_org_name hr_operating_units.NAME%TYPE;
568: l_borrower_name hz_parties.party_name%TYPE;
569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

Line 781: 'hz_parties hp, ' ||

777: 'lns_loan_headers_all lh, ' ||
778: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
779: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
780: ' from dual) dateparameters, ' ||
781: 'hz_parties hp, ' ||
782: 'lns_lookups llk, ' ||
783: 'LNS_PAY_SUM_V pay, ' ||
784: 'hz_cust_accounts_all account, ' ||
785: 'hz_locations loc, ' ||

Line 871: FROM hz_parties

867: IF borrower_id is NOT NULL
868: THEN
869: SELECT PARTY_NAME
870: INTO l_borrower_name
871: FROM hz_parties
872: WHERE party_id = borrower_id;
873: END IF;
874:
875: IF cust_account_id is NOT NULL

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 1178: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,

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
1182: AND lkup.lookup_type = 'PARTY_TYPE'

Line 1179: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone

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
1182: AND lkup.lookup_type = 'PARTY_TYPE'
1183: AND lp.LOAN_PARTICIPANT_TYPE = lnslkup.lookup_code

Line 1188: AND cp.owner_table_name(+) = 'HZ_PARTIES'

1184: AND lnslkup.lookup_type = 'LNS_PARTICIPANT_TYPE'
1185: AND party.country = ter.TERRITORY_CODE(+)
1186: AND ter.LANGUAGE(+) = userenv('LANG')
1187: AND party.party_id = cp.owner_table_id(+)
1188: AND cp.owner_table_name(+) = 'HZ_PARTIES'
1189: AND cp.contact_point_type(+) = 'PHONE'
1190: AND cp.primary_flag(+) = 'Y'
1191: AND contact_person.party_id(+) =lp.contact_pers_party_id
1192: AND contact_party.party_id(+) =lp.contact_rel_party_id

Line 1193: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'

1189: AND cp.contact_point_type(+) = 'PHONE'
1190: AND cp.primary_flag(+) = 'Y'
1191: AND contact_person.party_id(+) =lp.contact_pers_party_id
1192: AND contact_party.party_id(+) =lp.contact_rel_party_id
1193: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
1194: AND con_phone.owner_table_id(+) =lp.contact_rel_party_id
1195: AND con_phone.primary_flag(+) = 'Y'
1196: AND con_phone.status(+) = 'A'
1197: AND con_phone.contact_point_type(+) = 'PHONE'

Line 1271: HZ_PARTIES party,

1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,
1272: LNS_PARTICIPANTS par
1273: WHERE assetassign.asset_id = asset.asset_id and
1274: asset.asset_owner_id = par.hz_party_id and
1275: party.party_id = par.hz_party_id and

Line 1417: ,hz_parties party

1413: )
1414: )
1415: )
1416: from lns_disb_lines ldl
1417: ,hz_parties party
1418: ,IBY_PAYMENT_METHODS_TL ibypm
1419: where ldl.disb_header_id = ldih.disb_header_id
1420: and party.party_id = ldl.payee_party_id and
1421: ibypm.payment_method_code (+) = ldl.payment_method_code and

Line 1530: hz_parties hp,

1526: ) -- end of AMORTIZATION
1527: ), XMLFormat.createformat('ROWSET')).getClobVal()
1528: from
1529: lns_loan_headers_all lh,
1530: hz_parties hp,
1531: lns_terms t,
1532: lns_int_rate_headers intrt,
1533: lns_rate_schedules ratesch,
1534: hz_locations loc,