FND Design Data [Home] [Help]

View: FND_FLEXBUILDER_PARAMS_VL

Product: FND - Application Object Library
Description: View of FND_FLEXBUILDER_PARAMETERS and FND_FLEXBUILDER_PARAMS_TL
Implementation/DBA Data: ViewAPPS.FND_FLEXBUILDER_PARAMS_VL
View Text

SELECT B.ROWID
, B.FLEXFIELD_APPLICATION_ID
, B.FLEX_VALUE_SET_ID
, B.ASSIGNMENT_VALUE_SET_ID
, B.VALUE_SET_MATCH_REQUIRED_FLAG
, B.ID_FLEX_CODE
, B.ID_FLEX_NUM
, B.ID_PARAMETER
, B.OUTPUT_COLUMN
, B.SOURCE_PARAMETER
, B.APPLICATION_ID
, B.FUNCTION_CODE
, B.SEQUENCE
, B.PARAMETER_NAME
, T.USER_PARAMETER_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ASSIGNMENT_TYPE
, B.PARAMETER_TYPE
, B.PROTECTED_FLAG
, B.DESCRIPTION
, B.APPLICATION_COLUMN_NAME
, B.SEGMENT_ATTRIBUTE_TYPE
, B.CONDITIONAL_PARAMETER
, B.CONDITIONAL_VALUE
, B.CONSTANT_VALUE
FROM FND_FLEXBUILDER_PARAMETERS B
, FND_FLEXBUILDER_PARAMS_TL T
WHERE T.APPLICATION_ID = B.APPLICATION_ID
AND T.FUNCTION_CODE = B.FUNCTION_CODE
AND T.SEQUENCE = B.SEQUENCE
AND T.PARAMETER_NAME = B.PARAMETER_NAME
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
FLEXFIELD_APPLICATION_ID
FLEX_VALUE_SET_ID
ASSIGNMENT_VALUE_SET_ID
VALUE_SET_MATCH_REQUIRED_FLAG
ID_FLEX_CODE
ID_FLEX_NUM
ID_PARAMETER
OUTPUT_COLUMN
SOURCE_PARAMETER
APPLICATION_ID
FUNCTION_CODE
SEQUENCE
PARAMETER_NAME
USER_PARAMETER_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ASSIGNMENT_TYPE
PARAMETER_TYPE
PROTECTED_FLAG
DESCRIPTION
APPLICATION_COLUMN_NAME
SEGMENT_ATTRIBUTE_TYPE
CONDITIONAL_PARAMETER
CONDITIONAL_VALUE
CONSTANT_VALUE