TCA ORIG_SYSTEM
Where do we find the Original System Identifier for the Party Site, Original System Identifier for the location., Original System Identifier for the party relationship, Original System Identifier for the party site use, Original System Identifier for the customer account ????
Like using the below query I was able to find it for the party
FROM hz_parties hp, hz_orig_sys_references hosr
WHERE hosr.owner_table_name = 'HZ_PARTIES'
AND hosr.owner_table_id = hp.party_id
AND hp.party_id = xxxx
Thanks,
Ram