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.CAC_SYNC_CONTACTS_PVT dependencies on HZ_CONTACT_POINTS

Line 68: FROM HZ_CONTACT_POINTS CP

64: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
65: CP.PHONE_AREA_CODE,
66: CP.PHONE_NUMBER,
67: CP.PHONE_EXTENSION) PHONE_NUMBER
68: FROM HZ_CONTACT_POINTS CP
69: , HZ_PARTY_PREFERENCES PREF
70: WHERE PREF.PARTY_ID = b_person_party_id
71: AND PREF.CATEGORY = b_bookmark_category
72: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 76: FROM HZ_CONTACT_POINTS C

72: AND PREF.PREFERENCE_CODE = b_bookmark_preference
73: AND PREF.MODULE = b_bookmark_module
74: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
75: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
76: FROM HZ_CONTACT_POINTS C
77: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
78: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
79: AND C.CONTACT_POINT_TYPE = 'PHONE'
80: AND C.PHONE_LINE_TYPE = 'GEN'

Line 92: FROM HZ_CONTACT_POINTS CP

88: CP.PHONE_AREA_CODE,
89: CP.PHONE_NUMBER,
90: CP.PHONE_EXTENSION) PHONE_NUMBER
91:
92: FROM HZ_CONTACT_POINTS CP
93: , HZ_PARTY_PREFERENCES PREF
94: WHERE PREF.PARTY_ID = b_person_party_id
95: AND PREF.CATEGORY = b_bookmark_category
96: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 100: FROM HZ_CONTACT_POINTS C

96: AND PREF.PREFERENCE_CODE = b_bookmark_preference
97: AND PREF.MODULE = b_bookmark_module
98: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
99: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
100: FROM HZ_CONTACT_POINTS C
101: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
102: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
103: AND C.CONTACT_POINT_TYPE = 'PHONE'
104: AND C.PHONE_LINE_TYPE = 'GEN'

Line 116: FROM HZ_CONTACT_POINTS CP

112: CP.PHONE_AREA_CODE,
113: CP.PHONE_NUMBER,
114: CP.PHONE_EXTENSION) PHONE_NUMBER
115:
116: FROM HZ_CONTACT_POINTS CP
117: , HZ_PARTY_PREFERENCES PREF
118: WHERE PREF.PARTY_ID = b_person_party_id
119: AND PREF.CATEGORY = b_bookmark_category
120: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 124: FROM HZ_CONTACT_POINTS C

120: AND PREF.PREFERENCE_CODE = b_bookmark_preference
121: AND PREF.MODULE = b_bookmark_module
122: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
123: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
124: FROM HZ_CONTACT_POINTS C
125: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
126: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
127: AND C.CONTACT_POINT_TYPE = 'PHONE'
128: AND C.PHONE_LINE_TYPE = 'FAX'

Line 140: FROM HZ_CONTACT_POINTS CP

136: CP.PHONE_AREA_CODE,
137: CP.PHONE_NUMBER,
138: CP.PHONE_EXTENSION) PHONE_NUMBER
139:
140: FROM HZ_CONTACT_POINTS CP
141: , HZ_PARTY_PREFERENCES PREF
142: WHERE PREF.PARTY_ID = b_person_party_id
143: AND PREF.CATEGORY = b_bookmark_category
144: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 148: FROM HZ_CONTACT_POINTS C

144: AND PREF.PREFERENCE_CODE = b_bookmark_preference
145: AND PREF.MODULE = b_bookmark_module
146: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
147: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
148: FROM HZ_CONTACT_POINTS C
149: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
150: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
151: AND C.CONTACT_POINT_TYPE = 'PHONE'
152: AND C.PHONE_LINE_TYPE = 'MOBILE'

Line 164: FROM HZ_CONTACT_POINTS CP

160: CP.PHONE_AREA_CODE,
161: CP.PHONE_NUMBER,
162: CP.PHONE_EXTENSION) PHONE_NUMBER
163:
164: FROM HZ_CONTACT_POINTS CP
165: , HZ_PARTY_PREFERENCES PREF
166: WHERE PREF.PARTY_ID = b_person_party_id
167: AND PREF.CATEGORY = b_bookmark_category
168: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 172: FROM HZ_CONTACT_POINTS C

168: AND PREF.PREFERENCE_CODE = b_bookmark_preference
169: AND PREF.MODULE = b_bookmark_module
170: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
171: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
172: FROM HZ_CONTACT_POINTS C
173: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
174: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
175: AND C.CONTACT_POINT_TYPE = 'PHONE'
176: AND C.PHONE_LINE_TYPE = 'PAGER'

Line 185: FROM HZ_CONTACT_POINTS CP

181: , CP.CONTACT_POINT_ID
182: , 'EMAIL' CONTACT_TYPE
183: , CP.EMAIL_FORMAT
184: , CP.EMAIL_ADDRESS
185: FROM HZ_CONTACT_POINTS CP
186: , HZ_PARTY_PREFERENCES PREF
187: WHERE PREF.PARTY_ID = b_person_party_id
188: AND PREF.CATEGORY = b_bookmark_category
189: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 193: FROM HZ_CONTACT_POINTS C

189: AND PREF.PREFERENCE_CODE = b_bookmark_preference
190: AND PREF.MODULE = b_bookmark_module
191: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
192: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
193: FROM HZ_CONTACT_POINTS C
194: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
195: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
196: AND C.CONTACT_POINT_TYPE = 'EMAIL'
197: AND C.STATUS = 'A')

Line 405: FROM HZ_CONTACT_POINTS CP

401: CP.PHONE_AREA_CODE,
402: CP.PHONE_NUMBER,
403: CP.PHONE_EXTENSION) PHONE_NUMBER
404: , CP.LAST_UPDATE_DATE
405: FROM HZ_CONTACT_POINTS CP
406: , HZ_PARTY_PREFERENCES PREF
407: WHERE PREF.PARTY_ID = b_person_party_id
408: AND PREF.CATEGORY = b_bookmark_category
409: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 413: FROM HZ_CONTACT_POINTS C

409: AND PREF.PREFERENCE_CODE = b_bookmark_preference
410: AND PREF.MODULE = b_bookmark_module
411: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
412: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
413: FROM HZ_CONTACT_POINTS C
414: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
415: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
416: AND C.CONTACT_POINT_TYPE = 'PHONE'
417: AND C.PHONE_LINE_TYPE = 'GEN'

Line 430: FROM HZ_CONTACT_POINTS CP

426: CP.PHONE_NUMBER,
427: CP.PHONE_EXTENSION) PHONE_NUMBER
428:
429: , CP.LAST_UPDATE_DATE
430: FROM HZ_CONTACT_POINTS CP
431: , HZ_PARTY_PREFERENCES PREF
432: WHERE PREF.PARTY_ID = b_person_party_id
433: AND PREF.CATEGORY = b_bookmark_category
434: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 438: FROM HZ_CONTACT_POINTS C

434: AND PREF.PREFERENCE_CODE = b_bookmark_preference
435: AND PREF.MODULE = b_bookmark_module
436: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
437: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
438: FROM HZ_CONTACT_POINTS C
439: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
440: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
441: AND C.CONTACT_POINT_TYPE = 'PHONE'
442: AND C.PHONE_LINE_TYPE = 'GEN'

Line 455: FROM HZ_CONTACT_POINTS CP

451: CP.PHONE_NUMBER,
452: CP.PHONE_EXTENSION) PHONE_NUMBER
453:
454: , CP.LAST_UPDATE_DATE
455: FROM HZ_CONTACT_POINTS CP
456: , HZ_PARTY_PREFERENCES PREF
457: WHERE PREF.PARTY_ID = b_person_party_id
458: AND PREF.CATEGORY = b_bookmark_category
459: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 463: FROM HZ_CONTACT_POINTS C

459: AND PREF.PREFERENCE_CODE = b_bookmark_preference
460: AND PREF.MODULE = b_bookmark_module
461: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
462: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
463: FROM HZ_CONTACT_POINTS C
464: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
465: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
466: AND C.CONTACT_POINT_TYPE = 'PHONE'
467: AND C.PHONE_LINE_TYPE = 'FAX'

Line 480: FROM HZ_CONTACT_POINTS CP

476: CP.PHONE_NUMBER,
477: CP.PHONE_EXTENSION) PHONE_NUMBER
478:
479: , CP.LAST_UPDATE_DATE
480: FROM HZ_CONTACT_POINTS CP
481: , HZ_PARTY_PREFERENCES PREF
482: WHERE PREF.PARTY_ID = b_person_party_id
483: AND PREF.CATEGORY = b_bookmark_category
484: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 488: FROM HZ_CONTACT_POINTS C

484: AND PREF.PREFERENCE_CODE = b_bookmark_preference
485: AND PREF.MODULE = b_bookmark_module
486: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
487: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
488: FROM HZ_CONTACT_POINTS C
489: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
490: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
491: AND C.CONTACT_POINT_TYPE = 'PHONE'
492: AND C.PHONE_LINE_TYPE = 'MOBILE'

Line 505: FROM HZ_CONTACT_POINTS CP

501: CP.PHONE_NUMBER,
502: CP.PHONE_EXTENSION) PHONE_NUMBER
503:
504: , CP.LAST_UPDATE_DATE
505: FROM HZ_CONTACT_POINTS CP
506: , HZ_PARTY_PREFERENCES PREF
507: WHERE PREF.PARTY_ID = b_person_party_id
508: AND PREF.CATEGORY = b_bookmark_category
509: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 513: FROM HZ_CONTACT_POINTS C

509: AND PREF.PREFERENCE_CODE = b_bookmark_preference
510: AND PREF.MODULE = b_bookmark_module
511: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
512: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
513: FROM HZ_CONTACT_POINTS C
514: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
515: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
516: AND C.CONTACT_POINT_TYPE = 'PHONE'
517: AND C.PHONE_LINE_TYPE = 'PAGER'

Line 527: FROM HZ_CONTACT_POINTS CP

523: , 'EMAIL' CONTACT_TYPE
524: , CP.EMAIL_FORMAT
525: , CP.EMAIL_ADDRESS
526: , CP.LAST_UPDATE_DATE
527: FROM HZ_CONTACT_POINTS CP
528: , HZ_PARTY_PREFERENCES PREF
529: WHERE PREF.PARTY_ID = b_person_party_id
530: AND PREF.CATEGORY = b_bookmark_category
531: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 535: FROM HZ_CONTACT_POINTS C

531: AND PREF.PREFERENCE_CODE = b_bookmark_preference
532: AND PREF.MODULE = b_bookmark_module
533: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
534: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
535: FROM HZ_CONTACT_POINTS C
536: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
537: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
538: AND C.CONTACT_POINT_TYPE = 'EMAIL'
539: AND C.STATUS = 'A')

Line 683: FROM HZ_CONTACT_POINTS CP

679: CP.PHONE_AREA_CODE,
680: CP.PHONE_NUMBER,
681: CP.PHONE_EXTENSION) PHONE_NUMBER
682:
683: FROM HZ_CONTACT_POINTS CP
684: , HZ_PARTY_PREFERENCES PREF
685: WHERE PREF.PARTY_ID = b_person_party_id
686: AND PREF.CATEGORY = b_bookmark_category
687: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 691: FROM HZ_CONTACT_POINTS C

687: AND PREF.PREFERENCE_CODE = b_bookmark_preference
688: AND PREF.MODULE = b_bookmark_module
689: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
690: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
691: FROM HZ_CONTACT_POINTS C
692: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
693: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
694: AND C.CONTACT_POINT_TYPE = 'PHONE'
695: AND C.PHONE_LINE_TYPE = 'GEN'

Line 707: FROM HZ_CONTACT_POINTS CP

703: CP.PHONE_AREA_CODE,
704: CP.PHONE_NUMBER,
705: CP.PHONE_EXTENSION) PHONE_NUMBER
706:
707: FROM HZ_CONTACT_POINTS CP
708: , HZ_PARTY_PREFERENCES PREF
709: WHERE PREF.PARTY_ID = b_person_party_id
710: AND PREF.CATEGORY = b_bookmark_category
711: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 715: FROM HZ_CONTACT_POINTS C

711: AND PREF.PREFERENCE_CODE = b_bookmark_preference
712: AND PREF.MODULE = b_bookmark_module
713: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
714: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
715: FROM HZ_CONTACT_POINTS C
716: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
717: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
718: AND C.CONTACT_POINT_TYPE = 'PHONE'
719: AND C.PHONE_LINE_TYPE = 'GEN'

Line 731: FROM HZ_CONTACT_POINTS CP

727: CP.PHONE_AREA_CODE,
728: CP.PHONE_NUMBER,
729: CP.PHONE_EXTENSION) PHONE_NUMBER
730:
731: FROM HZ_CONTACT_POINTS CP
732: , HZ_PARTY_PREFERENCES PREF
733: WHERE PREF.PARTY_ID = b_person_party_id
734: AND PREF.CATEGORY = b_bookmark_category
735: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 739: FROM HZ_CONTACT_POINTS C

735: AND PREF.PREFERENCE_CODE = b_bookmark_preference
736: AND PREF.MODULE = b_bookmark_module
737: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
738: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
739: FROM HZ_CONTACT_POINTS C
740: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
741: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
742: AND C.CONTACT_POINT_TYPE = 'PHONE'
743: AND C.PHONE_LINE_TYPE = 'FAX'

Line 755: FROM HZ_CONTACT_POINTS CP

751: CP.PHONE_AREA_CODE,
752: CP.PHONE_NUMBER,
753: CP.PHONE_EXTENSION) PHONE_NUMBER
754:
755: FROM HZ_CONTACT_POINTS CP
756: , HZ_PARTY_PREFERENCES PREF
757: WHERE PREF.PARTY_ID = b_person_party_id
758: AND PREF.CATEGORY = b_bookmark_category
759: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 763: FROM HZ_CONTACT_POINTS C

759: AND PREF.PREFERENCE_CODE = b_bookmark_preference
760: AND PREF.MODULE = b_bookmark_module
761: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
762: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
763: FROM HZ_CONTACT_POINTS C
764: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
765: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
766: AND C.CONTACT_POINT_TYPE = 'PHONE'
767: AND C.PHONE_LINE_TYPE = 'MOBILE'

Line 779: FROM HZ_CONTACT_POINTS CP

775: CP.PHONE_AREA_CODE,
776: CP.PHONE_NUMBER,
777: CP.PHONE_EXTENSION) PHONE_NUMBER
778:
779: FROM HZ_CONTACT_POINTS CP
780: , HZ_PARTY_PREFERENCES PREF
781: WHERE PREF.PARTY_ID = b_person_party_id
782: AND PREF.CATEGORY = b_bookmark_category
783: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 787: FROM HZ_CONTACT_POINTS C

783: AND PREF.PREFERENCE_CODE = b_bookmark_preference
784: AND PREF.MODULE = b_bookmark_module
785: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
786: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
787: FROM HZ_CONTACT_POINTS C
788: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
789: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
790: AND C.CONTACT_POINT_TYPE = 'PHONE'
791: AND C.PHONE_LINE_TYPE = 'PAGER'

Line 800: FROM HZ_CONTACT_POINTS CP

796: , CP.CONTACT_POINT_ID
797: , 'EMAIL' CONTACT_TYPE
798: , CP.EMAIL_FORMAT
799: , CP.EMAIL_ADDRESS
800: FROM HZ_CONTACT_POINTS CP
801: , HZ_PARTY_PREFERENCES PREF
802: WHERE PREF.PARTY_ID = b_person_party_id
803: AND PREF.CATEGORY = b_bookmark_category
804: AND PREF.PREFERENCE_CODE = b_bookmark_preference

Line 808: FROM HZ_CONTACT_POINTS C

804: AND PREF.PREFERENCE_CODE = b_bookmark_preference
805: AND PREF.MODULE = b_bookmark_module
806: AND CP.OWNER_TABLE_ID = PREF.VALUE_NUMBER
807: AND CP.CONTACT_POINT_ID = (SELECT MIN(CONTACT_POINT_ID)
808: FROM HZ_CONTACT_POINTS C
809: WHERE C.OWNER_TABLE_ID = PREF.VALUE_NUMBER
810: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'
811: AND C.CONTACT_POINT_TYPE = 'EMAIL'
812: AND C.STATUS = 'A')