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_SETUP_UTIL_PUB dependencies on HZ_CUST_ACCOUNTS_ALL

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

4832: START WITH id = cp_line_id;
4833:
4834: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS
4835: SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
4836: FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
4837: WHERE csu.site_use_id = cp_bill_to_site_use_id
4838: AND cas.cust_acct_site_id = csu.cust_acct_site_id
4839: AND ca.cust_account_id = cas.cust_account_id;
4840:

Line 4843: FROM hz_cust_accounts_all ca

4839: AND ca.cust_account_id = cas.cust_account_id;
4840:
4841: CURSOR c_party_from_cust(cp_cust_acct_id IN NUMBER) IS
4842: SELECT ca.party_id party_id
4843: FROM hz_cust_accounts_all ca
4844: WHERE ca.cust_account_id = cp_cust_acct_id;
4845:
4846: CURSOR c_get_notes(cp_source_object_id IN NUMBER) IS
4847: SELECT jtf_note_id