View: BOM_STRUCTURE_TYPES_VL

Product:	BOM - Bills of Material
Description:	This is a view over Structure type base table and translation table
Implementation/DBA Data:	APPS.BOM_STRUCTURE_TYPES_VL

View Text

SELECT BASE.ROWID ROW_ID
, BASE.STRUCTURE_TYPE_ID
, LANGUAGE
, SOURCE_LANG
, BASE.LAST_UPDATE_DATE
, BASE.LAST_UPDATED_BY
, BASE.CREATION_DATE
, BASE.CREATED_BY
, BASE.LAST_UPDATE_LOGIN
, STRUCTURE_TYPE_NAME
, ITEM_CATALOG_GROUP_ID
, EFFECTIVE_DATE
, STRUCTURE_CREATION_ALLOWED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
, DISABLE_DATE
, PARENT_STRUCTURE_TYPE_ID
, ENABLE_ATTACHMENTS_FLAG
, DISPLAY_NAME
, ENABLE_UNIMPLEMENTED_BOMS
, ALLOW_SUBTYPES
FROM BOM_STRUCTURE_TYPES_B BASE
, BOM_STRUCTURE_TYPES_TL TL
WHERE BASE.STRUCTURE_TYPE_ID = TL.STRUCTURE_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns