[Home] [Help]
View: FII_FIN_ITEM_SETS_V
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | Internal view used to support Financial Item Hierarchy in DBI. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT GLFIS.ROWID ROW_ID
, GLFIS.FIN_ITEM_SET FIN_ITEM_SET
, FFVT.FLEX_VALUE_MEANING FIN_ITEM_SET_DISPLAY
, GLFIS.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FIFSV.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, GLFIS.STATUS_CODE STATUS_CODE
, GLFIS.CREATION_DATE CREATION_DATE
, GLFIS.CREATED_BY CREATED_BY
, GLFIS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GLFIS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GLFIS.LAST_UPDATED_BY LAST_UPDATED_BY FROM FII_FIN_ITEM_SETS GLFIS
, FND_FLEX_VALUE_SETS FFVS
, FND_FLEX_VALUES FFV
, FND_FLEX_VALUES_TL FFVT
, FND_ID_FLEX_STRUCTURES_V FIFSV
WHERE FFVS.FLEX_VALUE_SET_NAME = 'FINANCIAL ITEM SETS' AND FFV.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID AND FFV.FLEX_VALUE = GLFIS.FIN_ITEM_SET AND FFVT.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID AND FFVT.LANGUAGE = USERENV('LANG') AND FIFSV.APPLICATION_ID = 101 AND FIFSV.ID_FLEX_CODE = 'GL#' AND FIFSV.ID_FLEX_NUM = GLFIS.CHART_OF_ACCOUNTS_ID
Columns
| Name |
| ROW_ID |
| FIN_ITEM_SET |
| FIN_ITEM_SET_DISPLAY |
| CHART_OF_ACCOUNTS_ID |
| CHART_OF_ACCOUNTS_NAME |
| STATUS_CODE |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| LAST_UPDATED_BY |