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_CONT_POINT_BO_PVT dependencies on HZ_CONTACT_POINTS

Line 26: Contact Point Y N HZ_CONTACT_POINTS

22: the particular object from these TCA entity tables.
23:
24: Embedded BO Mandatory Multiple Logical API Procedure Comments
25:
26: Contact Point Y N HZ_CONTACT_POINTS
27: Contact Preference N Y HZ_CONTACT_PREFERENCES
28:
29: */
30:

Line 172: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

168: ATTRIBUTE20)
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,

Line 204: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

200: CREATION_DATE,
201: LAST_UPDATE_DATE,
202: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
203: FROM HZ_CONTACT_PREFERENCES CPREF
204: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
205: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
206: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'PHONE'
207: AND ((P_PHONE_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
208: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 206: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'PHONE'

202: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
203: FROM HZ_CONTACT_PREFERENCES CPREF
204: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
205: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
206: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'PHONE'
207: AND ((P_PHONE_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
208: AND OWNER_TABLE_ID = P_PARENT_ID)
209: OR (P_PHONE_ID IS NOT NULL AND CONTACT_POINT_ID = P_PHONE_ID));
210:

Line 454: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

450: ATTRIBUTE20)
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,

Line 486: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

482: CREATION_DATE,
483: LAST_UPDATE_DATE,
484: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
485: FROM HZ_CONTACT_PREFERENCES CPREF
486: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
487: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
488: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'TLX'
489: AND ((P_TELEX_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
490: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 488: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'TLX'

484: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
485: FROM HZ_CONTACT_PREFERENCES CPREF
486: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
487: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
488: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'TLX'
489: AND ((P_TELEX_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
490: AND OWNER_TABLE_ID = P_PARENT_ID)
491: OR (P_TELEX_ID IS NOT NULL AND CONTACT_POINT_ID = P_TELEX_ID));
492:

Line 735: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

731: ATTRIBUTE20)
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,

Line 767: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

763: CREATION_DATE,
764: LAST_UPDATE_DATE,
765: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
766: FROM HZ_CONTACT_PREFERENCES CPREF
767: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
768: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
769: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EMAIL'
770: AND ((P_EMAIL_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
771: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 769: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EMAIL'

765: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
766: FROM HZ_CONTACT_PREFERENCES CPREF
767: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
768: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
769: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EMAIL'
770: AND ((P_EMAIL_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
771: AND OWNER_TABLE_ID = P_PARENT_ID)
772: OR (P_EMAIL_ID IS NOT NULL AND CONTACT_POINT_ID = P_EMAIL_ID));
773:

Line 1018: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

1014: ATTRIBUTE20)
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,

Line 1050: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

1046: CREATION_DATE,
1047: LAST_UPDATE_DATE,
1048: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1049: FROM HZ_CONTACT_PREFERENCES CPREF
1050: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1051: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1052: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'WEB'
1053: AND ((P_WEB_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1054: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 1052: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'WEB'

1048: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1049: FROM HZ_CONTACT_PREFERENCES CPREF
1050: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1051: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1052: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'WEB'
1053: AND ((P_WEB_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1054: AND OWNER_TABLE_ID = P_PARENT_ID)
1055: OR (P_WEB_ID IS NOT NULL AND CONTACT_POINT_ID = P_WEB_ID));
1056:

Line 1310: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

1306: ATTRIBUTE20)
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,

Line 1342: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

1338: CREATION_DATE,
1339: LAST_UPDATE_DATE,
1340: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1341: FROM HZ_CONTACT_PREFERENCES CPREF
1342: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1343: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1344: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EDI'
1345: AND ((P_EDI_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1346: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 1344: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EDI'

1340: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1341: FROM HZ_CONTACT_PREFERENCES CPREF
1342: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1343: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1344: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EDI'
1345: AND ((P_EDI_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1346: AND OWNER_TABLE_ID = P_PARENT_ID)
1347: OR (P_EDI_ID IS NOT NULL AND CONTACT_POINT_ID = P_EDI_ID));
1348:

Line 1594: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

1590: ATTRIBUTE20)
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,

Line 1626: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

1622: CREATION_DATE,
1623: LAST_UPDATE_DATE,
1624: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1625: FROM HZ_CONTACT_PREFERENCES CPREF
1626: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1627: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1628: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EFT'
1629: AND ((P_EFT_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1630: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 1628: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EFT'

1624: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1625: FROM HZ_CONTACT_PREFERENCES CPREF
1626: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1627: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1628: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'EFT'
1629: AND ((P_EFT_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1630: AND OWNER_TABLE_ID = P_PARENT_ID)
1631: OR (P_EFT_ID IS NOT NULL AND CONTACT_POINT_ID = P_EFT_ID));
1632:

Line 1884: AND OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

1880: ATTRIBUTE20)
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,

Line 1916: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'

1912: CREATION_DATE,
1913: LAST_UPDATE_DATE,
1914: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1915: FROM HZ_CONTACT_PREFERENCES CPREF
1916: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1917: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1918: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'SMS'
1919: AND ((P_SMS_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1920: AND OWNER_TABLE_ID = P_PARENT_ID)

Line 1918: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'SMS'

1914: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1915: FROM HZ_CONTACT_PREFERENCES CPREF
1916: WHERE CONTACT_LEVEL_TABLE = 'HZ_CONTACT_POINTS'
1917: AND CONTACT_LEVEL_TABLE_ID = CP.CONTACT_POINT_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
1918: FROM HZ_CONTACT_POINTS CP WHERE CONTACT_POINT_TYPE = 'SMS'
1919: AND ((P_SMS_ID IS NULL AND OWNER_TABLE_NAME = P_PARENT_TABLE_NAME
1920: AND OWNER_TABLE_ID = P_PARENT_ID)
1921: OR (P_SMS_ID IS NOT NULL AND CONTACT_POINT_ID = P_SMS_ID));
1922: