1. Tables and Views for Common Features
  2. FND_FLEX_VALIDATION_QUALIFIERS

FND_FLEX_VALIDATION_QUALIFIERS

Details

  • Schema: EBS

  • Object owner: FND

  • Object type: VIEW

Columns

Name

FLEX_VALUE_SET_ID

ID_FLEX_APPLICATION_ID

ID_FLEX_CODE

SEGMENT_ATTRIBUTE_TYPE

VALUE_ATTRIBUTE_TYPE

ASSIGNMENT_DATE

Query

SQL_Statement

SELECT

B.VALUE_SET_ID FLEX_VALUE_SET_ID,

B.APPLICATION_ID ID_FLEX_APPLICATION_ID,

B.KEY_FLEXFIELD_CODE ID_FLEX_CODE,

B.SEGMENT_LABEL_CODE SEGMENT_ATTRIBUTE_TYPE,

B.VALUE_ATTRIBUTE_CODE VALUE_ATTRIBUTE_TYPE,

FND_FLEX_BACK_UTILS.ORDERED_ASSIGNMENT_DATE(B.VALUE_TABLE_COLUMN_NAME) ASSIGNMENT_DATE

FROM FND_VS_KF_VALUE_ATTRS B,

FND_VS_VALUE_SETS VS

WHERE VS.VALUE_SET_ID = B.VALUE_SET_ID