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.OKS_RENCPY_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 4246: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca

4242: l_error_text VARCHAR2(512);
4243:
4244: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS
4245: SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
4246: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
4247: WHERE csu.site_use_id = cp_bill_to_site_use_id
4248: AND cas.cust_acct_site_id = csu.cust_acct_site_id
4249: AND ca.cust_account_id = cas.cust_account_id;
4250:

Line 4253: FROM hz_cust_accounts_all ca

4249: AND ca.cust_account_id = cas.cust_account_id;
4250:
4251: CURSOR c_party_from_cust(cp_cust_acct_id IN NUMBER) IS
4252: SELECT ca.party_id party_id
4253: FROM hz_cust_accounts_all ca
4254: WHERE ca.cust_account_id = cp_cust_acct_id;
4255:
4256: CURSOR c_instr(cp_trx_ext_id IN NUMBER) IS
4257: SELECT instr_assignment_id