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_ACCT_SITES

Line 868: SELECT site.party_site_id from hz_cust_acct_sites_all site

864: Cursor hdr_party_cur(p_bill_to_site_use_id IN NUMBER,
865: p_org_id IN NUMBER) IS
866: SELECT hz.party_id from hz_party_sites hz
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

Line 944: SELECT site.cust_account_id from hz_cust_acct_sites_all site

940: /*Added cursor for bug 14337674*/
941:
942: Cursor cur_cust_account(p_bill_to_site_use_id IN NUMBER,
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

Line 2228: hz_cust_acct_sites_all ca,

2224: l.location_id ,hca.party_id ,cs.site_use_iD
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

Line 2480: SELECT site.cust_account_id from hz_cust_acct_sites_all site

2476:
2477: Cursor check_for_account_id(p_bill_to_site_use_id IN NUMBER,
2478: p_org_id IN NUMBER,
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

Line 2663: FROM hz_cust_acct_sites a,

2659:
2660: CURSOR tax_info_csr(p_site_use_id IN NUMBER) IS
2661: SELECT c.party_id,
2662: a.party_site_id
2663: FROM hz_cust_acct_sites a,
2664: hz_cust_site_uses b,
2665: hz_party_sites c
2666: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2667: AND c.party_site_id = a.party_site_id