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_PARTIES

Line 53: , HZ_PARTIES REL_CONTACT

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
57: , HZ_ORG_CONTACTS HOC

Line 54: , HZ_PARTIES ORG

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
57: , HZ_ORG_CONTACTS HOC
58: , HZ_RELATIONSHIPS REL

Line 55: , HZ_PARTIES PERSON

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
57: , HZ_ORG_CONTACTS HOC
58: , HZ_RELATIONSHIPS REL
59: , HZ_PARTY_SITES SITE

Line 78: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
81: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
82: AND C.STATUS = 'A')

Line 102: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
105: AND C.CONTACT_POINT_PURPOSE = 'PERSONAL'
106: AND C.STATUS = 'A')

Line 126: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
129: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
130: AND C.STATUS = 'A')

Line 150: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
153: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
154: AND C.STATUS = 'A')

Line 174: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
177: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
178: AND C.STATUS = 'A')

Line 195: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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')
198: ) CPT_EMAIL
199: WHERE NOT EXISTS (SELECT NULL

Line 387: FROM HZ_PARTIES REL_CONTACT

383: 1, 1,
384: 0, 1,
385: 0),
386: 1))) UPDATED_FLAG
387: FROM HZ_PARTIES REL_CONTACT
388: , HZ_PARTIES ORG
389: , HZ_PARTIES PERSON
390: , AR_LOOKUPS ARLK
391: , HZ_ORG_CONTACTS HOC

Line 388: , HZ_PARTIES ORG

384: 0, 1,
385: 0),
386: 1))) UPDATED_FLAG
387: FROM HZ_PARTIES REL_CONTACT
388: , HZ_PARTIES ORG
389: , HZ_PARTIES PERSON
390: , AR_LOOKUPS ARLK
391: , HZ_ORG_CONTACTS HOC
392: , HZ_RELATIONSHIPS REL

Line 389: , HZ_PARTIES PERSON

385: 0),
386: 1))) UPDATED_FLAG
387: FROM HZ_PARTIES REL_CONTACT
388: , HZ_PARTIES ORG
389: , HZ_PARTIES PERSON
390: , AR_LOOKUPS ARLK
391: , HZ_ORG_CONTACTS HOC
392: , HZ_RELATIONSHIPS REL
393: , HZ_PARTY_SITES SITE

Line 415: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
418: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
419: AND C.STATUS = 'A')

Line 440: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
443: AND C.CONTACT_POINT_PURPOSE = 'PERSONAL'
444: AND C.STATUS = 'A')

Line 465: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
468: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
469: AND C.STATUS = 'A')

Line 490: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
493: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
494: AND C.STATUS = 'A')

Line 515: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
518: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
519: AND C.STATUS = 'A')

Line 537: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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')
540: ) CPT_EMAIL
541: WHERE HPP.PARTY_ID = b_person_party_id

Line 665: FROM HZ_PARTIES REL_CONTACT

661: , CPT_CELL.CONTACT_POINT_ID CELL_PHONE_CONTACT_POINT_ID
662: , CPT_PAGER.CONTACT_POINT_ID PAGER_CONTACT_POINT_ID
663: , CPT_EMAIL.CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
664: , 'N' STATUS
665: FROM HZ_PARTIES REL_CONTACT
666: , HZ_PARTIES ORG
667: , HZ_PARTIES PERSON
668: , AR_LOOKUPS ARLK
669: , HZ_ORG_CONTACTS HOC

Line 666: , HZ_PARTIES ORG

662: , CPT_PAGER.CONTACT_POINT_ID PAGER_CONTACT_POINT_ID
663: , CPT_EMAIL.CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
664: , 'N' STATUS
665: FROM HZ_PARTIES REL_CONTACT
666: , HZ_PARTIES ORG
667: , HZ_PARTIES PERSON
668: , AR_LOOKUPS ARLK
669: , HZ_ORG_CONTACTS HOC
670: , HZ_RELATIONSHIPS REL

Line 667: , HZ_PARTIES PERSON

663: , CPT_EMAIL.CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
664: , 'N' STATUS
665: FROM HZ_PARTIES REL_CONTACT
666: , HZ_PARTIES ORG
667: , HZ_PARTIES PERSON
668: , AR_LOOKUPS ARLK
669: , HZ_ORG_CONTACTS HOC
670: , HZ_RELATIONSHIPS REL
671: , HZ_PARTY_SITES SITE

Line 693: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
696: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
697: AND C.STATUS = 'A')

Line 717: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
720: AND C.CONTACT_POINT_PURPOSE = 'PERSONAL'
721: AND C.STATUS = 'A')

Line 741: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
744: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
745: AND C.STATUS = 'A')

Line 765: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
768: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
769: AND C.STATUS = 'A')

Line 789: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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'
792: AND NVL(C.CONTACT_POINT_PURPOSE,'BUSINESS') = 'BUSINESS'
793: AND C.STATUS = 'A')

Line 810: AND C.OWNER_TABLE_NAME = 'HZ_PARTIES'

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')
813: ) CPT_EMAIL
814: WHERE HPP.PARTY_ID = b_person_party_id