GP_PKG_NONVER_V

(SQL View)
 Index Back

Package Defn-Non-Version based

This view is used to select packages that are non-version based.

SELECT GP_PKG_ID , DESCR FROM PS_GP_PKG_DFN WHERE (GP_VERSION_IND='N'AND PKG_IMPORT_DTTM IS NULL) OR (GP_VERSION_IND='N' AND PKG_IMPORT_DTTM IS NOT NULL AND PKG_UPGRADE_DTTM IS NOT NULL)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description