[Home] [Help] [Dependency Information]
Object Name: | BIM_I_MKT_CPB_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIM_I_MKT_CPB_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIM_I_MKT_FCT_MV
BIM_I_EXT_COL_MV
BIL_BI_OPDTL_MV
BIL_BI_OPDTL_F
ENI_OLTP_ITEM_STAR
FII_TIME_DAY
JTF_RS_GROUP_USAGES
BIM_I_LD_BASE_MV
BIM_I_LD_HEADER_MV
BIM_I_LEAD_FACTS
BIM_R_CODE_DEFINITIONS
BIM_I_ORD_COL_MV
BIM_I_SOURCE_CODES
ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_F
BIM_I_ORD_INT_MV
BIM_I_ORD_COL_MV
BIM_I_SOURCE_CODES
ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_F
ENI_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS
BIM_I_SOURCE_CODES
BIX_CALL_PRESP_MV
BIX_CALL_DETAILS_F
BIM_I_MARKETING_FACTS
BIM_I_SOURCE_CODES
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
UMARKER | NUMBER | |||
OBJECT_ID | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (30) | ||
OBJECT_COUNTRY | VARCHAR2 | (30) | ||
CATEGORY_ID | NUMBER | |||
OBJECT_REGION | VARCHAR2 | (30) | ||
CHILD_OBJECT_ID | NUMBER | |||
CHILD_OBJECT_TYPE | VARCHAR2 | (30) | ||
SOURCE_CODE_ID | NUMBER | |||
TOTAL_COST | NUMBER | |||
TOTAL_COST_FR | NUMBER | |||
BOOKED_AMT | NUMBER | |||
BOOKED_AMT_FR | NUMBER | |||
INVOICED_AMT | NUMBER | |||
INVOICED_AMT_FR | NUMBER | |||
WON_OPPORTUNITY_AMT | NUMBER | |||
WON_OPPORTUNITY_AMT_FR | NUMBER | |||
CUSTOMERS_TARGETED | NUMBER | |||
CUSTOMERS_TARGETED_FR | NUMBER | |||
RESPONSES_FORECASTED | NUMBER | |||
RESPONSES_FORECASTED_FR | NUMBER | |||
RESPONSES_POSITIVE | NUMBER | |||
RESPONSES_POSITIVE_FR | NUMBER | |||
ACTIVITY_ID | NUMBER | |||
BUDGET_APPROVED | NUMBER | |||
BUDGET_APPROVED_FR | NUMBER | |||
ACTUAL_COST | NUMBER | |||
ACTUAL_COST_FR | NUMBER | |||
LEADS | NUMBER | |||
TOTAL_LEADS_FR | NUMBER | |||
TOTAL_COST_S | NUMBER | |||
TOTAL_COST_S_FR | NUMBER | |||
BOOKED_AMT_S | NUMBER | |||
BOOKED_AMT_S_FR | NUMBER | |||
INVOICED_AMT_S | NUMBER | |||
INVOICED_AMT_S_FR | NUMBER | |||
WON_OPPORTUNITY_AMT_S | NUMBER | |||
WON_OPPORTUNITY_AMT_S_FR | NUMBER | |||
BUDGET_APPROVED_S | NUMBER | |||
BUDGET_APPROVED_S_FR | NUMBER | |||
ACTUAL_COST_S | NUMBER | |||
ACTUAL_COST_S_FR | NUMBER | |||
BUDGET_APPROVED_SCH | NUMBER | |||
BUDGET_APPROVED_SCH_FR | NUMBER | |||
BUDGET_APPROVED_SCH_S | NUMBER | |||
BUDGET_APPROVED_SCH_S_FR | NUMBER | |||
ALL_COUNT_FR | NUMBER | |||
DUMMY1_FR | NUMBER | |||
DUMMY2_FR | NUMBER | |||
DUMMY3_FR | NUMBER | |||
DUMMY4_FR | NUMBER | |||
DUMMY5_FR | NUMBER | |||
DUMMY6_FR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, UMARKER
, OBJECT_ID
, OBJECT_TYPE
, OBJECT_COUNTRY
, CATEGORY_ID
, OBJECT_REGION
, CHILD_OBJECT_ID
, CHILD_OBJECT_TYPE
, SOURCE_CODE_ID
, TOTAL_COST
, TOTAL_COST_FR
, BOOKED_AMT
, BOOKED_AMT_FR
, INVOICED_AMT
, INVOICED_AMT_FR
, WON_OPPORTUNITY_AMT
, WON_OPPORTUNITY_AMT_FR
, CUSTOMERS_TARGETED
, CUSTOMERS_TARGETED_FR
, RESPONSES_FORECASTED
, RESPONSES_FORECASTED_FR
, RESPONSES_POSITIVE
, RESPONSES_POSITIVE_FR
, ACTIVITY_ID
, BUDGET_APPROVED
, BUDGET_APPROVED_FR
, ACTUAL_COST
, ACTUAL_COST_FR
, LEADS
, TOTAL_LEADS_FR
, TOTAL_COST_S
, TOTAL_COST_S_FR
, BOOKED_AMT_S
, BOOKED_AMT_S_FR
, INVOICED_AMT_S
, INVOICED_AMT_S_FR
, WON_OPPORTUNITY_AMT_S
, WON_OPPORTUNITY_AMT_S_FR
, BUDGET_APPROVED_S
, BUDGET_APPROVED_S_FR
, ACTUAL_COST_S
, ACTUAL_COST_S_FR
, BUDGET_APPROVED_SCH
, BUDGET_APPROVED_SCH_FR
, BUDGET_APPROVED_SCH_S
, BUDGET_APPROVED_SCH_S_FR
, ALL_COUNT_FR
, DUMMY1_FR
, DUMMY2_FR
, DUMMY3_FR
, DUMMY4_FR
, DUMMY5_FR
, DUMMY6_FR
FROM APPS.BIM_I_MKT_CPB_MV;
|
|
|