VIEW: APPS.INV_LOT_SERIAL_COLUMNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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