GPBR_ES_CMP_LNG(SQL View) |
Index Back |
---|---|
eSocail Company HQ VieweSocail Company HQ View LANG |
SELECT a.company , c.language_cd , a.descr FROM ps_estab_tbl a , PS_ESTAB_TBL_BRA b , ps_estab_tbl_lang c WHERE a.country = 'BRA' AND a.HQUNIT = 'Y' AND b.OTHER_SECTORS_BRA = '2' AND a.effdt = ( SELECT MAX(effdt) FROM ps_estab_tbl WHERE estabid = a.estabid AND country = a.country AND effdt <= %CurrentDateIn) AND b.estabid = a.estabid AND b.effdt = a.effdt AND a.estabid = c.estabid AND a.effdt = c.effdt |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |