[Home] [Help]
View: PSP_AUTO_PARAMS_V
View Text
SELECT A.ROWID ROW_ID
, A.ACCT_ID
, A.PARAM_LINE_NUM
, A.LOOKUP_ID
, B.PARAMETER_CLASS
, B.PARAMETER
, B.DATATYPE
, B.VALIDATION_TYPE
, A.OPERAND
, A.USER_VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSP_AUTO_PARAMS A
, PSP_AUTO_LOOKUPS B
WHERE A.LOOKUP_ID = B.LOOKUP_ID
Columns
| Name |
| ROW_ID |
| ACCT_ID |
| PARAM_LINE_NUM |
| LOOKUP_ID |
| PARAMETER_CLASS |
| PARAMETER |
| DATATYPE |
| VALIDATION_TYPE |
| OPERAND |
| USER_VALUE |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| CREATED_BY |
| CREATION_DATE |