FND_ID_FLEX_SEGMENTS_VL

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME SEGMENT_NAME SEGMENT_NUM ENABLED_FLAG REQUIRED_FLAG FLEX_VALUE_SET_ID SECURITY_ENABLED_FLAG RANGE_CODE DEFAULT_TYPE DEFAULT_VALUE DISPLAY_FLAG DISPLAY_SIZE MAXIMUM_DESCRIPTION_LEN CONCATENATION_DESCRIPTION_LEN RUNTIME_PROPERTY_FUNCTION ADDITIONAL_WHERE_CLAUSE APPLICATION_COLUMN_INDEX_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN FORM_LEFT_PROMPT FORM_ABOVE_PROMPT DESCRIPTION

Query

SQL_Statement

SELECT B.ROW_ID ROW_ID, B.APPLICATION_ID, B.ID_FLEX_CODE, B.ID_FLEX_NUM, B.APPLICATION_COLUMN_NAME, B.SEGMENT_NAME, B.SEGMENT_NUM, B.ENABLED_FLAG, B.REQUIRED_FLAG, B.FLEX_VALUE_SET_ID, B.SECURITY_ENABLED_FLAG, B.RANGE_CODE, B.DEFAULT_TYPE, B.DEFAULT_VALUE, B.DISPLAY_FLAG, B.DISPLAY_SIZE, B.MAXIMUM_DESCRIPTION_LEN, B.CONCATENATION_DESCRIPTION_LEN, B.RUNTIME_PROPERTY_FUNCTION, B.ADDITIONAL_WHERE_CLAUSE, B.APPLICATION_COLUMN_INDEX_FLAG, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.FORM_LEFT_PROMPT, T.FORM_ABOVE_PROMPT, T.DESCRIPTION FROM FND_ID_FLEX_SEGMENTS B, FND_ID_FLEX_SEGMENTS_TL T WHERE B.APPLICATION_ID = T.APPLICATION_ID AND B.ID_FLEX_CODE = T.ID_FLEX_CODE AND B.ID_FLEX_NUM = T.ID_FLEX_NUM AND B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME AND T.LANGUAGE = USERENV('LANG')