LM_CAT_TYPELM_CAT_TYPE_VW(SQL View) |
Index Back |
|---|---|
Content Type ViewContent Type View |
| SELECT LM_CAT_TYPE , LM_DESCR90 FROM PS_LM_CAT_TYPES WHERE LM_CAT_TYPE IN ( SELECT B.LM_CAT_TYPE FROM PS_LM_JP_TYPES A , PS_LM_JP_SECTION B WHERE A.LM_JP_TYPE = B.LM_JP_TYPE AND A.LM_PROFILE_USAGE ='J') AND LM_CAT_TYPE IN ( SELECT B.LM_CAT_TYPE FROM PS_LM_JP_TYPES A , PS_LM_JP_SECTION B WHERE A.LM_JP_TYPE = B.LM_JP_TYPE AND A.LM_PROFILE_USAGE ='P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Category Type |
| 2 | LM_DESCR90 | Character(100) | VARCHAR2(100) NOT NULL | Description |