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 789: ar_sites_assigned_v Sites_assigned

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)
792: AND cust.cust_account_id = Sites_assigned.cust_account_id
793: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id

Line 922: ar_sites_assigned_v Sites_assigned

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)
925: AND cust.cust_account_id = Sites_assigned.cust_account_id
926: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id

Line 1044: ar_sites_assigned_v Sites_assigned

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)
1047: AND cust.cust_account_id = Sites_assigned.cust_account_id
1048: AND Sites_assigned.cust_account_id = acct_sites.cust_account_id