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.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_ORIG_SYS_REFERENCES

Line 507: FROM HZ_ORIG_SYS_REFERENCES OSR

503: ATTRIBUTE17,
504: ATTRIBUTE18,
505: ATTRIBUTE19,
506: ATTRIBUTE20)
507: FROM HZ_ORIG_SYS_REFERENCES OSR
508: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
509: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
510: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
511: NULL, --HZ_CUSTOMER_PROFILE_BO

Line 883: FROM HZ_ORIG_SYS_REFERENCES OSR

879: ATTRIBUTE17,
880: ATTRIBUTE18,
881: ATTRIBUTE19,
882: ATTRIBUTE20)
883: FROM HZ_ORIG_SYS_REFERENCES OSR
884: WHERE
885: OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
886: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
887: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm

Line 928: FROM HZ_ORIG_SYS_REFERENCES OSR

924: ATTRIBUTE17,
925: ATTRIBUTE18,
926: ATTRIBUTE19,
927: ATTRIBUTE20)
928: FROM HZ_ORIG_SYS_REFERENCES OSR
929: WHERE
930: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
931: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
932: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm

Line 1253: FROM HZ_ORIG_SYS_REFERENCES OSR

1249: ATTRIBUTE17,
1250: ATTRIBUTE18,
1251: ATTRIBUTE19,
1252: ATTRIBUTE20)
1253: FROM HZ_ORIG_SYS_REFERENCES OSR
1254: WHERE OSR.OWNER_TABLE_ID = CSU.SITE_USE_ID
1255: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
1256: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1257: NULL, --HZ_CUSTOMER_PROFILE_BO

Line 1629: FROM HZ_ORIG_SYS_REFERENCES OSR

1625: ATTRIBUTE17,
1626: ATTRIBUTE18,
1627: ATTRIBUTE19,
1628: ATTRIBUTE20)
1629: FROM HZ_ORIG_SYS_REFERENCES OSR
1630: WHERE
1631: OSR.OWNER_TABLE_ID = CAS.CUST_ACCT_SITE_ID
1632: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
1633: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm

Line 1674: FROM HZ_ORIG_SYS_REFERENCES OSR

1670: ATTRIBUTE17,
1671: ATTRIBUTE18,
1672: ATTRIBUTE19,
1673: ATTRIBUTE20)
1674: FROM HZ_ORIG_SYS_REFERENCES OSR
1675: WHERE
1676: OSR.OWNER_TABLE_ID = CAS.PARTY_SITE_ID
1677: AND OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
1678: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm