AM_WC_INTPN3_VW

(SQL View)
Index Back

Interface Fin Summary View


SELECT A.BUSINESS_UNIT , COUNT(*) FROM PS_AM_WC_INTPN2_VW A WHERE A.LOAD_STATUS = 'NEW' GROUP BY A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

2 TOTAL_ROWS_CNT Number(13,0) DECIMAL(13) NOT NULL Total Rows Pending