[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 |