GP_NR_PKG_EXP_V (SQL View)	Index Back
NR Package Export View This view selects only those packages that have been created (PKG_CREATE_DTTM is not NULL). This ensures that the user does not try to export a package that has not yet been created.

GP_NR_PKG_EXP_V

(SQL View)

NR Package Export View

This view selects only those packages that have been created (PKG_CREATE_DTTM is not NULL). This ensures that the user does not try to export a package that has not yet been created.

SELECT GP_PKG_ID , DESCR FROM PS_GP_NR_PKG_DFN WHERE PKG_CREATE_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

#	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