1. Tables and Views for Common Features
  2. FND_VS_KF_VALUE_ATTRS

FND_VS_KF_VALUE_ATTRS

Details

  • Schema: VST

  • Object owner: FND

  • Object type: VIEW

Columns

Name

VALUE_SET_ID

VALUE_SET_CODE

APPLICATION_ID

KEY_FLEXFIELD_CODE

SEGMENT_LABEL_CODE

VALUE_ATTRIBUTE_CODE

VALUE_TABLE_COLUMN_NAME

LOOKUP_TYPE

REQUIRED_FLAG

DEFAULT_VALUE

NAME

DESCRIPTION

Query

SQL_Statement

SELECT distinct

vvs.value_set_id,

vvs.value_set_code,

kva.application_id,

kva.key_flexfield_code,

kva.segment_label_code,

kva.value_attribute_code,

kva.value_table_column_name,

kva.lookup_type,

kva.required_flag,

kva.default_value,

kva.name,

kva.description

FROM fnd_vs_value_sets vvs,

fnd_kf_segment_instances ksgi,

fnd_kf_str_instances_b ksti,

fnd_kf_structures_b kst,

fnd_kf_segments_b ksg,

(

select kls2.structure_id, kls2.segment_code, kls2.segment_label_code

from fnd_kf_labeled_segments kls2

union

select ksg2.structure_id, ksg2.segment_code, ksl2.segment_label_code

from fnd_kf_structures_b kst2,

fnd_kf_segments_b ksg2,

fnd_kf_segment_labels_b ksl2

where ksg2.structure_id = kst2.structure_id

and kst2.application_id = ksl2.application_id

and kst2.key_flexfield_code = ksl2.key_flexfield_code

and ksl2.global_flag = 'Y'

) kls,

fnd_kf_segment_labels_b ksl,

fnd_kf_value_attrs_vl kva,

fnd_kf_flexfields_b kf

WHERE vvs.validation_type in ('INDEP', 'DEP', 'TABLE', 'SUBSET')

and ksgi.value_set_id = vvs.value_set_id

and ksti.structure_instance_id = ksgi.structure_instance_id

and kst.application_id = ksti.application_id

and kst.key_flexfield_code = ksti.key_flexfield_code

and kst.structure_id = ksti.structure_id

and kf.application_id = kst.application_id

and kf.key_flexfield_code = kst.key_flexfield_code

and ksg.structure_id = kst.structure_id

and ksg.segment_code = ksgi.segment_code

and kls.structure_id = ksg.structure_id

and kls.segment_code = ksg.segment_code

and ksl.application_id = kf.application_id

and ksl.key_flexfield_code = kf.key_flexfield_code

and ksl.segment_label_code = kls.segment_label_code

and kva.application_id = ksl.application_id

and kva.key_flexfield_code = ksl.key_flexfield_code

and kva.segment_label_code = ksl.segment_label_code