VIEW: APPS.FND_FLEXBUILDER_PARAMS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')