Accounting Rejection is designed to extract data from ESTAR.ESTAR_EVENT_REJECTION and ESTAR.ESTAR_REJECTED_MESSAGE tables.
FROM ESTAR.ESTAR_EVENT_REJECTION
inner join ESTAR.ESTAR_REJECTED_MESSAGE on ESTAR.ESTAR_EVENT_REJECTION.REJECTION_INSTANCE = ESTAR.ESTAR_REJECTED_MESSAGE.REJECTION_INSTANCE
left outer join RULESDBO.ENTITY on ESTAR.ESTAR_EVENT_REJECTION.PORTFOLIO_ACCT = RULESDBO.ENTITY.ENTITY_ID
left outer join SECURITYDBO.SECURITY_MASTER on ESTAR.ESTAR_EVENT_REJECTION.ASSET_ID = SECURITYDBO.SECURITY_MASTER.SECURITY_ALIAS
left outer join PACE_MASTERDBO.INTERFACES on ESTAR.ESTAR_EVENT_REJECTION.SRC_INTFC_INST = PACE_MASTERDBO.INTERFACES.INSTANCE
left outer join MSGCENTER_DBO.MSG_STREAMS MSG_STREAMS ON MSG_STREAMS.msg_stream_id = ESTAR.ESTAR_EVENT_REJECTION.STREAM_ID
inner join ESTAR.DM_LEDGER_ACCT_BALANCES TMP_HELD_SECURITY on TMP_HELD_SECURITY.SECURITY_ALIAS = ESTAR.ESTAR_EVENT_REJECTION.ASSET_ID
inner join ESTAR.TEMP_RESOLVE_COMPOSITE part_ent on part_ent.ENTITY_ID = ESTAR.ESTAR_EVENT_REJECTION.PORTFOLIO_ACCT