SCC_LOV_UIDSCC_RULE_LOV_VW(SQL View) |
Index Back |
|---|---|
LOV Name ViewThis view is used to search for LOV values to be used in the rules engine. |
| SELECT A.SCC_LOV_UID , A.DESCR FROM PS_SCC_SL_LOV_HDR A , PS_SCC_INSTALL_RE B WHERE A.SCC_SL_LOV_CONTEXT = B.SCC_SL_LOV_CONTEXT AND A.SCC_LOV_TYPE = '01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_LOV_UID |
Character(40) | VARCHAR2(40) NOT NULL | LOV Unique ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |