SCC_ACTVTRNS_VW

(SQL View)
 Index Back

All Active Transactions

This VIEW is comprised of all 'Active' Transactions.

SELECT A.SCC_TRANSAC_CD FROM PS_SCC_TRNSAC_DTLS A WHERE A.SCC_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction