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 AR_SITES_ASSIGNED_V

Line 925: ar_sites_assigned_v Sites_assigned

921: FROM
922: hz_cust_acct_sites acct_sites,
923: hz_party_sites party_sites,
924: hz_cust_accounts Cust,
925: ar_sites_assigned_v Sites_assigned
926: WHERE Sites_assigned.party_id = p_party_id
927: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
928: AND cust.cust_account_id = Sites_assigned.cust_account_id
929: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id

Line 1125: ar_sites_assigned_v Sites_assigned

1121: FROM
1122: hz_cust_acct_sites acct_sites,
1123: hz_party_sites party_sites,
1124: hz_cust_accounts Cust,
1125: ar_sites_assigned_v Sites_assigned
1126: WHERE -- Sites_assigned.party_id = p_party_id AND
1127: Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
1128: AND cust.cust_account_id = Sites_assigned.cust_account_id
1129: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id

Line 1259: ar_sites_assigned_v Sites_assigned

1255: FROM
1256: hz_cust_acct_sites acct_sites,
1257: hz_party_sites party_sites,
1258: hz_cust_accounts Cust,
1259: ar_sites_assigned_v Sites_assigned
1260: WHERE Sites_assigned.party_id = p_party_id
1261: AND Sites_assigned.cust_account_id=nvl(p_customer_id,Sites_assigned.cust_account_id)
1262: AND cust.cust_account_id = Sites_assigned.cust_account_id
1263: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id