[Home] [Help] [Dependency Information]
Object Name: | BIM_I_CPB_CHNL_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_I_CPB_CHNL_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIM_I_CPB_CHNL_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
SYS_OP_MAP_NONNULL("TIME_ID") SYS_OP_MAP_NONNULL("SOURCE_CODE_ID") SYS_OP_MAP_NONNULL("IMMEDIATE_PARENT_ID") SYS_OP_MAP_NONNULL("ACTIVITY_ID") SYS_OP_MAP_NONNULL("OBJECT_COUNTRY_C") SYS_OP_MAP_NONNULL("CATEGORY_ID_C") SYS_OP_MAP_NONNULL("GROUPING_ID") |
BIM_I_CPB_CHNL_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID OBJECT_COUNTRY CATEGORY_ID IMMEDIATE_PARENT_ID |
BIM_I_CPB_CHNL_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID OBJECT_COUNTRY CATEGORY_ID SOURCE_CODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
SOURCE_CODE_ID | NUMBER | (30) | ||
IMMEDIATE_PARENT_ID | NUMBER | |||
ACTIVITY_ID | NUMBER | |||
OBJECT_COUNTRY | VARCHAR2 | (30) | ||
OBJECT_COUNTRY_C | VARCHAR2 | (30) | ||
CATEGORY_ID | NUMBER | |||
CATEGORY_ID_C | NUMBER | |||
TOTAL_LEADS | NUMBER | |||
TOTAL_LEADS_C | NUMBER | |||
TOTAL_COST | NUMBER | |||
TOTAL_COST_C | NUMBER | |||
BOOKED_AMT | NUMBER | |||
BOOKED_AMT_C | NUMBER | |||
INVOICED_AMT | NUMBER | |||
INVOICED_AMT_C | NUMBER | |||
WON_OPPORTUNITY_AMT | NUMBER | |||
WON_OPPORTUNITY_AMT_C | NUMBER | |||
BUDGET_APPROVED | NUMBER | |||
BUDGET_APPROVED_C | NUMBER | |||
ACTUAL_COST | NUMBER | |||
ACTUAL_COST_C | NUMBER | |||
CUSTOMERS_TARGETED | NUMBER | |||
CUSTOMERS_TARGETED_C | NUMBER | |||
RESPONSES_FORECASTED | NUMBER | |||
RESPONSES_FORECASTED_C | NUMBER | |||
RESPONSES_POSITIVE | NUMBER | |||
RESPONSES_POSITIVE_C | NUMBER | |||
TOTAL_COST_S | NUMBER | |||
TOTAL_COST_S_C | NUMBER | |||
BOOKED_AMT_S | NUMBER | |||
BOOKED_AMT_S_C | NUMBER | |||
INVOICED_AMT_S | NUMBER | |||
INVOICED_AMT_S_C | NUMBER | |||
WON_OPPORTUNITY_AMT_S | NUMBER | |||
WON_OPPORTUNITY_AMT_S_C | NUMBER | |||
BUDGET_APPROVED_S | NUMBER | |||
BUDGET_APPROVED_S_C | NUMBER | |||
ACTUAL_COST_S | NUMBER | |||
ACTUAL_COST_S_C | NUMBER | |||
ALL_C | NUMBER | |||
GROUPING_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, SOURCE_CODE_ID
, IMMEDIATE_PARENT_ID
, ACTIVITY_ID
, OBJECT_COUNTRY
, OBJECT_COUNTRY_C
, CATEGORY_ID
, CATEGORY_ID_C
, TOTAL_LEADS
, TOTAL_LEADS_C
, TOTAL_COST
, TOTAL_COST_C
, BOOKED_AMT
, BOOKED_AMT_C
, INVOICED_AMT
, INVOICED_AMT_C
, WON_OPPORTUNITY_AMT
, WON_OPPORTUNITY_AMT_C
, BUDGET_APPROVED
, BUDGET_APPROVED_C
, ACTUAL_COST
, ACTUAL_COST_C
, CUSTOMERS_TARGETED
, CUSTOMERS_TARGETED_C
, RESPONSES_FORECASTED
, RESPONSES_FORECASTED_C
, RESPONSES_POSITIVE
, RESPONSES_POSITIVE_C
, TOTAL_COST_S
, TOTAL_COST_S_C
, BOOKED_AMT_S
, BOOKED_AMT_S_C
, INVOICED_AMT_S
, INVOICED_AMT_S_C
, WON_OPPORTUNITY_AMT_S
, WON_OPPORTUNITY_AMT_S_C
, BUDGET_APPROVED_S
, BUDGET_APPROVED_S_C
, ACTUAL_COST_S
, ACTUAL_COST_S_C
, ALL_C
, GROUPING_ID
FROM APPS.BIM_I_CPB_CHNL_MV;
APPS.BIM_I_CPB_CHNL_MV does not reference any database object
APPS.BIM_I_CPB_CHNL_MV is referenced by following:
|
|
|