GP_ELN_AT_VW

(SQL View)
 Index Back

Mobile Epay

Mobile Epay

SELECT E.COUNTRY ,E.GP_ELN_SET ,E.EFFDT ,E.PIN_ELEM_GRP_NUM ,E.PIN_NUM ,D.PIN_TYPE ,E.GP_ELN_ATTR1 ,E.GP_ELN_ATTR2 ,E.GP_ELN_ATTR3 ,E.GP_ELN_ATTR4 ,E.GP_ELN_ATTR5 ,E.GP_ELN_ATTR6 ,E.GP_ELN_ATTR7 ,E.GP_ELN_ATTR8 ,E.GP_ELN_ATTR9 ,E.GP_ELN_ATTR10 , F.GP_ELN_CODE FROM PS_GP_ELN_SET A , PS_GP_ELN_SET_LST B ,PS_GP_ELEM_GRP_MBR C , PS_GP_ELN_PIN_ATTR E , PS_GP_PIN D , PS_GP_SUMM_PG_DSP F WHERE A.COUNTRY=F.COUNTRY AND B.GP_ELN_ATTR1=%Upper(F.DESCR) AND A.COUNTRY=B.COUNTRY AND A.GP_ELN_SET=B.GP_ELN_SET AND B.EFFDT=( SELECT MAX(CH.EFFDT) FROM PS_GP_ELN_SET_LST CH WHERE CH.COUNTRY=B.COUNTRY AND CH.GP_ELN_SET=B.GP_ELN_SET AND CH.EFFDT <=%CurrentDateIn) AND B.PIN_ELEM_GRP_NUM=C.PIN_NUM AND C.EFFDT=( SELECT MAX(A2.EFFDT) FROM PS_GP_ELEM_GRP A2 WHERE A2.PIN_NUM=C.PIN_NUM AND A2.EFFDT<=%CurrentDateIn) AND E.COUNTRY=B.COUNTRY AND E.GP_ELN_SET=B.GP_ELN_SET AND E.EFFDT=B.EFFDT AND E.PIN_ELEM_GRP_NUM=B.PIN_ELEM_GRP_NUM AND E.PIN_NUM=C.PIN_ELEM_NUM AND C.PIN_ELEM_NUM=D.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY

2 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group
5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
7 GP_ELN_ATTR1 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
8 GP_ELN_ATTR2 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
9 GP_ELN_ATTR3 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
10 GP_ELN_ATTR4 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
11 GP_ELN_ATTR5 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
12 GP_ELN_ATTR6 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
13 GP_ELN_ATTR7 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
14 GP_ELN_ATTR8 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
15 GP_ELN_ATTR9 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
16 GP_ELN_ATTR10 Character(20) VARCHAR2(20) NOT NULL ELN Attribute
17 GP_ELN_LST_ATTR1 Character(20) VARCHAR2(20) NOT NULL ELN Attribute