Product: | FND - Application Object Library |
---|---|
Description: | View of FND_FLEXBUILDER_PARAMETERS and FND_FLEXBUILDER_PARAMS_TL |
Implementation/DBA Data: | APPS.FND_FLEXBUILDER_PARAMS_VL |
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')