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.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 2042: hz_cust_site_uses_all site_use,

2038: --Added this cursor to fetch the cust_account_id to be populated into billto_cust_account_id column
2039: CURSOR c_cust_number (p_invoice_to_org_id IN NUMBER) IS
2040: SELECT cust.cust_account_id
2041: FROM hz_cust_acct_sites_all acct_site,
2042: hz_cust_site_uses_all site_use,
2043: hz_cust_accounts cust
2044: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2045: AND acct_site.cust_account_id = cust.cust_account_id
2046: AND site_use.site_use_id = p_invoice_to_org_id ;

Line 2155: FROM hz_cust_site_uses_all hzcsua,

2151: l_terr_countries_tbl terr_countries_tbl;
2152:
2153: CURSOR c_country_code(p_site_use_id NUMBER) IS
2154: SELECT hzloc.country
2155: FROM hz_cust_site_uses_all hzcsua,
2156: hz_cust_acct_sites_all hzcasa,
2157: hz_locations hzloc,
2158: hz_party_sites hzps
2159: WHERE hzcsua.cust_acct_site_id = hzcasa.cust_acct_site_id