SELECT descriptive_flexfield_name, descriptive_flex_context_code, application_column_name, end_user_column_name from fnd_descr_flex_col_usage_vl where application_id = 401 and descriptive_flexfield_name in ('Lot Attributes', 'Serial Attributes', 'MTL_LOT_NUMBERS')
SELECT DESCRIPTIVE_FLEXFIELD_NAME
, DESCRIPTIVE_FLEX_CONTEXT_CODE
, APPLICATION_COLUMN_NAME
, END_USER_COLUMN_NAME
FROM FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = 401
AND DESCRIPTIVE_FLEXFIELD_NAME IN ('LOT ATTRIBUTES'
, 'SERIAL ATTRIBUTES'
, 'MTL_LOT_NUMBERS')
|
|
|