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 228: l_borrower_name hz_parties.party_name%TYPE;

224: l_rows_processed NUMBER;
225: l_new_line VARCHAR2(1);
226: l_org_id hr_operating_units.organization_id%TYPE;
227: l_org_name hr_operating_units.NAME%TYPE;
228: l_borrower_name hz_parties.party_name%TYPE;
229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

Line 302: 'hz_parties hp, ' ||

298: 'where loan_id = lh.LOAN_ID ' ||
299: 'and end_date is null) AS ORIGINAL_RECEIVABLES ' ||
300: 'from ' ||
301: 'lns_loan_headers_all_vl lh, ' ||
302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||

Line 435: FROM hz_parties

431: IF borrower_id is NOT NULL
432: THEN
433: SELECT PARTY_NAME
434: INTO l_borrower_name
435: FROM hz_parties
436: WHERE party_id = borrower_id;
437: END IF;
438:
439: IF cust_account_id is NOT NULL

Line 631: l_borrower_name hz_parties.party_name%TYPE;

627: l_rows_processed NUMBER;
628: l_new_line VARCHAR2(1);
629: l_org_id hr_operating_units.organization_id%TYPE;
630: l_org_name hr_operating_units.NAME%TYPE;
631: l_borrower_name hz_parties.party_name%TYPE;
632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;

Line 844: 'hz_parties hp, ' ||

840: 'lns_loan_headers_all_vl lh, ' ||
841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||
846: 'LNS_PAY_SUM_V pay, ' ||
847: 'hz_cust_accounts_all account, ' ||
848: 'hz_locations loc, ' ||

Line 934: FROM hz_parties

930: IF borrower_id is NOT NULL
931: THEN
932: SELECT PARTY_NAME
933: INTO l_borrower_name
934: FROM hz_parties
935: WHERE party_id = borrower_id;
936: END IF;
937:
938: IF cust_account_id is NOT NULL

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

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

Line 1273: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone

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

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

1278: AND lnslkup.lookup_type = 'LNS_PARTICIPANT_TYPE'
1279: AND party.country = ter.TERRITORY_CODE(+)
1280: AND ter.LANGUAGE(+) = userenv('LANG')
1281: AND party.party_id = cp.owner_table_id(+)
1282: AND cp.owner_table_name(+) = 'HZ_PARTIES'
1283: AND cp.contact_point_type(+) = 'PHONE'
1284: AND cp.primary_flag(+) = 'Y'
1285: AND contact_person.party_id(+) =lp.contact_pers_party_id
1286: AND contact_party.party_id(+) =lp.contact_rel_party_id

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

1283: AND cp.contact_point_type(+) = 'PHONE'
1284: AND cp.primary_flag(+) = 'Y'
1285: AND contact_person.party_id(+) =lp.contact_pers_party_id
1286: AND contact_party.party_id(+) =lp.contact_rel_party_id
1287: AND con_phone.owner_table_name(+) = 'HZ_PARTIES'
1288: AND con_phone.owner_table_id(+) =lp.contact_rel_party_id
1289: AND con_phone.primary_flag(+) = 'Y'
1290: AND con_phone.status(+) = 'A'
1291: AND con_phone.contact_point_type(+) = 'PHONE'

Line 1365: HZ_PARTIES party,

1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,
1366: LNS_PARTICIPANTS par
1367: WHERE assetassign.asset_id = asset.asset_id and
1368: asset.asset_owner_id = par.hz_party_id and
1369: party.party_id = par.hz_party_id and

Line 1511: ,hz_parties party

1507: )
1508: )
1509: )
1510: from lns_disb_lines ldl
1511: ,hz_parties party
1512: ,IBY_PAYMENT_METHODS_TL ibypm
1513: where ldl.disb_header_id = ldih.disb_header_id
1514: and party.party_id = ldl.payee_party_id and
1515: ibypm.payment_method_code (+) = ldl.payment_method_code and

Line 1634: hz_parties hp,

1630: ) -- end of AMORTIZATION
1631: ), XMLFormat.createformat('ROWSET')).getClobVal()
1632: from
1633: lns_loan_headers_all_vl lh,
1634: hz_parties hp,
1635: lns_terms t,
1636: lns_int_rate_headers_vl intrt,
1637: lns_rate_schedules ratesch,
1638: hz_locations loc,