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_CUSTOMERS_ASSIGNED_V

Line 1019: select cust_account_id from ar_customers_assigned_v where party_id=p_party_id AND cust_account_id=nvl(p_customer_id,cust_account_id)

1015:
1016: /* Check for account level access and insert all bill to sites */
1017:
1018: FOR customer_assigned_record IN (
1019: select cust_account_id from ar_customers_assigned_v where party_id=p_party_id AND cust_account_id=nvl(p_customer_id,cust_account_id)
1020: )LOOP
1021:
1022: FOR account_assigned_site IN (
1023: select CUST_ACCT_SITE_ID,org_id from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id

Line 1196: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)

1192:
1193: /* Check for account level access and insert all bill to sites */
1194:
1195: FOR customer_assigned_record IN (
1196: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)
1197: )LOOP
1198:
1199: FOR account_assigned_site IN (
1200: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id