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 CSI_SYSTEMS_V

Line 4913: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,

4909: SELECT system_id
4910: INTO l_cust_sys_id
4911: FROM
4912: ( SELECT sys.system_id
4913: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4914: CSI_LOOKUPS LK
4915: WHERE sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4916: and acct.PARTY_ID = hzp.PARTY_ID
4917: and acct.account_number = l_instance.OWNER_ACCOUNT_NUMBER

Line 4923: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,

4919: and LK.LOOKUP_TYPE (+) = 'CSI_SYSTEM_TYPE'
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

Line 6517: FROM CSI_LOOKUPS LK, csi_systems_v s

6513: BEGIN
6514: UPDATE csi_webadi_staging cws SET SYSTEM_ID =
6515: (
6516: select s.SYSTEM_ID
6517: FROM CSI_LOOKUPS LK, csi_systems_v s
6518: WHERE s.SYSTEM_TYPE_CODE = LK.LOOKUP_CODE(+)
6519: AND LK.LOOKUP_TYPE (+) = 'CSI_SYSTEM_TYPE'
6520: AND s.NAME = cws.SYSTEM_NAME
6521: )