Receivables - EBS (MOSC)

MOSC Banner

TCA ORIG_SYSTEM

edited Jun 1, 2017 4:16PM in Receivables - EBS (MOSC) 5 commentsAnswered

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

SELECT hosr.ORIG_SYSTEM, hosr.ORIG_SYSTEM_REFERENCE

  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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center