[Home] [Help] [Dependency Information]
Object Name: | FEM_ACTIVITIES_T |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
FEM_ACTIVITIES_T is an interface table for defining Activity members using the Dimension Member Loader. This is the identifying table for new members, so that there is one row for each new Activity member that you wish to load.
Each Activity member is a composite defined by a member from each of the designated component dimensions. When defining Activity members in the interface table, you only need to populate the appropriate DISPLAY_CODE columns for the dimensions that make up your Activity composite definition. In addition, you need to populate the GLOBAL_VS_COMBO_DISPLAY_CODE column with a valid Global Value Set Combination. The Global Value Set Combination defines the value sets used for each of the individual component dimensions.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Activity Member
Category: BUSINESS_ENTITY FEM_XDIM_ACTIVITY
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GLOBAL_VS_COMBO_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Global Value Set Combination Display Code |
TASK_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Task Display Code |
CCTR_ORG_DISPLAY_CODE | VARCHAR2 | (150) | Company Cost Center Organization Display Code | |
CUSTOMER_DISPLAY_CODE | VARCHAR2 | (150) | Customer Display Code | |
CHANNEL_DISPLAY_CODE | VARCHAR2 | (150) | Channel Display Code | |
PRODUCT_DISPLAY_CODE | VARCHAR2 | (150) | Product Display Code | |
PROJECT_DISPLAY_CODE | VARCHAR2 | (150) | Project Display Code | |
USER_DIM1_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension1 Display Code | |
USER_DIM2_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension2 Display Code | |
USER_DIM3_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension3 Display Code | |
USER_DIM4_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension4 Display Code | |
USER_DIM5_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension5 Display Code | |
USER_DIM6_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension6 Display Code | |
USER_DIM7_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension7 Display Code | |
USER_DIM8_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension8 Display Code | |
USER_DIM9_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension9 Display Code | |
USER_DIM10_DISPLAY_CODE | VARCHAR2 | (150) | User Dimension10 Display Code | |
STATUS | VARCHAR2 | (50) | Yes | Load Status |
Cut, paste (and edit) the following text to query this object:
SELECT GLOBAL_VS_COMBO_DISPLAY_CODE
, TASK_DISPLAY_CODE
, CCTR_ORG_DISPLAY_CODE
, CUSTOMER_DISPLAY_CODE
, CHANNEL_DISPLAY_CODE
, PRODUCT_DISPLAY_CODE
, PROJECT_DISPLAY_CODE
, USER_DIM1_DISPLAY_CODE
, USER_DIM2_DISPLAY_CODE
, USER_DIM3_DISPLAY_CODE
, USER_DIM4_DISPLAY_CODE
, USER_DIM5_DISPLAY_CODE
, USER_DIM6_DISPLAY_CODE
, USER_DIM7_DISPLAY_CODE
, USER_DIM8_DISPLAY_CODE
, USER_DIM9_DISPLAY_CODE
, USER_DIM10_DISPLAY_CODE
, STATUS
FROM FEM.FEM_ACTIVITIES_T;
FEM.FEM_ACTIVITIES_T does not reference any database object
FEM.FEM_ACTIVITIES_T is referenced by following:
|
|
|