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.CSI_MASS_EDIT_PUB dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 4924: HZ_CUST_ACCT_RELATE_ALL acctall, CSI_LOOKUPS LK

4920: and sys.name = l_instance.SYSTEM_NAME
4921: UNION
4922: SELECT sys.system_id
4923: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4924: HZ_CUST_ACCT_RELATE_ALL acctall, CSI_LOOKUPS LK
4925: WHERE sys.CUSTOMER_ID = acctall.RELATED_CUST_ACCOUNT_ID
4926: and sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4927: and acct.PARTY_ID = hzp.PARTY_ID
4928: and acctall.CUST_ACCOUNT_ID = acct.CUST_ACCOUNT_ID

Line 6448: SELECT 1 FROM HZ_CUST_ACCOUNTS CA2, HZ_CUST_ACCT_RELATE_ALL REL

6444: AND EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS CA1
6445: WHERE CA1.party_id = k_party.object1_id1 AND CA1.status = 'A'
6446: AND CA1.account_number = cws.OWNER_ACCOUNT_NUMBER
6447: UNION ALL
6448: SELECT 1 FROM HZ_CUST_ACCOUNTS CA2, HZ_CUST_ACCT_RELATE_ALL REL
6449: WHERE CA2.party_id = k_party.object1_id1
6450: AND REL.cust_account_id = CA2.CUST_ACCOUNT_ID
6451: AND REL.org_id = okch.AUTHORING_ORG_ID AND REL.status = 'A'
6452: AND CA2.status = 'A'