IEX_F_BILLTO_V

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name
CUSTOMER_SITE_USE_ID

Query

SQL_Statement
SELECT DISTINCT CUSTOMER_SITE_USE_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'))