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.PN_LEASE_UTILS dependencies on HZ_PARTY_SITES

Line 1695: hz_party_sites hps,

1691: SELECT hcsu.site_use_id customer_billtosite_use_id
1692: FROM fnd_lookups flo,
1693: hz_cust_site_uses_all hcsu,
1694: hz_cust_acct_sites_all hcas,
1695: hz_party_sites hps,
1696: hz_locations hlc,
1697: fnd_territories_tl ter
1698: WHERE hcas.cust_account_id = x_customer_id
1699: AND hcas.org_id = p_org_id

Line 2411: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter

2407:
2408: CURSOR c_customer_site
2409: IS
2410: SELECT hcsu.site_use_id
2411: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
2412: WHERE hcas.cust_account_id = p_customer_id
2413: AND hcas.org_id = p_org_id
2414: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
2415: AND hcsu.org_id = hcas.org_id

Line 2429: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter

2425:
2426: CURSOR c_customer_site_id
2427: IS
2428: SELECT hcsu.site_use_id
2429: FROM fnd_lookups flo, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hlc, fnd_territories_tl ter
2430: WHERE hcas.cust_account_id = p_customer_id
2431: AND hcas.org_id = p_org_id
2432: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
2433: AND hcsu.org_id = hcas.org_id