弹性域是一种可自定义的字段,通过弹性域,可以订制Oracle应用产品,使之适合企业自身业务环境。
说明性弹性域用于收集Oracle应用产品必须信息之外的关于业务实体的附加信息。
Example: 物料说明性弹性域
Segment
SQL: 说明性弹性域
select A.application_name,
DF.APPLICATION_TABLE_NAME,
DF.DESCRIPTIVE_FLEXFIELD_NAME,
DF.TITLE,
DFC.COLUMN_SEQ_NUM,
DFC.APPLICATION_COLUMN_NAME,
DFC.FORM_LEFT_PROMPT,
DFC.DEFAULT_TYPE,
DFC.DEFAULT_VALUE,
VS.FLEX_VALUE_SET_NAME
from FND_APPLICATION_VL A,
FND_DESCRIPTIVE_FLEXS_VL DF,
FND_DESCR_FLEX_COL_USAGE_VL DFC,
FND_FLEX_VALUE_SETS VS
where A.APPLICATION_ID = DF.APPLICATION_ID
and DF.DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_SYSTEM_ITEMS'
and DF.DESCRIPTIVE_FLEXFIELD_NAME = DFC.DESCRIPTIVE_FLEXFIELD_NAME
and DFC.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID(+)