View: INV_LOT_SERIAL_COLUMNS_V

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

View Text

SELECT APPLICATION_COLUMN_NAME
, END_USER_COLUMN_NAME
, DECODE (DESCRIPTIVE_FLEXFIELD_NAME
, 'LOT ATTRIBUTES'
, 'LOT'
, 'SERIAL') QUERY_FOR
, DESCRIPTIVE_FLEX_CONTEXT_CODE
FROM FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = 401
AND DESCRIPTIVE_FLEXFIELD_NAME IN ('LOT ATTRIBUTES'
, 'SERIAL ATTRIBUTES')
AND ENABLED_FLAG = 'Y'
AND APPLICATION_COLUMN_NAME IN ('D_ATTRIBUTE1'
, 'D_ATTRIBUTE2'
, 'D_ATTRIBUTE3'
, 'D_ATTRIBUTE4'
, 'D_ATTRIBUTE5'
, 'D_ATTRIBUTE6'
, 'D_ATTRIBUTE7'
, 'D_ATTRIBUTE8'
, 'D_ATTRIBUTE9'
, 'D_ATTRIBUTE10') UNION SELECT FC.COLUMN_NAME
, FC.COLUMN_NAME
, DECODE (FT.TABLE_NAME
, 'MTL_LOT_NUMBERS'
, 'LOT'
, 'SERIAL') QUERY_FOR
, ' '
FROM FND_TABLES FT
, FND_COLUMNS FC
WHERE FT.TABLE_NAME IN ('MTL_LOT_NUMBERS'
, 'MTL_SERIAL_NUMBERS')
AND FT.TABLE_ID = FC.TABLE_ID
AND FC.COLUMN_TYPE = 'D'
AND FC.COLUMN_NAME NOT IN ('CREATION_DATE'
, 'LAST_UPDATE_DATE'
, 'PROGRAM_UPDATE_DATE'
, 'D_ATTRIBUTE1'
, 'D_ATTRIBUTE2'
, 'D_ATTRIBUTE3'
, 'D_ATTRIBUTE4'
, 'D_ATTRIBUTE5'
, 'D_ATTRIBUTE6'
, 'D_ATTRIBUTE7'
, 'D_ATTRIBUTE8'
, 'D_ATTRIBUTE9'
, 'D_ATTRIBUTE10')

Columns