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_PARTY_PREFERENCES

Line 8: party preference table HZ_PARTY_PREFERENCES since last sync */

4: /* Modified cursor for bug 6147530 */
5: CURSOR c_new_contacts
6: /*
7: Getthe new contacts information from TCA HZ tables that have been newly added to the
8: party preference table HZ_PARTY_PREFERENCES since last sync */
9:
10: (b_principal_id NUMBER,
11: b_person_party_id NUMBER,
12: b_bookmark_module VARCHAR2,

Line 52: FROM HZ_PARTY_PREFERENCES HPP

48: , CPT_CELL.CONTACT_POINT_ID CELL_PHONE_CONTACT_POINT_ID
49: , CPT_PAGER.CONTACT_POINT_ID PAGER_CONTACT_POINT_ID
50: , CPT_EMAIL.CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
51: , 'N' STATUS
52: FROM HZ_PARTY_PREFERENCES HPP
53: , HZ_PARTIES REL_CONTACT
54: , HZ_PARTIES ORG
55: , HZ_PARTIES PERSON
56: , AR_LOOKUPS ARLK

Line 69: , HZ_PARTY_PREFERENCES PREF

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
73: AND PREF.MODULE = b_bookmark_module

Line 93: , HZ_PARTY_PREFERENCES PREF

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
97: AND PREF.MODULE = b_bookmark_module

Line 117: , HZ_PARTY_PREFERENCES PREF

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
121: AND PREF.MODULE = b_bookmark_module

Line 141: , HZ_PARTY_PREFERENCES PREF

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
145: AND PREF.MODULE = b_bookmark_module

Line 165: , HZ_PARTY_PREFERENCES PREF

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
169: AND PREF.MODULE = b_bookmark_module

Line 186: , HZ_PARTY_PREFERENCES PREF

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
190: AND PREF.MODULE = b_bookmark_module

Line 395: , HZ_PARTY_PREFERENCES HPP

391: , HZ_ORG_CONTACTS HOC
392: , HZ_RELATIONSHIPS REL
393: , HZ_PARTY_SITES SITE
394: , HZ_LOCATIONS LOC
395: , HZ_PARTY_PREFERENCES HPP
396: , CAC_SYNC_CONTACT_MAPPINGS CSPM
397: , (SELECT CP.OWNER_TABLE_ID
398: , CP.CONTACT_POINT_ID
399: , 'WORK;VOICE' CONTACT_TYPE

Line 406: , HZ_PARTY_PREFERENCES PREF

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
410: AND PREF.MODULE = b_bookmark_module

Line 431: , HZ_PARTY_PREFERENCES PREF

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
435: AND PREF.MODULE = b_bookmark_module

Line 456: , HZ_PARTY_PREFERENCES PREF

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
460: AND PREF.MODULE = b_bookmark_module

Line 481: , HZ_PARTY_PREFERENCES PREF

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
485: AND PREF.MODULE = b_bookmark_module

Line 506: , HZ_PARTY_PREFERENCES PREF

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
510: AND PREF.MODULE = b_bookmark_module

Line 528: , HZ_PARTY_PREFERENCES PREF

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
532: AND PREF.MODULE = b_bookmark_module

Line 612: FROM HZ_PARTY_PREFERENCES

608: NULL EMAIL_CONTACT_POINT_ID,
609: 'D' STATUS
610: FROM CAC_SYNC_MAPPINGS CSUM
611: WHERE NOT EXISTS (SELECT NULL
612: FROM HZ_PARTY_PREFERENCES
613: WHERE VALUE_NUMBER = CSUM.GUID
614: AND CATEGORY = b_bookmark_category
615: AND PREFERENCE_CODE = b_bookmark_preference
616: AND MODULE = b_bookmark_module

Line 673: , HZ_PARTY_PREFERENCES HPP

669: , HZ_ORG_CONTACTS HOC
670: , HZ_RELATIONSHIPS REL
671: , HZ_PARTY_SITES SITE
672: , HZ_LOCATIONS LOC
673: , HZ_PARTY_PREFERENCES HPP
674: , CAC_SYNC_CONTACT_MAPPINGS CSPM
675: , (SELECT CP.OWNER_TABLE_ID
676: , CP.CONTACT_POINT_ID
677: , 'WORK;VOICE' CONTACT_TYPE

Line 684: , HZ_PARTY_PREFERENCES PREF

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
688: AND PREF.MODULE = b_bookmark_module

Line 708: , HZ_PARTY_PREFERENCES PREF

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
712: AND PREF.MODULE = b_bookmark_module

Line 732: , HZ_PARTY_PREFERENCES PREF

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
736: AND PREF.MODULE = b_bookmark_module

Line 756: , HZ_PARTY_PREFERENCES PREF

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
760: AND PREF.MODULE = b_bookmark_module

Line 780: , HZ_PARTY_PREFERENCES PREF

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
784: AND PREF.MODULE = b_bookmark_module

Line 801: , HZ_PARTY_PREFERENCES PREF

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
805: AND PREF.MODULE = b_bookmark_module