[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 |
APPS.FF_FUNCTION_PARAMETERS_V