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 4248: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca

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

Line 4255: FROM hz_cust_accounts_all ca

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