BI_PND_INTFC_VW

(SQL View)
 Index Back

Eligible Interfaces for Delete

Eligible Interfaces for Delete

SELECT INTFC_ID , BI_COUNT , GROSS_EXTENDED_AMT , BI_CURRENCY_CD FROM PS_BI_INTFC_CRR_VW A WHERE NOT EXISTS( SELECT 'X' FROM PS_BI_INTFC_CRR_VW B WHERE A.INTFC_ID = B.INTFC_ID GROUP BY intfc_id HAVING COUNT(bi_currency_cd) > 1) UNION SELECT INTFC_ID , SUM(BI_COUNT) , 0 , ' ' FROM PS_BI_INTFC_CRR_VW A WHERE EXISTS( SELECT 'X' FROM PS_BI_INTFC_CRR_VW B WHERE A.INTFC_ID = B.INTFC_ID GROUP BY intfc_id HAVING COUNT(bi_currency_cd) > 1) GROUP BY INTFC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
2 BI_COUNT Number(9,0) DECIMAL(9) NOT NULL BILLING COUNT
3 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
4 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code