ORIG_SYSTEM_REFERENCE in TCA Party in Oracle Applications

When you are importing Supplier or Customer data from 3rd party system original system reference will be saved in another table other than HZ Parties tables.

SELECT ORIG_SYSTEM, ORIG_SYSTEM_REFERENCE, OWNER_TABLE_NAME, REASON_CODE
  FROM APPS.HZ_ORIG_SYS_REFERENCES
 WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
   AND ORIG_SYSTEM = ''
   AND OWNER_TABLE_ID = '';


ORIG_SYSTEM_REFERENCE = OLD Party Number in LEGACY System

ORIG_SYSTEM = LEGACY

OWNER_TABLE_ID = Party ID in EBS


OWNER_TABLE_NAME = HZ_PARTIES


EX Query:

  SELECT ORIG_SYSTEM, a.ORIG_SYSTEM_REFERENCE, OWNER_TABLE_NAME, REASON_CODE,OWNER_TABLE_ID, hp.party_name, hp.ORIG_SYSTEM_REFERENCE
  FROM APPS.HZ_ORIG_SYS_REFERENCES a, apps.hz_parties hp
 WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
   AND ORIG_SYSTEM = nvl(:P_ORIG_SYSTEM, ORIG_SYSTEM)
   AND OWNER_TABLE_ID = NVL(:P_PARTY_ID, OWNER_TABLE_ID)

   and hp.party_id = a.OWNER_TABLE_ID