GPFR_DSN_CMP_VW

(SQL View)
 Index Back

DSN Company List

DSN Company list view

SELECT A.COMPANY , A.DESCR FROM PS_COMPANY_TBL A WHERE A.COUNTRY='FRA' AND A.EFF_STATUS ='A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_COMPANY_TBL A1 WHERE A1.COMPANY=A.COMPANY AND A1.EFFDT<=%CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PS_GPFR_DSN_CIESTB B WHERE B.COMPANY=A.COMPANY)

  • Related Language Record: GPFR_DSNCMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description