[Home] [Help] [Dependency Information]
Object Name: | FEM_TRANS_TERM_DEPOSITS |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Term Deposits Transactions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_PERIOD_ID | NUMBER | Yes | Calendar Period | |
COST | NUMBER | Cost | ||
CREATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Created by Object |
CREATED_BY_REQUEST_ID | NUMBER | Yes | Created by Request | |
DATASET_CODE | NUMBER | Yes | Dataset Code | |
ID_NUMBER | NUMBER | Yes | ID Number | |
LAST_UPDATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Last Updated by Object |
LAST_UPDATED_BY_REQUEST_ID | NUMBER | Yes | Last Updated by Request | |
LEDGER_ID | NUMBER | Yes | Ledger ID | |
SOURCE_SYSTEM_CODE | NUMBER | Yes | Source System Code | |
VOLUME | NUMBER | Yes | Volume | |
ACTIVITY_ID | NUMBER | Activity | ||
CHANNEL_ID | NUMBER | Channel | ||
COMPANY_COST_CENTER_ORG_ID | NUMBER | Company Cost Center Organization | ||
COST_OBJECT_ID | NUMBER | Cost Object | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency | |
CUSTOMER_ID | NUMBER | Customer | ||
ENTITY_ID | NUMBER | Entity | ||
FINANCIAL_ELEM_ID | NUMBER | Financial Element | ||
GEOGRAPHY_ID | NUMBER | Geography | ||
INTERCOMPANY_ID | NUMBER | Inter Company | ||
LINE_ITEM_ID | NUMBER | Line Item | ||
NATURAL_ACCOUNT_ID | NUMBER | Natural Account | ||
PRODUCT_ID | NUMBER | Product | ||
PROJECT_ID | NUMBER | Project | ||
TASK_ID | NUMBER | Task | ||
USER_DIM10_ID | NUMBER | User Defined Dimension #10 | ||
USER_DIM1_ID | NUMBER | User Defined Dimension #1 | ||
USER_DIM2_ID | NUMBER | User Defined Dimension #2 | ||
USER_DIM3_ID | NUMBER | User Defined Dimension #3 | ||
USER_DIM4_ID | NUMBER | User Defined Dimension #4 | ||
USER_DIM5_ID | NUMBER | User Defined Dimension #5 | ||
USER_DIM6_ID | NUMBER | User Defined Dimension #6 | ||
USER_DIM7_ID | NUMBER | User Defined Dimension #7 | ||
USER_DIM8_ID | NUMBER | User Defined Dimension #8 | ||
USER_DIM9_ID | NUMBER | User Defined Dimension #9 |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_PERIOD_ID
, COST
, CREATED_BY_OBJECT_ID
, CREATED_BY_REQUEST_ID
, DATASET_CODE
, ID_NUMBER
, LAST_UPDATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, LEDGER_ID
, SOURCE_SYSTEM_CODE
, VOLUME
, ACTIVITY_ID
, CHANNEL_ID
, COMPANY_COST_CENTER_ORG_ID
, COST_OBJECT_ID
, CURRENCY_CODE
, CUSTOMER_ID
, ENTITY_ID
, FINANCIAL_ELEM_ID
, GEOGRAPHY_ID
, INTERCOMPANY_ID
, LINE_ITEM_ID
, NATURAL_ACCOUNT_ID
, PRODUCT_ID
, PROJECT_ID
, TASK_ID
, USER_DIM10_ID
, USER_DIM1_ID
, USER_DIM2_ID
, USER_DIM3_ID
, USER_DIM4_ID
, USER_DIM5_ID
, USER_DIM6_ID
, USER_DIM7_ID
, USER_DIM8_ID
, USER_DIM9_ID
FROM FEM.FEM_TRANS_TERM_DEPOSITS;
FEM.FEM_TRANS_TERM_DEPOSITS does not reference any database object
FEM.FEM_TRANS_TERM_DEPOSITS is referenced by following:
|
|
|