[Home] [Help] [Dependency Information]
Object Name: | FEM_SECONDARY_OWNERS |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Secondary relationship details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_SECONDARY_OWNERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_PERIOD_ID
DATASET_CODE SOURCE_SYSTEM_CODE ID_NUMBER CUSTOMER_ID TABLE_ID |
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 | |
CUSTOMER_ID | NUMBER | Yes | Unique numeric identifier of the Customer | |
DATASET_CODE | NUMBER | Yes | Dataset | |
ID_NUMBER | NUMBER | Yes | Uniquely identifies an instrument. | |
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 | |
TABLE_ID | NUMBER | Yes | Account Table Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_PERIOD_ID
, CREATED_BY_OBJECT_ID
, CREATED_BY_REQUEST_ID
, CUSTOMER_ID
, DATASET_CODE
, ID_NUMBER
, LAST_UPDATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, LEDGER_ID
, SOURCE_SYSTEM_CODE
, TABLE_ID
FROM FEM.FEM_SECONDARY_OWNERS;
FEM.FEM_SECONDARY_OWNERS does not reference any database object
FEM.FEM_SECONDARY_OWNERS is referenced by following:
|
|
|