GPBR_CNP_VW_LNG

(SQL View)
 Index Back

View for CNPJ Rel Lng

Related Language View for CNPJ from Establishment.

SELECT DISTINCT B.COMPANY , A.ESTAB_ID_BRA , E.LANGUAGE_CD , E.DESCR FROM PS_ESTAB_ID_BRA A , PS_ESTAB_TBL B , PS_ESTAB_TBL_LANG E WHERE A.COUNTRY='BRA' AND A.ESTAB_ID_TYPE_BRA='CNPJ' AND B.ESTABID=A.ESTABID AND B.COUNTRY=A.COUNTRY AND A.EFFDT=( SELECT MAX(C.EFFDT) FROM PS_ESTAB_ID_BRA C WHERE C.ESTABID=A.ESTABID AND C.COUNTRY=A.COUNTRY AND C.ESTAB_ID_TYPE_BRA=A.ESTAB_ID_TYPE_BRA) AND B.EFFDT=( SELECT MAX(D.EFFDT) FROM PS_ESTAB_TBL D WHERE D.ESTABID=B.ESTABID) AND B.COMPANY= COMPANY AND E.ESTABID=B.ESTABID AND E.EFFDT = B.EFFDT

  • Related Language Record for GPBR_AU_CNPJ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description