[Home] [Help] [Dependency Information]
Object Name: | FEM_LEDGER_DIM_VS_MAP |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_LEDGER_DIM_VS_MAP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LEDGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | Yes | Numeric identifier for the Ledger dimension member | |
COMPANY_COST_CENTER_ORG_VS_ID | NUMBER | Numeric identifier for the Company Cost Center Organization value set of the Ledger | ||
FINANCIAL_ELEM_VS_ID | NUMBER | Numeric identifier for the Financial Element value set of the Ledger | ||
PRODUCT_VS_ID | NUMBER | Numeric identifier for the Product value set of the Ledger | ||
NATURAL_ACCOUNT_VS_ID | NUMBER | Numeric identifier for the Natural Account value set of the Ledger | ||
CHANNEL_VS_ID | NUMBER | Numeric identifier for the Channel value set of the Ledger | ||
LINE_ITEM_VS_ID | NUMBER | Numeric identifier for the Line Item value set of the Ledger | ||
PROJECT_VS_ID | NUMBER | Numeric identifier for the Project value set of the Ledger | ||
CUSTOMER_VS_ID | NUMBER | Numeric identifier for the Customer value set of the Ledger | ||
ENTITY_VS_ID | NUMBER | Numeric identifier for the Entity value set of the Ledger | ||
INTERCOMPANY_VS_ID | NUMBER | Numeric identifier for the value set of the Intercompany member | ||
USER_DIM1_VS_ID | NUMBER | Numeric identifier for the User Dimension1 value set of the Ledger | ||
USER_DIM2_VS_ID | NUMBER | Numeric identifier for the User Dimension2 value set of the Ledger | ||
USER_DIM3_VS_ID | NUMBER | Numeric identifier for the User Dimension3 value set of the Ledger | ||
USER_DIM4_VS_ID | NUMBER | Numeric identifier for the User Dimension4 value set of the Ledger | ||
USER_DIM5_VS_ID | NUMBER | Numeric identifier for the User Dimension5 value set of the Ledger | ||
USER_DIM6_VS_ID | NUMBER | Numeric identifier for the User Dimension6 value set of the Ledger | ||
USER_DIM7_VS_ID | NUMBER | Numeric identifier for the User Dimension7 value set of the Ledger | ||
USER_DIM8_VS_ID | NUMBER | Numeric identifier for the User Dimension8 value set of the Ledger | ||
USER_DIM9_VS_ID | NUMBER | Numeric identifier for the User Dimension9 value set of the Ledger | ||
USER_DIM10_VS_ID | NUMBER | Numeric identifier for the User Dimension10 value set of the Ledger | ||
GEOGRAPHY_VS_ID | NUMBER | Numeric identifier for the Geography value set of the Ledger | ||
TASK_VS_ID | NUMBER | Identifies the Value Set applicable for the Task dimension for the given Ledger |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, COMPANY_COST_CENTER_ORG_VS_ID
, FINANCIAL_ELEM_VS_ID
, PRODUCT_VS_ID
, NATURAL_ACCOUNT_VS_ID
, CHANNEL_VS_ID
, LINE_ITEM_VS_ID
, PROJECT_VS_ID
, CUSTOMER_VS_ID
, ENTITY_VS_ID
, INTERCOMPANY_VS_ID
, USER_DIM1_VS_ID
, USER_DIM2_VS_ID
, USER_DIM3_VS_ID
, USER_DIM4_VS_ID
, USER_DIM5_VS_ID
, USER_DIM6_VS_ID
, USER_DIM7_VS_ID
, USER_DIM8_VS_ID
, USER_DIM9_VS_ID
, USER_DIM10_VS_ID
, GEOGRAPHY_VS_ID
, TASK_VS_ID
FROM FEM.FEM_LEDGER_DIM_VS_MAP;
FEM.FEM_LEDGER_DIM_VS_MAP does not reference any database object
FEM.FEM_LEDGER_DIM_VS_MAP is referenced by following:
|
|
|