View: INV_LOT_SERIAL_CONTEXT_V

Product:	INV - Inventory
Description:	View of Lot and Serial Descriptive Flex Field Context
Implementation/DBA Data:	APPS.INV_LOT_SERIAL_CONTEXT_V

View Text

SELECT DESCRIPTIVE_FLEXFIELD_NAME
, DESCRIPTIVE_FLEX_CONTEXT_CODE
, DECODE (DESCRIPTIVE_FLEXFIELD_NAME
, 'LOT ATTRIBUTES'
, 'LOT'
, 'SERIAL') QUERY_FOR
FROM FND_DESCR_FLEX_CONTEXTS_VL
WHERE APPLICATION_ID = 401
AND DESCRIPTIVE_FLEXFIELD_NAME IN ('LOT ATTRIBUTES'
, 'SERIAL ATTRIBUTES')
AND ENABLED_FLAG = 'Y' UNION SELECT 'LOT ATTRIBUTES'
, ' '
, 'LOT'
FROM DUAL UNION SELECT 'SERIAL ATTRIBUTES'
, ' '
, 'SERIAL'
FROM DUAL

Columns