Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
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