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_MERGE_EVENT_PKG dependencies on HZ_ORIG_SYS_REF_OBJ

Line 102: HZ_ORIG_SYS_REF_OBJ_TBL()),

98: tp.party_id,
99: tp.party_number,
100: tp.party_name,
101: tp.party_type,
102: HZ_ORIG_SYS_REF_OBJ_TBL()),
103: HZ_PARTY_ORIG_SYS_REF_OBJ(
104: fp.party_id,
105: fp.party_number,
106: fp.party_name,

Line 108: HZ_ORIG_SYS_REF_OBJ_TBL()),

104: fp.party_id,
105: fp.party_number,
106: fp.party_name,
107: fp.party_type,
108: HZ_ORIG_SYS_REF_OBJ_TBL()),
109: HZ_ACCT_ORIG_SYS_REF_OBJ(
110: ta.cust_account_id,
111: ta.account_name,
112: ta.account_number,

Line 113: HZ_ORIG_SYS_REF_OBJ_TBL()),

109: HZ_ACCT_ORIG_SYS_REF_OBJ(
110: ta.cust_account_id,
111: ta.account_name,
112: ta.account_number,
113: HZ_ORIG_SYS_REF_OBJ_TBL()),
114: CAST(MULTISET (
115: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
116: fa.cust_account_id,
117: fa.account_name,

Line 119: HZ_ORIG_SYS_REF_OBJ_TBL())

115: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
116: fa.cust_account_id,
117: fa.account_name,
118: fa.account_number,
119: HZ_ORIG_SYS_REF_OBJ_TBL())
120: FROM hz_cust_accounts_m fa
121: WHERE fa.cust_account_id = mh.duplicate_id
122: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
123: )

Line 345: HZ_ORIG_SYS_REF_OBJ_TBL()),

341: tp.party_id,
342: tp.party_number,
343: tp.party_name,
344: tp.party_type,
345: HZ_ORIG_SYS_REF_OBJ_TBL()),
346: HZ_PARTY_ORIG_SYS_REF_OBJ(
347: fp.party_id,
348: fp.party_number,
349: fp.party_name,

Line 351: HZ_ORIG_SYS_REF_OBJ_TBL()),

347: fp.party_id,
348: fp.party_number,
349: fp.party_name,
350: fp.party_type,
351: HZ_ORIG_SYS_REF_OBJ_TBL()),
352: HZ_ACCT_ORIG_SYS_REF_OBJ(
353: ta.cust_account_id,
354: ta.account_name,
355: ta.account_number,

Line 356: HZ_ORIG_SYS_REF_OBJ_TBL()),

352: HZ_ACCT_ORIG_SYS_REF_OBJ(
353: ta.cust_account_id,
354: ta.account_name,
355: ta.account_number,
356: HZ_ORIG_SYS_REF_OBJ_TBL()),
357: CAST(MULTISET (
358: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
359: fa.cust_account_id,
360: fa.account_name,

Line 362: HZ_ORIG_SYS_REF_OBJ_TBL())

358: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
359: fa.cust_account_id,
360: fa.account_name,
361: fa.account_number,
362: HZ_ORIG_SYS_REF_OBJ_TBL())
363: FROM hz_cust_accounts_m fa
364: WHERE fa.cust_account_id = mh.duplicate_id
365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS

Line 390: SELECT HZ_ORIG_SYS_REF_OBJ(

386: cm.org_id,
387: get_operating_unit(cm.org_id),
388: cm.duplicate_address_id,
389: CAST(MULTISET(
390: SELECT HZ_ORIG_SYS_REF_OBJ(
391: NULL,
392: ORIG_SYSTEM_REF_ID,
393: ORIG_SYSTEM,
394: ORIG_SYSTEM_REFERENCE,

Line 433: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

429: )
430: FROM HZ_ORIG_SYS_REFERENCES
431: WHERE OWNER_TABLE_ID = cm.duplicate_address_id
432: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
433: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
434: cm.customer_address_id,
435: CAST(MULTISET(
436: SELECT HZ_ORIG_SYS_REF_OBJ(
437: NULL,

Line 436: SELECT HZ_ORIG_SYS_REF_OBJ(

432: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
433: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
434: cm.customer_address_id,
435: CAST(MULTISET(
436: SELECT HZ_ORIG_SYS_REF_OBJ(
437: NULL,
438: ORIG_SYSTEM_REF_ID,
439: ORIG_SYSTEM,
440: ORIG_SYSTEM_REFERENCE,

Line 479: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

475: )
476: FROM HZ_ORIG_SYS_REFERENCES
477: WHERE OWNER_TABLE_ID = cm.customer_address_id
478: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
479: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
480: cm.duplicate_id,
481: CAST(MULTISET(
482: SELECT HZ_ORIG_SYS_REF_OBJ(
483: NULL,

Line 482: SELECT HZ_ORIG_SYS_REF_OBJ(

478: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
479: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
480: cm.duplicate_id,
481: CAST(MULTISET(
482: SELECT HZ_ORIG_SYS_REF_OBJ(
483: NULL,
484: ORIG_SYSTEM_REF_ID,
485: ORIG_SYSTEM,
486: ORIG_SYSTEM_REFERENCE,

Line 525: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

521: )
522: FROM HZ_ORIG_SYS_REFERENCES
523: WHERE OWNER_TABLE_ID = cm.duplicate_id
524: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
525: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
526: cm.customer_id,
527: CAST(MULTISET(
528: SELECT HZ_ORIG_SYS_REF_OBJ(
529: NULL,

Line 528: SELECT HZ_ORIG_SYS_REF_OBJ(

524: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
525: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
526: cm.customer_id,
527: CAST(MULTISET(
528: SELECT HZ_ORIG_SYS_REF_OBJ(
529: NULL,
530: ORIG_SYSTEM_REF_ID,
531: ORIG_SYSTEM,
532: ORIG_SYSTEM_REFERENCE,

Line 571: )AS HZ_ORIG_SYS_REF_OBJ_TBL)

567: )
568: FROM HZ_ORIG_SYS_REFERENCES
569: WHERE OWNER_TABLE_ID = cm.customer_id
570: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
571: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
572: )
573: FROM (SELECT distinct duplicate_address_id, customer_address_id,
574: duplicate_id, customer_id, org_id, customer_createsame
575: FROM ra_customer_merges cm

Line 588: SELECT HZ_ORIG_SYS_REF_OBJ(

584: cm.org_id,
585: get_operating_unit(cm.org_id),
586: cm.duplicate_site_id,
587: CAST(MULTISET(
588: SELECT HZ_ORIG_SYS_REF_OBJ(
589: NULL,
590: ORIG_SYSTEM_REF_ID,
591: ORIG_SYSTEM,
592: ORIG_SYSTEM_REFERENCE,

Line 631: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

627: )
628: FROM HZ_ORIG_SYS_REFERENCES
629: WHERE OWNER_TABLE_ID = cm.duplicate_site_id
630: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
631: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
632: cm.customer_site_id,
633: CAST(MULTISET(
634: SELECT HZ_ORIG_SYS_REF_OBJ(
635: NULL,

Line 634: SELECT HZ_ORIG_SYS_REF_OBJ(

630: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
631: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
632: cm.customer_site_id,
633: CAST(MULTISET(
634: SELECT HZ_ORIG_SYS_REF_OBJ(
635: NULL,
636: ORIG_SYSTEM_REF_ID,
637: ORIG_SYSTEM,
638: ORIG_SYSTEM_REFERENCE,

Line 677: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

673: )
674: FROM HZ_ORIG_SYS_REFERENCES
675: WHERE OWNER_TABLE_ID = cm.customer_site_id
676: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
677: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
678: cm.duplicate_address_id,
679: CAST(MULTISET(
680: SELECT HZ_ORIG_SYS_REF_OBJ(
681: NULL,

Line 680: SELECT HZ_ORIG_SYS_REF_OBJ(

676: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
677: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
678: cm.duplicate_address_id,
679: CAST(MULTISET(
680: SELECT HZ_ORIG_SYS_REF_OBJ(
681: NULL,
682: ORIG_SYSTEM_REF_ID,
683: ORIG_SYSTEM,
684: ORIG_SYSTEM_REFERENCE,

Line 723: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

719: )
720: FROM HZ_ORIG_SYS_REFERENCES
721: WHERE OWNER_TABLE_ID = cm.duplicate_address_id
722: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
723: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
724: cm.customer_address_id,
725: CAST(MULTISET(
726: SELECT HZ_ORIG_SYS_REF_OBJ(
727: NULL,

Line 726: SELECT HZ_ORIG_SYS_REF_OBJ(

722: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
723: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
724: cm.customer_address_id,
725: CAST(MULTISET(
726: SELECT HZ_ORIG_SYS_REF_OBJ(
727: NULL,
728: ORIG_SYSTEM_REF_ID,
729: ORIG_SYSTEM,
730: ORIG_SYSTEM_REFERENCE,

Line 769: )AS HZ_ORIG_SYS_REF_OBJ_TBL)

765: )
766: FROM HZ_ORIG_SYS_REFERENCES
767: WHERE OWNER_TABLE_ID = cm.customer_address_id
768: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
769: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
770: )
771: FROM ra_customer_merges cm
772: WHERE customer_merge_header_id = p_customer_merge_header_id;
773:

Line 782: HZ_ORIG_SYS_REF_OBJ_TBL(),

778: operation,
779: NULL,
780: NULL,
781: from_profile_id,
782: HZ_ORIG_SYS_REF_OBJ_TBL(),
783: to_profile_id,
784: HZ_ORIG_SYS_REF_OBJ_TBL(),
785: from_parent_id,
786: HZ_ORIG_SYS_REF_OBJ_TBL(),

Line 784: HZ_ORIG_SYS_REF_OBJ_TBL(),

780: NULL,
781: from_profile_id,
782: HZ_ORIG_SYS_REF_OBJ_TBL(),
783: to_profile_id,
784: HZ_ORIG_SYS_REF_OBJ_TBL(),
785: from_parent_id,
786: HZ_ORIG_SYS_REF_OBJ_TBL(),
787: to_parent_id,
788: HZ_ORIG_SYS_REF_OBJ_TBL()

Line 786: HZ_ORIG_SYS_REF_OBJ_TBL(),

782: HZ_ORIG_SYS_REF_OBJ_TBL(),
783: to_profile_id,
784: HZ_ORIG_SYS_REF_OBJ_TBL(),
785: from_parent_id,
786: HZ_ORIG_SYS_REF_OBJ_TBL(),
787: to_parent_id,
788: HZ_ORIG_SYS_REF_OBJ_TBL()
789: )
790: FROM (SELECT 'Merge' operation, cpf.cust_account_profile_id from_profile_id,

Line 788: HZ_ORIG_SYS_REF_OBJ_TBL()

784: HZ_ORIG_SYS_REF_OBJ_TBL(),
785: from_parent_id,
786: HZ_ORIG_SYS_REF_OBJ_TBL(),
787: to_parent_id,
788: HZ_ORIG_SYS_REF_OBJ_TBL()
789: )
790: FROM (SELECT 'Merge' operation, cpf.cust_account_profile_id from_profile_id,
791: cpt.cust_account_profile_id to_profile_id,
792: cmh.duplicate_id from_parent_id, cmh.customer_id to_parent_id

Line 825: HZ_ORIG_SYS_REF_OBJ_TBL(),

821: operation,
822: NULL,
823: NULL,
824: from_profile_amt_id,
825: HZ_ORIG_SYS_REF_OBJ_TBL(),
826: to_profile_amt_id,
827: HZ_ORIG_SYS_REF_OBJ_TBL(),
828: from_parent_id,
829: HZ_ORIG_SYS_REF_OBJ_TBL(),

Line 827: HZ_ORIG_SYS_REF_OBJ_TBL(),

823: NULL,
824: from_profile_amt_id,
825: HZ_ORIG_SYS_REF_OBJ_TBL(),
826: to_profile_amt_id,
827: HZ_ORIG_SYS_REF_OBJ_TBL(),
828: from_parent_id,
829: HZ_ORIG_SYS_REF_OBJ_TBL(),
830: to_parent_id,
831: HZ_ORIG_SYS_REF_OBJ_TBL()

Line 829: HZ_ORIG_SYS_REF_OBJ_TBL(),

825: HZ_ORIG_SYS_REF_OBJ_TBL(),
826: to_profile_amt_id,
827: HZ_ORIG_SYS_REF_OBJ_TBL(),
828: from_parent_id,
829: HZ_ORIG_SYS_REF_OBJ_TBL(),
830: to_parent_id,
831: HZ_ORIG_SYS_REF_OBJ_TBL()
832: )
833: FROM (SELECT 'Merge' operation, cpaf.cust_acct_profile_amt_id from_profile_amt_id,

Line 831: HZ_ORIG_SYS_REF_OBJ_TBL()

827: HZ_ORIG_SYS_REF_OBJ_TBL(),
828: from_parent_id,
829: HZ_ORIG_SYS_REF_OBJ_TBL(),
830: to_parent_id,
831: HZ_ORIG_SYS_REF_OBJ_TBL()
832: )
833: FROM (SELECT 'Merge' operation, cpaf.cust_acct_profile_amt_id from_profile_amt_id,
834: cpat.cust_acct_profile_amt_id to_profile_amt_id,
835: cmh.duplicate_id from_parent_id, cmh.customer_id to_parent_id

Line 869: HZ_ORIG_SYS_REF_OBJ_TBL(),

865: operation,
866: NULL,
867: NULL,
868: from_role_id,
869: HZ_ORIG_SYS_REF_OBJ_TBL(),
870: to_role_id,
871: HZ_ORIG_SYS_REF_OBJ_TBL(),
872: from_parent_id,
873: HZ_ORIG_SYS_REF_OBJ_TBL(),

Line 871: HZ_ORIG_SYS_REF_OBJ_TBL(),

867: NULL,
868: from_role_id,
869: HZ_ORIG_SYS_REF_OBJ_TBL(),
870: to_role_id,
871: HZ_ORIG_SYS_REF_OBJ_TBL(),
872: from_parent_id,
873: HZ_ORIG_SYS_REF_OBJ_TBL(),
874: to_parent_id,
875: HZ_ORIG_SYS_REF_OBJ_TBL()

Line 873: HZ_ORIG_SYS_REF_OBJ_TBL(),

869: HZ_ORIG_SYS_REF_OBJ_TBL(),
870: to_role_id,
871: HZ_ORIG_SYS_REF_OBJ_TBL(),
872: from_parent_id,
873: HZ_ORIG_SYS_REF_OBJ_TBL(),
874: to_parent_id,
875: HZ_ORIG_SYS_REF_OBJ_TBL()
876: )
877: FROM (SELECT DISTINCT carf.cust_account_role_id from_role_id,

Line 875: HZ_ORIG_SYS_REF_OBJ_TBL()

871: HZ_ORIG_SYS_REF_OBJ_TBL(),
872: from_parent_id,
873: HZ_ORIG_SYS_REF_OBJ_TBL(),
874: to_parent_id,
875: HZ_ORIG_SYS_REF_OBJ_TBL()
876: )
877: FROM (SELECT DISTINCT carf.cust_account_role_id from_role_id,
878: carf.cust_account_role_id to_role_id,
879: Nvl(carf.cust_acct_site_id,cm.duplicate_id) from_parent_id,

Line 900: HZ_ORIG_SYS_REF_OBJ_TBL(),

896: decode(crelt.created_by_module,'HZ_TCA_CUSTOMER_MERGE','Transfer','Merge'),
897: crelt.org_id,
898: get_operating_unit(crelt.org_id),
899: crelf.cust_acct_relate_id,
900: HZ_ORIG_SYS_REF_OBJ_TBL(),
901: crelt.cust_acct_relate_id,
902: HZ_ORIG_SYS_REF_OBJ_TBL(),
903: duplicate_id,
904: CAST(MULTISET(

Line 902: HZ_ORIG_SYS_REF_OBJ_TBL(),

898: get_operating_unit(crelt.org_id),
899: crelf.cust_acct_relate_id,
900: HZ_ORIG_SYS_REF_OBJ_TBL(),
901: crelt.cust_acct_relate_id,
902: HZ_ORIG_SYS_REF_OBJ_TBL(),
903: duplicate_id,
904: CAST(MULTISET(
905: SELECT HZ_ORIG_SYS_REF_OBJ(
906: NULL,

Line 905: SELECT HZ_ORIG_SYS_REF_OBJ(

901: crelt.cust_acct_relate_id,
902: HZ_ORIG_SYS_REF_OBJ_TBL(),
903: duplicate_id,
904: CAST(MULTISET(
905: SELECT HZ_ORIG_SYS_REF_OBJ(
906: NULL,
907: ORIG_SYSTEM_REF_ID,
908: ORIG_SYSTEM,
909: ORIG_SYSTEM_REFERENCE,

Line 948: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

944: )
945: FROM HZ_ORIG_SYS_REFERENCES
946: WHERE OWNER_TABLE_ID = duplicate_id
947: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
948: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
949: customer_id,
950: CAST(MULTISET(
951: SELECT HZ_ORIG_SYS_REF_OBJ(
952: NULL,

Line 951: SELECT HZ_ORIG_SYS_REF_OBJ(

947: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
948: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
949: customer_id,
950: CAST(MULTISET(
951: SELECT HZ_ORIG_SYS_REF_OBJ(
952: NULL,
953: ORIG_SYSTEM_REF_ID,
954: ORIG_SYSTEM,
955: ORIG_SYSTEM_REFERENCE,

Line 994: )AS HZ_ORIG_SYS_REF_OBJ_TBL)

990: )
991: FROM HZ_ORIG_SYS_REFERENCES
992: WHERE OWNER_TABLE_ID = customer_id
993: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
994: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
995: )
996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt
997: WHERE ((crelf.cust_account_id = duplicate_id
998: AND crelt.cust_account_id = customer_id

Line 1505: HZ_ORIG_SYS_REF_OBJ_TBL()),

1501: tp.party_id,
1502: tp.party_number,
1503: tp.party_name,
1504: tp.party_type,
1505: HZ_ORIG_SYS_REF_OBJ_TBL()),
1506: CAST(MULTISET(
1507: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(
1508: fp.party_id,
1509: fp.party_number,

Line 1512: HZ_ORIG_SYS_REF_OBJ_TBL())

1508: fp.party_id,
1509: fp.party_number,
1510: fp.party_name,
1511: fp.party_type,
1512: HZ_ORIG_SYS_REF_OBJ_TBL())
1513: FROM hz_parties fp, hz_merge_parties mp1
1514: WHERE mp1.batch_id = p_batch_id
1515: AND mp1.to_party_id = l_merge_to_party_id
1516: AND fp.party_id = mp1.from_party_id

Line 1538: SELECT HZ_ORIG_SYS_REF_OBJ(

1534: get_object_type(md.entity_name, mph.from_entity_id),
1535: mph.operation_type,
1536: mph.from_entity_id,
1537: CAST(MULTISET(
1538: SELECT HZ_ORIG_SYS_REF_OBJ(
1539: NULL,
1540: ORIG_SYSTEM_REF_ID,
1541: ORIG_SYSTEM,
1542: ORIG_SYSTEM_REFERENCE,

Line 1582: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

1578: FROM HZ_ORIG_SYS_REFERENCES
1579: WHERE OWNER_TABLE_ID = mph.from_entity_id
1580: AND OWNER_TABLE_NAME = md.entity_name
1581:
1582: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
1583:
1584: mph.to_entity_id,
1585:
1586: CAST(MULTISET(

Line 1587: SELECT HZ_ORIG_SYS_REF_OBJ(

1583:
1584: mph.to_entity_id,
1585:
1586: CAST(MULTISET(
1587: SELECT HZ_ORIG_SYS_REF_OBJ(
1588: NULL,
1589: ORIG_SYSTEM_REF_ID,
1590: ORIG_SYSTEM,
1591: ORIG_SYSTEM_REFERENCE,

Line 1631: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

1627: FROM HZ_ORIG_SYS_REFERENCES
1628: WHERE OWNER_TABLE_ID = decode(mph.operation_type,'Copy',mph.from_entity_id,mph.to_entity_id)
1629: AND OWNER_TABLE_NAME = md.entity_name
1630:
1631: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
1632:
1633: mph.from_parent_entity_id,
1634:
1635: CAST(MULTISET(

Line 1636: SELECT HZ_ORIG_SYS_REF_OBJ(

1632:
1633: mph.from_parent_entity_id,
1634:
1635: CAST(MULTISET(
1636: SELECT HZ_ORIG_SYS_REF_OBJ(
1637: NULL,
1638: ORIG_SYSTEM_REF_ID,
1639: ORIG_SYSTEM,
1640: ORIG_SYSTEM_REFERENCE,

Line 1680: )AS HZ_ORIG_SYS_REF_OBJ_TBL),

1676: FROM HZ_ORIG_SYS_REFERENCES
1677: WHERE OWNER_TABLE_ID = mph.from_parent_entity_id
1678: AND OWNER_TABLE_NAME = md.parent_entity_name
1679:
1680: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
1681:
1682: mph.to_parent_entity_id,
1683:
1684:

Line 1686: SELECT HZ_ORIG_SYS_REF_OBJ(

1682: mph.to_parent_entity_id,
1683:
1684:
1685: CAST(MULTISET(
1686: SELECT HZ_ORIG_SYS_REF_OBJ(
1687: NULL,
1688: ORIG_SYSTEM_REF_ID,
1689: ORIG_SYSTEM,
1690: ORIG_SYSTEM_REFERENCE,

Line 1730: )AS HZ_ORIG_SYS_REF_OBJ_TBL)

1726: FROM HZ_ORIG_SYS_REFERENCES
1727: WHERE OWNER_TABLE_ID = mph.to_parent_entity_id
1728: AND OWNER_TABLE_NAME = md.parent_entity_name
1729:
1730: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
1731:
1732: )
1733: FROM hz_merge_parties mp2,
1734: hz_merge_party_history mph,