IEX_F_ACCOUNTS_V

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name
CUST_ACCOUNT_ID

Query

SQL_Statement
SELECT DISTINCT CUST_ACCOUNT_ID FROM IEX_DELINQUENCIES WHERE STATUS <> 'CURRENT'AND NOT EXISTS (SELECT * FROM IEX_CUST_BANKRUPTCIES WHERE IEX_DELINQUENCIES.PARTY_ID = IEX_CUST_BANKRUPTCIES.PARTY_ID and IEX_CUST_BANKRUPTCIES.LAST_DISPOSITION_CODE in ('IEX_BANKRUPTCY_REQU_APPROVED', 'IEX_BANKRUPTCY_WITH_PENDING', 'IEX_BANKRUPTCY_WITH_REJECTED'))