IEX_F_PARTIES_V
Details
-
Schema: FUSION
-
Object owner: IEX
-
Object type: VIEW
Columns
Name |
---|
PARTY_ID |
Query
SQL_Statement |
---|
SELECT DISTINCT PARTY_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')) |