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

Line 871: from hz_cust_site_uses_all uses

867: where hz.party_site_id in (
868: SELECT site.party_site_id from hz_cust_acct_sites_all site
869: where site.cust_acct_site_id in
870: ( select uses.cust_acct_site_id
871: from hz_cust_site_uses_all uses
872: where site_use_id = p_bill_to_site_use_id
873: and site_use_code = 'BILL_TO')
874: and nvl(site.org_id,p_org_id) = p_org_id);
875:

Line 947: from hz_cust_site_uses_all uses

943: p_org_id IN NUMBER) IS
944: SELECT site.cust_account_id from hz_cust_acct_sites_all site
945: where site.cust_acct_site_id in
946: ( select uses.cust_acct_site_id
947: from hz_cust_site_uses_all uses
948: where site_use_id = p_bill_to_site_use_id
949: and site_use_code = 'BILL_TO')
950: and nvl(site.org_id,p_org_id) = p_org_id;
951:

Line 2229: hz_cust_site_uses_all cs

2225: FROM hz_locations l,
2226: hz_party_sites ps,
2227: hz_cust_accounts hca,
2228: hz_cust_acct_sites_all ca,
2229: hz_cust_site_uses_all cs
2230: WHERE cs.site_use_id = p_id
2231: AND cs.site_use_code = p_code
2232: AND ca.cust_acct_site_id = cs.cust_acct_site_id
2233: AND ps.location_id = l.location_id

Line 2483: from hz_cust_site_uses_all uses

2479: p_cust_account_id IN NUMBER) IS
2480: SELECT site.cust_account_id from hz_cust_acct_sites_all site
2481: where site.cust_acct_site_id in
2482: ( select uses.cust_acct_site_id
2483: from hz_cust_site_uses_all uses
2484: where site_use_id = p_bill_to_site_use_id
2485: and site_use_code = 'BILL_TO')
2486: and nvl(site.org_id,p_org_id) = p_org_id
2487: and site.cust_account_id = p_cust_account_id;