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.OE_ACKNOWLEDGMENT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1624: From hz_cust_acct_sites_all a, hz_cust_site_uses_all b, hz_cust_accounts c

1620: -- { Start step 1 and 2
1621: -- Select the party_id and party_side id for the
1622: Select /* MOAC_SQL_CHANGE */ a.cust_acct_site_id, a.party_site_id, c.party_id
1623: Into l_cust_acct_site_id, l_party_site_id, l_party_id
1624: From hz_cust_acct_sites_all a, hz_cust_site_uses_all b, hz_cust_accounts c
1625: Where a.cust_acct_site_id = b.cust_acct_site_id
1626: And a.cust_account_id = p_customer_id
1627: And a.cust_account_id = c.cust_account_id
1628: /* And NVL(a.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),