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.ARW_SEARCH_CUSTOMERS dependencies on HZ_PARTY_SITES

Line 787: hz_party_sites party_sites,

783: SELECT
784: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
785: FROM
786: hz_cust_acct_sites acct_sites,
787: hz_party_sites party_sites,
788: hz_cust_accounts Cust,
789: ar_sites_assigned_v Sites_assigned
790: WHERE Sites_assigned.party_id = p_party_id
791: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)

Line 920: hz_party_sites party_sites,

916: SELECT
917: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
918: FROM
919: hz_cust_acct_sites acct_sites,
920: hz_party_sites party_sites,
921: hz_cust_accounts Cust,
922: ar_sites_assigned_v Sites_assigned
923: WHERE -- Sites_assigned.party_id = p_party_id AND
924: Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)

Line 1042: hz_party_sites party_sites,

1038: SELECT
1039: Sites_assigned.CUST_ACCOUNT_ID account_id , acct_sites.CUST_ACCT_SITE_ID address_id
1040: FROM
1041: hz_cust_acct_sites acct_sites,
1042: hz_party_sites party_sites,
1043: hz_cust_accounts Cust,
1044: ar_sites_assigned_v Sites_assigned
1045: WHERE Sites_assigned.party_id = p_party_id
1046: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)