OPRIDACV_NDTPL_IDLANGUAGE_CDAVN_OPR_TPL_LVW(SQL View) |
Index Back |
|---|
| SELECT O.OPRID , T.ACV_NDTPL_ID , TL.LANGUAGE_CD , TL.AR_DESCR , T.ACV_NDTPL_ID %Concat '-' %Concat TL.AR_DESCR FROM PSOPRDEFN O , PS_AVN_NODE_TEMPL T , PS_AVN_ND_TMPL_LNG TL WHERE (T.ACV_NDTPL_LEVEL IN ('A', 'S') OR (T.ACV_NDTPL_LEVEL = 'U' AND T.ACV_NDTPL_LVL_VAL = O.OPRID) OR (T.ACV_NDTPL_LEVEL = 'R' AND T.ACV_NDTPL_LVL_VAL IN ( SELECT R.ROLENAME FROM PSROLEUSER R WHERE R.ROLEUSER = O.OPRID)) AND T.ACTIVE_FLG = 'Y') AND T.ACV_NDTPL_ID = TL.ACV_NDTPL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ACV_NDTPL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node Template ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | AR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |