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_VERIFY_PAYMENT_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 6042: From HZ_CUST_SITE_USES_ALL SITE,

6038:
6039: Begin
6040: /*Select party_site.party_id, acct_site.cust_account_id
6041: Into l_party_id, l_cust_account_id
6042: From HZ_CUST_SITE_USES_ALL SITE,
6043: HZ_PARTY_SITES PARTY_SITE,
6044: HZ_CUST_ACCT_SITES ACCT_SITE --Verify
6045: Where SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
6046: AND SITE.SITE_USE_CODE = 'BILL_TO'

Line 6054: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca

6050: */
6051:
6052: SELECT hca.party_id,acctsite.cust_account_id --acct_site. cust_account_id, site.cust_acct_site_id
6053: INTO l_party_id, l_cust_account_id
6054: FROM hz_cust_acct_sites_all acctsite, hz_cust_site_uses_all site, hz_cust_accounts_all hca
6055: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6056: AND SITE.CUST_ACCT_SITE_ID = ACCTSITE.CUST_ACCT_SITE_ID
6057: AND ACCTSITE.cust_account_id = HCA.cust_account_id
6058: -- 15900272 AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;

Line 8804: From HZ_CUST_SITE_USES_ALL SITE,

8800: END IF;
8801:
8802: Select hca.party_id, acct_site.cust_account_id
8803: Into l_party_id, l_cust_account_id
8804: From HZ_CUST_SITE_USES_ALL SITE,
8805: HZ_CUST_ACCT_SITES ACCT_SITE,
8806: HZ_CUST_ACCOUNTS_ALL HCA
8807: Where SITE.SITE_USE_ID = p_site_use_id
8808: AND SITE.SITE_USE_CODE = 'BILL_TO'