PTBR_CSSPTN_LVW(SQL View) |
Index Back |
---|---|
Theme CSS Pattern Prompt - Lan |
SELECT DISTINCT A.CONTNAME , B.LANGUAGE_CD , B.DESCR FROM %Table(PSCONTDEFN) A , %Table(PSCONTDEFNLANG) B WHERE A.CONTNAME = B.CONTNAME AND A.ALTCONTNUM = B.ALTCONTNUM AND A.CONTTYPE = 4 AND A.CONTNAME LIKE 'PTBR_CSSPTN_%' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CONTNAME | Character(30) | VARCHAR2(30) NOT NULL | Content Name |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |