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_ACCT_SITES_ALL

Line 2041: FROM hz_cust_acct_sites_all acct_site,

2037: --ninarasi fix for bug 15991204
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

Line 2156: hz_cust_acct_sites_all hzcasa,

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
2160: AND hzcasa.party_site_id = hzps.party_site_id