GPFR_AF_ALLV_VW

(SQL View)
 Index Back

AF Object Versions

View to show GPFR_AF_VERSIONs for all Application Framework objects.

SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_DATA_TYPES WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_DT_VALUES WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_APPL WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_PRMTMPT WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_APSERTY WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_NODSET WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_SQLENTY WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_DON_REC WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_DON_SQL WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_NODE WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_ATTR WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_ATR_DON WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_NDSET_N WHERE GPFR_AF_VERSION <> ' ' UNION SELECT DISTINCT GPFR_AF_VERSION FROM PS_GPFR_AF_MAP_REC WHERE GPFR_AF_VERSION <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.