Product: | BOM - Bills of Material |
---|---|
Description: | This is a view over Bom revisions base table and bom revisions translations |
Implementation/DBA Data: | Not implemented in this database |
SELECT BASE.BILL_REVISION_ID
, LANGUAGE
, SOURCE_LANG
, BASE.LAST_UPDATE_DATE
, BASE.LAST_UPDATED_BY
, BASE.CREATION_DATE
, BASE.CREATED_BY
, BASE.LAST_UPDATE_LOGIN
, BILL_SEQUENCE_ID
, ITEM_REVISION_ID
, COMMON_BILL_SEQUENCE_ID
, REVISION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
, REASON_CODE
, EFFECTIVE_DATE
, CHANGE_NOTICE
FROM BOM_BILL_REVISIONS_B BASE
, BOM_BILL_REVISIONS_TL TL
WHERE BASE.BILL_REVISION_ID = TL.BILL_REVISION_ID
AND TL.LANGUAGE = USERENV ('LANG')