Product: | AMW - Internal Controls Manager (Obsolete) |
---|---|
Description: | Holds All Financial Items in a Financial Statements |
Implementation/DBA Data: | Not implemented in this database |
SELECT B.ROWID ROW_ID
, B.STATEMENT_GROUP_ID
, B.FINANCIAL_STATEMENT_ID
, B.FINANCIAL_ITEM_ID
, PARENT_FINANCIAL_ITEM_ID
, NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, B.SECURITY_GROUP_ID
, B.OBJECT_VERSION_NUMBER
FROM AMW_FIN_STMNT_ITEMS_B B
, AMW_FIN_STMNT_ITEMS_TL TL
WHERE B.STATEMENT_GROUP_ID = TL.STATEMENT_GROUP_ID
AND B.FINANCIAL_STATEMENT_ID = TL.FINANCIAL_STATEMENT_ID
AND B.FINANCIAL_ITEM_ID = TL.FINANCIAL_ITEM_ID
AND TL.LANGUAGE=USERENV('LANG')