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_REF_OBJ

Line 468: SELECT HZ_ORIG_SYS_REF_OBJ(

464: CSU.CREATION_DATE,
465: CSU.LAST_UPDATE_DATE,
466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
467: CAST(MULTISET (
468: SELECT HZ_ORIG_SYS_REF_OBJ(
469: NULL, --P_ACTION_TYPE,
470: ORIG_SYSTEM_REF_ID,
471: ORIG_SYSTEM,
472: ORIG_SYSTEM_REFERENCE,

Line 510: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

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
512: CAST(MULTISET (
513: SELECT HZ_BANK_ACCT_USE_OBJ(
514: P_ACTION_TYPE,

Line 844: SELECT HZ_ORIG_SYS_REF_OBJ(

840: PARTY_SITE_ID,
841: NULL, --PARTY_SITE_OS,
842: NULL, --PARTY_SITE_OSR,
843: CAST(MULTISET (
844: SELECT HZ_ORIG_SYS_REF_OBJ(
845: NULL, --P_ACTION_TYPE,
846: ORIG_SYSTEM_REF_ID,
847: ORIG_SYSTEM,
848: ORIG_SYSTEM_REFERENCE,

Line 887: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm

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
888: CAST(MULTISET (
889: SELECT HZ_ORIG_SYS_REF_OBJ(
890: NULL, --P_ACTION_TYPE,
891: ORIG_SYSTEM_REF_ID,

Line 889: SELECT HZ_ORIG_SYS_REF_OBJ(

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
888: CAST(MULTISET (
889: SELECT HZ_ORIG_SYS_REF_OBJ(
890: NULL, --P_ACTION_TYPE,
891: ORIG_SYSTEM_REF_ID,
892: ORIG_SYSTEM,
893: ORIG_SYSTEM_REFERENCE,

Line 932: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm

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
933: HZ_CUST_SITE_USE_BO_TBL(),
934: HZ_CUST_ACCT_CONTACT_BO_TBL())
935: FROM HZ_CUST_ACCT_SITES CAS
936: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)

Line 1214: SELECT HZ_ORIG_SYS_REF_OBJ(

1210: CSU.CREATION_DATE,
1211: CSU.LAST_UPDATE_DATE,
1212: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CSU.LAST_UPDATED_BY),
1213: CAST(MULTISET (
1214: SELECT HZ_ORIG_SYS_REF_OBJ(
1215: NULL, --P_ACTION_TYPE,
1216: ORIG_SYSTEM_REF_ID,
1217: ORIG_SYSTEM,
1218: ORIG_SYSTEM_REFERENCE,

Line 1256: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

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
1258: CAST(MULTISET (
1259: SELECT HZ_BANK_ACCT_USE_OBJ(
1260: P_ACTION_TYPE,

Line 1590: SELECT HZ_ORIG_SYS_REF_OBJ(

1586: PARTY_SITE_ID,
1587: NULL, --PARTY_SITE_OS,
1588: NULL, --PARTY_SITE_OSR,
1589: CAST(MULTISET (
1590: SELECT HZ_ORIG_SYS_REF_OBJ(
1591: NULL, --P_ACTION_TYPE,
1592: ORIG_SYSTEM_REF_ID,
1593: ORIG_SYSTEM,
1594: ORIG_SYSTEM_REFERENCE,

Line 1633: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct site ssm

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
1634: CAST(MULTISET (
1635: SELECT HZ_ORIG_SYS_REF_OBJ(
1636: NULL, --P_ACTION_TYPE,
1637: ORIG_SYSTEM_REF_ID,

Line 1635: SELECT HZ_ORIG_SYS_REF_OBJ(

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
1634: CAST(MULTISET (
1635: SELECT HZ_ORIG_SYS_REF_OBJ(
1636: NULL, --P_ACTION_TYPE,
1637: ORIG_SYSTEM_REF_ID,
1638: ORIG_SYSTEM,
1639: ORIG_SYSTEM_REFERENCE,

Line 1678: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- party site ssm

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
1679: HZ_CUST_SITE_USE_V2_BO_TBL(),
1680: HZ_CUST_ACCT_CONTACT_BO_TBL())
1681: FROM HZ_CUST_ACCT_SITES CAS
1682: WHERE ((P_CUST_ACCT_SITE_ID IS NULL AND CUST_ACCOUNT_ID = P_PARENT_ID)