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 933: from hz_cust_site_uses_all uses

929: p_org_id IN NUMBER) IS
930: SELECT site.cust_account_id from hz_cust_acct_sites_all site
931: where site.cust_acct_site_id in
932: ( select uses.cust_acct_site_id
933: from hz_cust_site_uses_all uses
934: where site_use_id = p_bill_to_site_use_id
935: and site_use_code = 'BILL_TO')
936: and nvl(site.org_id,p_org_id) = p_org_id;
937:

Line 2211: hz_cust_site_uses_all cs

2207: FROM hz_locations l,
2208: hz_party_sites ps,
2209: hz_cust_accounts hca,
2210: hz_cust_acct_sites_all ca,
2211: hz_cust_site_uses_all cs
2212: WHERE cs.site_use_id = p_id
2213: AND cs.site_use_code = p_code
2214: AND ca.cust_acct_site_id = cs.cust_acct_site_id
2215: AND ps.location_id = l.location_id

Line 2464: from hz_cust_site_uses_all uses

2460: p_cust_account_id IN NUMBER) IS
2461: SELECT site.cust_account_id from hz_cust_acct_sites_all site
2462: where site.cust_acct_site_id in
2463: ( select uses.cust_acct_site_id
2464: from hz_cust_site_uses_all uses
2465: where site_use_id = p_bill_to_site_use_id
2466: and site_use_code = 'BILL_TO')
2467: and nvl(site.org_id,p_org_id) = p_org_id
2468: and site.cust_account_id = p_cust_account_id;