[Home] [Help]
View: RCI_SIGNIFICANT_ACCT_V
Product: | AMW - Internal Controls Manager |
Description: | This View contains the definition for the Significant Account dimension |
Implementation/DBA Data: |
APPS.RCI_SIGNIFICANT_ACCT_V
|
View Text
SELECT DISTINCT NATURAL_ACCOUNT_ID AS ID
, ACCOUNT_NAME||' ('||NATURAL_ACCOUNT_VALUE||') ' AS VALUE
FROM AMW_FIN_KEY_ACCOUNTS_VL
Columns