DBA Data[Home] [Help] [Dependency Information]

TABLE: APPS.BIM_I_MKT_FCT_MV

Object Details
Object Name: BIM_I_MKT_FCT_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIM_I_MKT_FCT_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UMARK NUMBER

TRANSACTION_CREATE_DATE DATE

SOURCE_CODE_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

CHILD_OBJECT_TYPE VARCHAR2 (30)
CHILD_OBJECT_ID NUMBER

OBJECT_COUNTRY VARCHAR2 (30)
CATEGORY_ID NUMBER

OBJECT_REGION VARCHAR2 (30)
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
CHILD_OBJECT_REGION VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

START_DATE DATE

END_DATE DATE

OBJECT_STATUS VARCHAR2 (30)
CHILD_OBJECT_STATUS VARCHAR2 (30)
OBJECT_PURPOSE VARCHAR2 (240)
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
ACTIVITY_TYPE VARCHAR2 (30)
ACTIVITY_ID NUMBER

LEAD_SOURCE VARCHAR2 (30)
CHANNEL_CODE VARCHAR2 (30)
LEAD_RANK_ID NUMBER

CUST_CATEGORY VARCHAR2 (30)
LEAD_CREATION_DATE DATE

LEAD_CONVERTED_DATE DATE

LEADS NUMBER

LEADS_C NUMBER

RANK_A NUMBER

RANK_A_C NUMBER

RANK_B NUMBER

RANK_B_C NUMBER

RANK_C NUMBER

RANK_C_C NUMBER

RANK_D NUMBER

RANK_D_C NUMBER

RANK_Z NUMBER

RANK_Z_C NUMBER

LEADS_CONVERTED NUMBER

LEADS_CONVERTED_C NUMBER

ALEADS_CONVERTED NUMBER

ALEADS_CONVERTED_C NUMBER

LEADS_OPEN NUMBER

LEADS_OPEN_C NUMBER

LEADS_NEW NUMBER

LEADS_NEW_C NUMBER

LEADS_CHANGED NUMBER

LEADS_CHANGED_C NUMBER

LEADS_DEAD NUMBER

LEADS_DEAD_C NUMBER

LEADS_CLOSED NUMBER

LEADS_CLOSED_C NUMBER

LEADS_CUSTOMER NUMBER

LEADS_CUSTOMER_C NUMBER

LEADS_PROSPECT NUMBER

LEADS_PROSPECT_C NUMBER

LEADS_CONV_CUSTOMER NUMBER

LEADS_CONV_CUSTOMER_C NUMBER

LEADS_CONV_PROSPECT NUMBER

LEADS_CONV_PROSPECT_C NUMBER

LEADS_QUALIFIED NUMBER

LEADS_QUALIFIED_C NUMBER

LEADS_QUALIFIED_A NUMBER

LEADS_QUALIFIED_A_C NUMBER

ORDERS_BOOKED NUMBER

ORDERS_BOOKED_C NUMBER

ORDERS_BOOKED_AMT NUMBER

ORDERS_BOOKED_AMT_C NUMBER

ORDERS_INVOICED_AMT NUMBER

ORDERS_INVOICED_AMT_C NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_REQUESTED_C NUMBER

BUDGET_APPROVED NUMBER

BUDGET_APPROVED_C NUMBER

REVENUE_FORECASTED NUMBER

REVENUE_FORECASTED_C NUMBER

REVENUE_ACTUAL NUMBER

REVENUE_ACTUAL_C NUMBER

COST_FORECASTED NUMBER

COST_FORECASTED_C NUMBER

COST_ACTUAL NUMBER

COST_ACTUAL_C NUMBER

CUSTOMERS_TARGETED NUMBER

CUSTOMERS_TARGETED_C NUMBER

RESPONSES_FORECASTED NUMBER

RESPONSES_FORECASTED_C NUMBER

RESPONSES_POSITIVE NUMBER

RESPONSES_POSITIVE_C NUMBER

NEW_OPPORTUNITY_AMT NUMBER

NEW_OPPORTUNITY_AMT_C NUMBER

WON_OPPORTUNITY_AMT NUMBER

WON_OPPORTUNITY_AMT_C NUMBER

LOST_OPPORTUNITY_AMT NUMBER

LOST_OPPORTUNITY_AMT_C NUMBER

OPEN_OPPORTUNITY_AMT NUMBER

OPEN_OPPORTUNITY_AMT_C NUMBER

WON_OPPORTUNITY_CNT NUMBER

WON_OPPORTUNITY_CNT_C NUMBER

LOST_OPPORTUNITY_CNT NUMBER

LOST_OPPORTUNITY_CNT_C NUMBER

CAMP_STARTED NUMBER

CAMP_STARTED_C NUMBER

EVEN_STARTED NUMBER

EVEN_STARTED_C NUMBER

CAMP_SCH_STARTED NUMBER

CAMP_SCH_STARTED_C NUMBER

EVEN_SCH_STARTED NUMBER

EVEN_SCH_STARTED_C NUMBER

CAMP_ENDED NUMBER

CAMP_ENDED_C NUMBER

EVEN_ENDED NUMBER

EVEN_ENDED_C NUMBER

CAMP_SCH_ENDED NUMBER

CAMP_SCH_ENDED_C NUMBER

EVEN_SCH_ENDED NUMBER

EVEN_SCH_ENDED_C NUMBER

REGISTRATIONS NUMBER

REGISTRATIONS_C NUMBER

CANCELLATIONS NUMBER

CANCELLATIONS_C NUMBER

ATTENDANCE NUMBER

ATTENDANCE_C NUMBER

BUDGET_REQUESTED_S NUMBER

BUDGET_REQUESTED_S_C NUMBER

BUDGET_APPROVED_S NUMBER

BUDGET_APPROVED_S_C NUMBER

REVENUE_FORECASTED_S NUMBER

REVENUE_FORECASTED_S_C NUMBER

REVENUE_ACTUAL_S NUMBER

REVENUE_ACTUAL_S_C NUMBER

COST_FORECASTED_S NUMBER

COST_FORECASTED_S_C NUMBER

COST_ACTUAL_S NUMBER

COST_ACTUAL_S_C NUMBER

BUDGET_APPROVED_SCH NUMBER

BUDGET_APPROVED_SCH_C NUMBER

BUDGET_APPROVED_SCH_S NUMBER

BUDGET_APPROVED_SCH_S_C NUMBER

BOOKED_ORDER_AMOUNT_S NUMBER

BOOKED_ORDER_AMOUNT_S_C NUMBER

INVOICED_ORDER_AMOUNT_S NUMBER

INVOICED_ORDER_AMOUNT_S_C NUMBER

NEW_OPPORTUNITY_AMT_S NUMBER

NEW_OPPORTUNITY_AMT_S_C NUMBER

WON_OPPORTUNITY_AMT_S NUMBER

WON_OPPORTUNITY_AMT_S_C NUMBER

LOST_OPPORTUNITY_AMT_S NUMBER

LOST_OPPORTUNITY_AMT_S_C NUMBER

OPEN_OPPORTUNITY_AMT_S NUMBER

OPEN_OPPORTUNITY_AMT_S_C NUMBER

ALL_C NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UMARK
,      TRANSACTION_CREATE_DATE
,      SOURCE_CODE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_ID
,      OBJECT_COUNTRY
,      CATEGORY_ID
,      OBJECT_REGION
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_REGION
,      BUSINESS_UNIT_ID
,      START_DATE
,      END_DATE
,      OBJECT_STATUS
,      CHILD_OBJECT_STATUS
,      OBJECT_PURPOSE
,      CHILD_OBJECT_PURPOSE
,      ACTIVITY_TYPE
,      ACTIVITY_ID
,      LEAD_SOURCE
,      CHANNEL_CODE
,      LEAD_RANK_ID
,      CUST_CATEGORY
,      LEAD_CREATION_DATE
,      LEAD_CONVERTED_DATE
,      LEADS
,      LEADS_C
,      RANK_A
,      RANK_A_C
,      RANK_B
,      RANK_B_C
,      RANK_C
,      RANK_C_C
,      RANK_D
,      RANK_D_C
,      RANK_Z
,      RANK_Z_C
,      LEADS_CONVERTED
,      LEADS_CONVERTED_C
,      ALEADS_CONVERTED
,      ALEADS_CONVERTED_C
,      LEADS_OPEN
,      LEADS_OPEN_C
,      LEADS_NEW
,      LEADS_NEW_C
,      LEADS_CHANGED
,      LEADS_CHANGED_C
,      LEADS_DEAD
,      LEADS_DEAD_C
,      LEADS_CLOSED
,      LEADS_CLOSED_C
,      LEADS_CUSTOMER
,      LEADS_CUSTOMER_C
,      LEADS_PROSPECT
,      LEADS_PROSPECT_C
,      LEADS_CONV_CUSTOMER
,      LEADS_CONV_CUSTOMER_C
,      LEADS_CONV_PROSPECT
,      LEADS_CONV_PROSPECT_C
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_C
,      LEADS_QUALIFIED_A
,      LEADS_QUALIFIED_A_C
,      ORDERS_BOOKED
,      ORDERS_BOOKED_C
,      ORDERS_BOOKED_AMT
,      ORDERS_BOOKED_AMT_C
,      ORDERS_INVOICED_AMT
,      ORDERS_INVOICED_AMT_C
,      BUDGET_REQUESTED
,      BUDGET_REQUESTED_C
,      BUDGET_APPROVED
,      BUDGET_APPROVED_C
,      REVENUE_FORECASTED
,      REVENUE_FORECASTED_C
,      REVENUE_ACTUAL
,      REVENUE_ACTUAL_C
,      COST_FORECASTED
,      COST_FORECASTED_C
,      COST_ACTUAL
,      COST_ACTUAL_C
,      CUSTOMERS_TARGETED
,      CUSTOMERS_TARGETED_C
,      RESPONSES_FORECASTED
,      RESPONSES_FORECASTED_C
,      RESPONSES_POSITIVE
,      RESPONSES_POSITIVE_C
,      NEW_OPPORTUNITY_AMT
,      NEW_OPPORTUNITY_AMT_C
,      WON_OPPORTUNITY_AMT
,      WON_OPPORTUNITY_AMT_C
,      LOST_OPPORTUNITY_AMT
,      LOST_OPPORTUNITY_AMT_C
,      OPEN_OPPORTUNITY_AMT
,      OPEN_OPPORTUNITY_AMT_C
,      WON_OPPORTUNITY_CNT
,      WON_OPPORTUNITY_CNT_C
,      LOST_OPPORTUNITY_CNT
,      LOST_OPPORTUNITY_CNT_C
,      CAMP_STARTED
,      CAMP_STARTED_C
,      EVEN_STARTED
,      EVEN_STARTED_C
,      CAMP_SCH_STARTED
,      CAMP_SCH_STARTED_C
,      EVEN_SCH_STARTED
,      EVEN_SCH_STARTED_C
,      CAMP_ENDED
,      CAMP_ENDED_C
,      EVEN_ENDED
,      EVEN_ENDED_C
,      CAMP_SCH_ENDED
,      CAMP_SCH_ENDED_C
,      EVEN_SCH_ENDED
,      EVEN_SCH_ENDED_C
,      REGISTRATIONS
,      REGISTRATIONS_C
,      CANCELLATIONS
,      CANCELLATIONS_C
,      ATTENDANCE
,      ATTENDANCE_C
,      BUDGET_REQUESTED_S
,      BUDGET_REQUESTED_S_C
,      BUDGET_APPROVED_S
,      BUDGET_APPROVED_S_C
,      REVENUE_FORECASTED_S
,      REVENUE_FORECASTED_S_C
,      REVENUE_ACTUAL_S
,      REVENUE_ACTUAL_S_C
,      COST_FORECASTED_S
,      COST_FORECASTED_S_C
,      COST_ACTUAL_S
,      COST_ACTUAL_S_C
,      BUDGET_APPROVED_SCH
,      BUDGET_APPROVED_SCH_C
,      BUDGET_APPROVED_SCH_S
,      BUDGET_APPROVED_SCH_S_C
,      BOOKED_ORDER_AMOUNT_S
,      BOOKED_ORDER_AMOUNT_S_C
,      INVOICED_ORDER_AMOUNT_S
,      INVOICED_ORDER_AMOUNT_S_C
,      NEW_OPPORTUNITY_AMT_S
,      NEW_OPPORTUNITY_AMT_S_C
,      WON_OPPORTUNITY_AMT_S
,      WON_OPPORTUNITY_AMT_S_C
,      LOST_OPPORTUNITY_AMT_S
,      LOST_OPPORTUNITY_AMT_S_C
,      OPEN_OPPORTUNITY_AMT_S
,      OPEN_OPPORTUNITY_AMT_S_C
,      ALL_C
FROM APPS.BIM_I_MKT_FCT_MV;

Dependencies

[top of page]

APPS.BIM_I_MKT_FCT_MV does not reference any database object

APPS.BIM_I_MKT_FCT_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_MKT_CPB_MV
Materialized ViewBIM_I_MKT_FCT_MV
Materialized ViewBIM_I_OBJ_METR_MV
Materialized ViewBIM_MKT_KPI_F_MV