VIEW: APPS.INV_LOT_SERIAL_CONTEXT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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