FND_SEGMENT_ATTRIBUTE_TYPES

Details

  • Schema: EBS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

APPLICATION_ID

ID_FLEX_CODE

SEGMENT_ATTRIBUTE_TYPE

GLOBAL_FLAG

REQUIRED_FLAG

UNIQUE_FLAG

SEGMENT_PROMPT

DESCRIPTION

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.APPLICATION_ID APPLICATION_ID,

B.KEY_FLEXFIELD_CODE ID_FLEX_CODE,

B.SEGMENT_LABEL_CODE SEGMENT_ATTRIBUTE_TYPE,

B.GLOBAL_FLAG GLOBAL_FLAG,

B.REQUIRED_FLAG REQUIRED_FLAG,

B.UNIQUE_FLAG UNIQUE_FLAG,

B.NAME SEGMENT_PROMPT,

B.DESCRIPTION DESCRIPTION,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM FND_KF_SEGMENT_LABELS_VL B