[Home] [Help]
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
Name |
DESCRIPTIVE_FLEXFIELD_NAME |
DESCRIPTIVE_FLEX_CONTEXT_CODE |
QUERY_FOR |