APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ORIG_SYS_REFERENCES

Line 430: FROM HZ_ORIG_SYS_REFERENCES

426: ATTRIBUTE18,
427: ATTRIBUTE19,
428: ATTRIBUTE20
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,

Line 476: FROM HZ_ORIG_SYS_REFERENCES

472: ATTRIBUTE18,
473: ATTRIBUTE19,
474: ATTRIBUTE20
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,

Line 522: FROM HZ_ORIG_SYS_REFERENCES

518: ATTRIBUTE18,
519: ATTRIBUTE19,
520: ATTRIBUTE20
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,

Line 568: FROM HZ_ORIG_SYS_REFERENCES

564: ATTRIBUTE18,
565: ATTRIBUTE19,
566: ATTRIBUTE20
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: )

Line 628: FROM HZ_ORIG_SYS_REFERENCES

624: ATTRIBUTE18,
625: ATTRIBUTE19,
626: ATTRIBUTE20
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,

Line 674: FROM HZ_ORIG_SYS_REFERENCES

670: ATTRIBUTE18,
671: ATTRIBUTE19,
672: ATTRIBUTE20
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,

Line 720: FROM HZ_ORIG_SYS_REFERENCES

716: ATTRIBUTE18,
717: ATTRIBUTE19,
718: ATTRIBUTE20
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,

Line 766: FROM HZ_ORIG_SYS_REFERENCES

762: ATTRIBUTE18,
763: ATTRIBUTE19,
764: ATTRIBUTE20
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: )

Line 945: FROM HZ_ORIG_SYS_REFERENCES

941: ATTRIBUTE18,
942: ATTRIBUTE19,
943: ATTRIBUTE20
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,

Line 991: FROM HZ_ORIG_SYS_REFERENCES

987: ATTRIBUTE18,
988: ATTRIBUTE19,
989: ATTRIBUTE20
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: )

Line 1578: FROM HZ_ORIG_SYS_REFERENCES

1574: ATTRIBUTE18,
1575: ATTRIBUTE19,
1576: ATTRIBUTE20
1577: )
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),

Line 1627: FROM HZ_ORIG_SYS_REFERENCES

1623: ATTRIBUTE18,
1624: ATTRIBUTE19,
1625: ATTRIBUTE20
1626: )
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),

Line 1676: FROM HZ_ORIG_SYS_REFERENCES

1672: ATTRIBUTE18,
1673: ATTRIBUTE19,
1674: ATTRIBUTE20
1675: )
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),

Line 1726: FROM HZ_ORIG_SYS_REFERENCES

1722: ATTRIBUTE18,
1723: ATTRIBUTE19,
1724: ATTRIBUTE20
1725: )
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)