[Home] [Help] [Dependency Information]
Object Name: | FEM_REGION_INFO |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Region counting information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_REGION_INFO_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_PERIOD_ID
DATASET_CODE SOURCE_SYSTEM_CODE DIMENSION_GROUP_ID LEDGER_ID REGION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_PERIOD_ID | NUMBER | Yes | Calendar Period | |
CREATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Created By Object |
CREATED_BY_REQUEST_ID | NUMBER | Yes | Created By Request | |
DATASET_CODE | NUMBER | Yes | Dataset | |
DIMENSION_GROUP_ID | NUMBER | Yes | Dimension group | |
LAST_UPDATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID |
LAST_UPDATED_BY_REQUEST_ID | NUMBER | Yes | Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID | |
LEDGER_ID | NUMBER | Yes | Ledger | |
SOURCE_SYSTEM_CODE | NUMBER | Yes | Source System | |
NUMBER_OF_CUSTOMERS | NUMBER | Number of customers in region | ||
REGION_CODE | NUMBER | Region Code | ||
REGION_PCT_TOTAL_CUST | NUMBER | Percentage of customers in region to total number of customers in valuation set |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_PERIOD_ID
, CREATED_BY_OBJECT_ID
, CREATED_BY_REQUEST_ID
, DATASET_CODE
, DIMENSION_GROUP_ID
, LAST_UPDATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, LEDGER_ID
, SOURCE_SYSTEM_CODE
, NUMBER_OF_CUSTOMERS
, REGION_CODE
, REGION_PCT_TOTAL_CUST
FROM FEM.FEM_REGION_INFO;
FEM.FEM_REGION_INFO does not reference any database object
FEM.FEM_REGION_INFO is referenced by following:
|
|
|