VIEW: APPS.AMW_FIN_STMNT_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.STATEMENT_GROUP_ID,B.FINANCIAL_STATEMENT_ID,B.END_DATE,B.LAST_UPDATE_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_LOGIN,B.CREATION_DATE,B.CREATED_BY,B.ATTRIBUTE_CATEGORY,B.ATTRIBUTE1,B.ATTRIBUTE2,B.ATTRIBUTE3,B.ATTRIBUTE4,B.ATTRIBUTE5,B.ATTRIBUTE6,B.ATTRIBUTE7,B.ATTRIBUTE8,B.ATTRIBUTE9,B.ATTRIBUTE10,B.ATTRIBUTE11,B.ATTRIBUTE12,B.ATTRIBUTE13,B.ATTRIBUTE14,B.ATTRIBUTE15,B.SECURITY_GROUP_ID,B.OBJECT_VERSION_NUMBER,TL.NAME,TL.LANGUAGE,TL.SOURCE_LANG FROM AMW_FIN_STMNT_B B,AMW_FIN_STMNT_TL TL WHERE b.financial_statement_id = tl.financial_statement_id and b.statement_group_id = tl.statement_group_id and tl.language=userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.STATEMENT_GROUP_ID
, B.FINANCIAL_STATEMENT_ID
, B.END_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.SECURITY_GROUP_ID
, B.OBJECT_VERSION_NUMBER
, TL.NAME
, TL.LANGUAGE
, TL.SOURCE_LANG
FROM AMW_FIN_STMNT_B B
, AMW_FIN_STMNT_TL TL
WHERE B.FINANCIAL_STATEMENT_ID = TL.FINANCIAL_STATEMENT_ID
AND B.STATEMENT_GROUP_ID = TL.STATEMENT_GROUP_ID
AND TL.LANGUAGE=USERENV('LANG')