EOEW_OBJ_OWNEREOEW_TRN_OBJLANGUAGE_CDEOEW_TRNDFVWLNG(SQL View) |
Index Back |
|---|---|
Rel. Lng for EOEW_TRN_DFN_VWRel. Lng for EOEW_TRN_DFN_VW |
| SELECT B.EOEW_OBJ_OWNER , A.EOEW_TRN_OBJ , C.LANGUAGE_CD , C.DESCR FROM PS_EOEW_TRN_DFN A , PS_EOEW_OBJOWN_VW B , PS_EOEW_TRN_DFNLNG C WHERE A.EOEW_OBJ_OWNER = B.EOEW_OBJ2_OWNER AND A.EOEW_TRN_OBJ = C.EOEW_TRN_OBJ AND A.EOEW_TRN_TYP <> '01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_OBJ_OWNER |
Character(15) | VARCHAR2(15) NOT NULL | Subject Area |
| 2 | EOEW_TRN_OBJ |
Character(50) | VARCHAR2(50) NOT NULL | Transformation Object |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |