GPSC_ELM_VER_VW

(SQL View)
 Index Back

GP Version Prompt View

Element Browser Version Prompt View

SELECT A.COUNTRY , A.GP_VERSION FROM PS_GP_PIN A WHERE A.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ABS_ENTL C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ABS_TAKE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ACCUMULATOR C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ARRAY C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_AUTOGEN_DFLT C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_BRACKET C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_COUNT C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_DATE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_DURATION C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ELEM_GRP C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ERN_DED C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_FC_TBL C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_FORMULA C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_GCTL C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_HIST_RULE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_PIN_CMPNT C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_PROCESS C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_PRORATION C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_RATE_CODE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_ROUND_RULE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_SECTION C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_SYSTEM_PIN C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_VARIABLE C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' ' UNION SELECT B.COUNTRY , C.GP_VERSION FROM PS_GP_WA_ARRAY C , PS_GP_VER_PIN_VW B WHERE C.PIN_NUM=B.PIN_NUM AND C.GP_VERSION <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.