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


TABLE: APPS.MLOG$_BIM_MKT_KPI_INT_MV

Object Details
Object Name: MLOG$_BIM_MKT_KPI_INT_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.BIM_MKT_KPI_INT_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER

ALEADS_CONVERSION_TIME NUMBER

ALEADS_CONVERTED NUMBER

ATTENDANCE NUMBER

BOOKED_ORDER_AMOUNT_S NUMBER

BUDGET_APPROVED NUMBER

BUDGET_APPROVED_S NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_REQUESTED_S NUMBER

CAMP_ENDED NUMBER

CAMP_SCH_ENDED NUMBER

CAMP_SCH_STARTED NUMBER

CAMP_STARTED NUMBER

CANCELLATIONS NUMBER

CATEGORY_ID NUMBER

CHANNEL_CODE VARCHAR2 (30)
COST_ACTUAL NUMBER

COST_ACTUAL_S NUMBER

COST_FORECASTED NUMBER

COST_FORECASTED_S NUMBER

CUSTOMERS_TARGETED NUMBER

CUST_CATEGORY VARCHAR2 (30)
EVEN_ENDED NUMBER

EVEN_SCH_ENDED NUMBER

EVEN_SCH_STARTED NUMBER

EVEN_STARTED NUMBER

INVOICED_ORDER_AMOUNT_S NUMBER

LEADS NUMBER

LEADS_CHANGED NUMBER

LEADS_CLOSED NUMBER

LEADS_CONVERSION_TIME NUMBER

LEADS_CONVERTED NUMBER

LEADS_CONV_CUSTOMER NUMBER

LEADS_CONV_PROSPECT NUMBER

LEADS_CUSTOMER NUMBER

LEADS_DEAD NUMBER

LEADS_NEW NUMBER

LEADS_OPEN NUMBER

LEADS_PROSPECT NUMBER

LEADS_QUALIFIED NUMBER

LEADS_QUALIFIED_A NUMBER

LEAD_RANK_ID NUMBER

LEAD_SOURCE VARCHAR2 (30)
LOST_OPPORTUNITY_AMT NUMBER

LOST_OPPORTUNITY_AMT_S NUMBER

LOST_OPPORTUNITY_CNT NUMBER

NEW_OPPORTUNITY_AMT NUMBER

NEW_OPPORTUNITY_AMT_S NUMBER

OBJECT_COUNTRY VARCHAR2 (30)
OBJECT_REGION VARCHAR2 (30)
OPEN_OPPORTUNITY_AMT NUMBER

OPEN_OPPORTUNITY_AMT_S NUMBER

ORDERS_BOOKED NUMBER

ORDERS_BOOKED_AMT NUMBER

ORDERS_INVOICED_AMT NUMBER

PERIOD_TYPE_ID NUMBER

RANK_A NUMBER

RANK_B NUMBER

RANK_C NUMBER

RANK_D NUMBER

RANK_Z NUMBER

REGISTRATIONS NUMBER

RESPONSES_FORECASTED NUMBER

RESPONSES_POSITIVE NUMBER

REVENUE_ACTUAL NUMBER

REVENUE_ACTUAL_S NUMBER

REVENUE_FORECASTED NUMBER

REVENUE_FORECASTED_S NUMBER

TIME_ID NUMBER

WON_OPPORTUNITY_AMT NUMBER

WON_OPPORTUNITY_AMT_S NUMBER

WON_OPPORTUNITY_CNT NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT ACTIVITY_ID
,      ALEADS_CONVERSION_TIME
,      ALEADS_CONVERTED
,      ATTENDANCE
,      BOOKED_ORDER_AMOUNT_S
,      BUDGET_APPROVED
,      BUDGET_APPROVED_S
,      BUDGET_REQUESTED
,      BUDGET_REQUESTED_S
,      CAMP_ENDED
,      CAMP_SCH_ENDED
,      CAMP_SCH_STARTED
,      CAMP_STARTED
,      CANCELLATIONS
,      CATEGORY_ID
,      CHANNEL_CODE
,      COST_ACTUAL
,      COST_ACTUAL_S
,      COST_FORECASTED
,      COST_FORECASTED_S
,      CUSTOMERS_TARGETED
,      CUST_CATEGORY
,      EVEN_ENDED
,      EVEN_SCH_ENDED
,      EVEN_SCH_STARTED
,      EVEN_STARTED
,      INVOICED_ORDER_AMOUNT_S
,      LEADS
,      LEADS_CHANGED
,      LEADS_CLOSED
,      LEADS_CONVERSION_TIME
,      LEADS_CONVERTED
,      LEADS_CONV_CUSTOMER
,      LEADS_CONV_PROSPECT
,      LEADS_CUSTOMER
,      LEADS_DEAD
,      LEADS_NEW
,      LEADS_OPEN
,      LEADS_PROSPECT
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_A
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LOST_OPPORTUNITY_AMT
,      LOST_OPPORTUNITY_AMT_S
,      LOST_OPPORTUNITY_CNT
,      NEW_OPPORTUNITY_AMT
,      NEW_OPPORTUNITY_AMT_S
,      OBJECT_COUNTRY
,      OBJECT_REGION
,      OPEN_OPPORTUNITY_AMT
,      OPEN_OPPORTUNITY_AMT_S
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      ORDERS_INVOICED_AMT
,      PERIOD_TYPE_ID
,      RANK_A
,      RANK_B
,      RANK_C
,      RANK_D
,      RANK_Z
,      REGISTRATIONS
,      RESPONSES_FORECASTED
,      RESPONSES_POSITIVE
,      REVENUE_ACTUAL
,      REVENUE_ACTUAL_S
,      REVENUE_FORECASTED
,      REVENUE_FORECASTED_S
,      TIME_ID
,      WON_OPPORTUNITY_AMT
,      WON_OPPORTUNITY_AMT_S
,      WON_OPPORTUNITY_CNT
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_BIM_MKT_KPI_INT_MV;

Dependencies

[top of page]

APPS.MLOG$_BIM_MKT_KPI_INT_MV does not reference any database object

APPS.MLOG$_BIM_MKT_KPI_INT_MV is not referenced by any database object