[Home] [Help]
View: FF_FUNCTION_PARAMETERS_V
View Text
SELECT FFP.ROWID
, FUNCTION_ID
, SEQUENCE_NUMBER
, CLASS
, FL1.MEANING
, CONTINUING_PARAMETER
, DATA_TYPE
, FL2.MEANING
, NAME
, OPTIONAL
, FFP.CREATED_BY
, FFP.CREATION_DATE
, FFP.LAST_UPDATED_BY
, FFP.LAST_UPDATE_DATE
, FFP.LAST_UPDATE_LOGIN
FROM FF_FUNCTION_PARAMETERS FFP
, FF_LOOKUPS FL1
, FF_LOOKUPS FL2
WHERE (FL1.LOOKUP_CODE = FFP.CLASS
AND FL1.LOOKUP_TYPE = 'PARAMETER_CLASS')
AND (FL2.LOOKUP_CODE = FFP.DATA_TYPE
AND FL2.LOOKUP_TYPE = 'DATA_TYPE')
Columns
Name |
ROW_ID |
FUNCTION_ID |
SEQUENCE_NUMBER |
CLASS_CODE |
CLASS |
CONTINUING_PARAMETER |
DATA_TYPE_CODE |
DATA_TYPE |
NAME |
OPTIONAL |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |