GP_PKG_AR_VW(SQL View) |
Index Back |
---|---|
Retrieves pkgs for ArgentinaRetrieves pkgs for Argentina |
SELECT A.GP_PKG_ID , A.DESCR FROM PS_GP_PKG_DFN A , PS_GP_PKG_CRIT_VER B WHERE A.GP_PKG_ID = B.GP_PKG_ID AND B.COUNTRY = 'ARG' |
# | 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
Prompt Table: GP_PKG_AR_VW |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |