FND Design Data [Home] [Help]

View: MTL_LOT_SERIAL_DFF_ERV

Product: INV - Inventory
Description: Required for electronic records. Selects the lot and serial attributes out of the description flexfield data model.
Implementation/DBA Data: ViewAPPS.MTL_LOT_SERIAL_DFF_ERV
View Text

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')

Columns

Name
DESCRIPTIVE_FLEXFIELD_NAME
DESCRIPTIVE_FLEX_CONTEXT_CODE
APPLICATION_COLUMN_NAME
END_USER_COLUMN_NAME