[Home] [Help] [Dependency Information]
Object Name: | GCS_HIERARCHIES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GCS.GCS_HIERARCHIES_VL |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
GCS_HIERARCHIES_VL is the view for selecting data from multilingual entity GCS_HIERARCHIES_B
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | (15) | Yes | Consolidation hierarchy defining column |
TOP_ENTITY_ID | NUMBER | Yes | Top entity defining column | |
START_DATE | DATE | Yes | Consolidation hierarchy start date | |
CALENDAR_ID | NUMBER | Yes | Time dimension hierarchy defining column | |
DIMENSION_GROUP_ID | NUMBER | (9) | Yes | Dimension group defining column |
IE_BY_ORG_CODE | VARCHAR2 | (30) | Yes | Code to mark if intercompany eliminations is matched by organization, company, or cost center |
BALANCE_BY_ORG_FLAG | VARCHAR2 | (1) | Yes | Flag to mark if the hierarchy will balance by organization in addition to entity |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to mark if a hierarchy is usable |
THRESHOLD_AMOUNT | NUMBER | Yes | Threshold amount | |
THRESHOLD_CURRENCY | VARCHAR2 | (15) | Yes | Currency of the threshold amount |
FEM_LEDGER_ID | NUMBER | Yes | Ledger dimension defining column | |
COLUMN_NAME | VARCHAR2 | (30) | Additional tracking dimension defining column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object version number |
HIERARCHY_NAME | VARCHAR2 | (150) | Yes | User-defined consolidation hierarchy name |
DESCRIPTION | VARCHAR2 | (240) | Consolidation hierarchy description | |
SECURITY_ENABLED_FLAG | VARCHAR2 | (1) | Flag to enabled security | |
CERTIFICATION_FLAG | VARCHAR2 | (1) | Yes | Flag to mark certification hierarchy |
LOB_REPORTING_ENABLED_FLAG | VARCHAR2 | (1) | Flag to mark line of business reporting for intercompany eliminations. | |
LOB_HIERARCHY_OBJ_ID | NUMBER | Line of business hierarchy defining column. | ||
LOB_DIM_COLUMN_NAME | VARCHAR2 | (30) | Line of business tracking column. | |
HIERARCHY_GRP_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_ID
, TOP_ENTITY_ID
, START_DATE
, CALENDAR_ID
, DIMENSION_GROUP_ID
, IE_BY_ORG_CODE
, BALANCE_BY_ORG_FLAG
, ENABLED_FLAG
, THRESHOLD_AMOUNT
, THRESHOLD_CURRENCY
, FEM_LEDGER_ID
, COLUMN_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, HIERARCHY_NAME
, DESCRIPTION
, SECURITY_ENABLED_FLAG
, CERTIFICATION_FLAG
, LOB_REPORTING_ENABLED_FLAG
, LOB_HIERARCHY_OBJ_ID
, LOB_DIM_COLUMN_NAME
, HIERARCHY_GRP_FLAG
FROM APPS.GCS_HIERARCHIES_VL;
|
|
|