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.

[Home] [Help]

APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ

Line 130: SELECT HZ_ORIG_SYS_REF_OBJ(

126: PHONE_EXTENSION,
127: PHONE_LINE_TYPE,
128: RAW_PHONE_NUMBER,
129: CAST(MULTISET (
130: SELECT HZ_ORIG_SYS_REF_OBJ(
131: NULL, --P_ACTION_TYPE,
132: ORIG_SYSTEM_REF_ID,
133: ORIG_SYSTEM,
134: ORIG_SYSTEM_REFERENCE,

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

169: FROM HZ_ORIG_SYS_REFERENCES OSR
170: WHERE
171: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
172: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
173: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
174: CAST(MULTISET (
175: SELECT HZ_CONTACT_PREF_OBJ(
176: P_ACTION_TYPE,
177: NULL, -- COMMON_OBJ_ID

Line 412: SELECT HZ_ORIG_SYS_REF_OBJ(

408: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
409: ACTUAL_CONTENT_SOURCE,
410: TELEX_NUMBER,
411: CAST(MULTISET (
412: SELECT HZ_ORIG_SYS_REF_OBJ(
413: NULL, --P_ACTION_TYPE,
414: ORIG_SYSTEM_REF_ID,
415: ORIG_SYSTEM,
416: ORIG_SYSTEM_REFERENCE,

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

451: FROM HZ_ORIG_SYS_REFERENCES OSR
452: WHERE
453: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
454: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
455: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
456: CAST(MULTISET (
457: SELECT HZ_CONTACT_PREF_OBJ(
458: P_ACTION_TYPE,
459: NULL, -- COMMON_OBJ_ID

Line 693: SELECT HZ_ORIG_SYS_REF_OBJ(

689: ACTUAL_CONTENT_SOURCE,
690: EMAIL_FORMAT,
691: EMAIL_ADDRESS,
692: CAST(MULTISET (
693: SELECT HZ_ORIG_SYS_REF_OBJ(
694: NULL, --P_ACTION_TYPE,
695: ORIG_SYSTEM_REF_ID,
696: ORIG_SYSTEM,
697: ORIG_SYSTEM_REFERENCE,

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

732: FROM HZ_ORIG_SYS_REFERENCES OSR
733: WHERE
734: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
735: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
736: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
737: CAST(MULTISET (
738: SELECT HZ_CONTACT_PREF_OBJ(
739: P_ACTION_TYPE,
740: NULL, -- COMMON_OBJ_ID

Line 976: SELECT HZ_ORIG_SYS_REF_OBJ(

972: ACTUAL_CONTENT_SOURCE,
973: WEB_TYPE,
974: URL,
975: CAST(MULTISET (
976: SELECT HZ_ORIG_SYS_REF_OBJ(
977: NULL, --P_ACTION_TYPE,
978: ORIG_SYSTEM_REF_ID,
979: ORIG_SYSTEM,
980: ORIG_SYSTEM_REFERENCE,

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

1015: FROM HZ_ORIG_SYS_REFERENCES OSR
1016: WHERE
1017: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1018: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1019: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1020: CAST(MULTISET (
1021: SELECT HZ_CONTACT_PREF_OBJ(
1022: P_ACTION_TYPE,
1023: NULL, -- COMMON_OBJ_ID

Line 1268: SELECT HZ_ORIG_SYS_REF_OBJ(

1264: EDI_REMITTANCE_INSTRUCTION,
1265: EDI_TP_HEADER_ID,
1266: EDI_ECE_TP_LOCATION_CODE,
1267: CAST(MULTISET (
1268: SELECT HZ_ORIG_SYS_REF_OBJ(
1269: NULL, --P_ACTION_TYPE,
1270: ORIG_SYSTEM_REF_ID,
1271: ORIG_SYSTEM,
1272: ORIG_SYSTEM_REFERENCE,

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

1307: FROM HZ_ORIG_SYS_REFERENCES OSR
1308: WHERE
1309: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1310: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1311: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1312: CAST(MULTISET (
1313: SELECT HZ_CONTACT_PREF_OBJ(
1314: P_ACTION_TYPE,
1315: NULL, -- COMMON_OBJ_ID

Line 1552: SELECT HZ_ORIG_SYS_REF_OBJ(

1548: EFT_PRINTING_PROGRAM_ID,
1549: EFT_USER_NUMBER,
1550: EFT_SWIFT_CODE,
1551: CAST(MULTISET (
1552: SELECT HZ_ORIG_SYS_REF_OBJ(
1553: NULL, --P_ACTION_TYPE,
1554: ORIG_SYSTEM_REF_ID,
1555: ORIG_SYSTEM,
1556: ORIG_SYSTEM_REFERENCE,

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

1591: FROM HZ_ORIG_SYS_REFERENCES OSR
1592: WHERE
1593: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1594: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1595: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1596: CAST(MULTISET (
1597: SELECT HZ_CONTACT_PREF_OBJ(
1598: P_ACTION_TYPE,
1599: NULL, -- COMMON_OBJ_ID

Line 1842: SELECT HZ_ORIG_SYS_REF_OBJ(

1838: PHONE_EXTENSION,
1839: PHONE_LINE_TYPE,
1840: RAW_PHONE_NUMBER,
1841: CAST(MULTISET (
1842: SELECT HZ_ORIG_SYS_REF_OBJ(
1843: NULL, --P_ACTION_TYPE,
1844: ORIG_SYSTEM_REF_ID,
1845: ORIG_SYSTEM,
1846: ORIG_SYSTEM_REFERENCE,

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

1881: FROM HZ_ORIG_SYS_REFERENCES OSR
1882: WHERE
1883: OSR.OWNER_TABLE_ID = CP.CONTACT_POINT_ID
1884: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
1885: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1886: CAST(MULTISET (
1887: SELECT HZ_CONTACT_PREF_OBJ(
1888: P_ACTION_TYPE,
1889: NULL, -- COMMON_OBJ_ID