[Home] [Help] [Dependency Information]
Object Name: | BIM_MKT_KPI_INT_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_MKT_KPI_INT_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_BIM_MKT_KPI_INT_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_TX_DATA |
SYS_OP_MAP_NONNULL("OBJECT_REGION")
SYS_OP_MAP_NONNULL("OBJECT_COUNTRY") SYS_OP_MAP_NONNULL("CATEGORY_ID") SYS_OP_MAP_NONNULL("LEAD_SOURCE") SYS_OP_MAP_NONNULL("CHANNEL_CODE") SYS_OP_MAP_NONNULL("LEAD_RANK_ID") SYS_OP_MAP_NONNULL("CUST_CATEGORY") SYS_OP_MAP_NONNULL("ACTIVITY_ID") SYS_OP_MAP_NONNULL("DUMMY1_FR") SYS_OP_MAP_NONNULL("DUMMY2_FR") SYS_OP_MAP_NONNULL("DUMMY3_FR") SYS_OP_MAP_NONNULL("DUMMY4_FR") SYS_OP_MAP_NONNULL("DUMMY5_FR") SYS_OP_MAP_NONNULL("DUMMY6_FR") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
OBJECT_REGION | VARCHAR2 | (30) | ||
OBJECT_COUNTRY | VARCHAR2 | (30) | ||
CATEGORY_ID | NUMBER | |||
PARENT_CATEGORY_ID | CHAR | (4) | ||
LEAD_SOURCE | VARCHAR2 | (30) | ||
CHANNEL_CODE | VARCHAR2 | (30) | ||
LEAD_RANK_ID | NUMBER | |||
CUST_CATEGORY | VARCHAR2 | (30) | ||
ACTIVITY_ID | NUMBER | |||
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 | |||
LEADS_CONVERSION_TIME | NUMBER | |||
ALEADS_CONVERTED | NUMBER | |||
ALEADS_CONVERTED_C | NUMBER | |||
ALEADS_CONVERSION_TIME | 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 | |||
RESPONSES_POSITIVE | NUMBER | |||
RESPONSES_POSITIVE_C | NUMBER | |||
RESPONSES_FORECASTED | NUMBER | |||
RESPONSES_FORECASTED_C | NUMBER | |||
ORDERS_BOOKED | NUMBER | |||
ORDERS_BOOKED_C | NUMBER | |||
CUSTOMERS_TARGETED | NUMBER | |||
CUSTOMERS_TARGETED_C | NUMBER | |||
COST_ACTUAL | NUMBER | |||
COST_ACTUAL_C | NUMBER | |||
COST_FORECASTED | NUMBER | |||
COST_FORECASTED_C | NUMBER | |||
BUDGET_APPROVED | NUMBER | |||
BUDGET_APPROVED_C | NUMBER | |||
BUDGET_REQUESTED | NUMBER | |||
BUDGET_REQUESTED_C | NUMBER | |||
ORDERS_BOOKED_AMT | NUMBER | |||
ORDERS_BOOKED_AMT_C | NUMBER | |||
ORDERS_INVOICED_AMT | NUMBER | |||
ORDERS_INVOICED_AMT_C | NUMBER | |||
REVENUE_ACTUAL | NUMBER | |||
REVENUE_ACTUAL_C | NUMBER | |||
REVENUE_FORECASTED | NUMBER | |||
REVENUE_FORECASTED_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 | |||
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 | |||
DUMMY1_FR | NUMBER | |||
DUMMY2_FR | NUMBER | |||
DUMMY3_FR | NUMBER | |||
DUMMY4_FR | NUMBER | |||
DUMMY5_FR | NUMBER | |||
DUMMY6_FR | NUMBER | |||
DUMMY7_FR | NUMBER | |||
DUMMY8_FR | NUMBER | |||
ALL_C | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, OBJECT_REGION
, OBJECT_COUNTRY
, CATEGORY_ID
, PARENT_CATEGORY_ID
, LEAD_SOURCE
, CHANNEL_CODE
, LEAD_RANK_ID
, CUST_CATEGORY
, ACTIVITY_ID
, 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
, LEADS_CONVERSION_TIME
, ALEADS_CONVERTED
, ALEADS_CONVERTED_C
, ALEADS_CONVERSION_TIME
, 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
, RESPONSES_POSITIVE
, RESPONSES_POSITIVE_C
, RESPONSES_FORECASTED
, RESPONSES_FORECASTED_C
, ORDERS_BOOKED
, ORDERS_BOOKED_C
, CUSTOMERS_TARGETED
, CUSTOMERS_TARGETED_C
, COST_ACTUAL
, COST_ACTUAL_C
, COST_FORECASTED
, COST_FORECASTED_C
, BUDGET_APPROVED
, BUDGET_APPROVED_C
, BUDGET_REQUESTED
, BUDGET_REQUESTED_C
, ORDERS_BOOKED_AMT
, ORDERS_BOOKED_AMT_C
, ORDERS_INVOICED_AMT
, ORDERS_INVOICED_AMT_C
, REVENUE_ACTUAL
, REVENUE_ACTUAL_C
, REVENUE_FORECASTED
, REVENUE_FORECASTED_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
, 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
, DUMMY1_FR
, DUMMY2_FR
, DUMMY3_FR
, DUMMY4_FR
, DUMMY5_FR
, DUMMY6_FR
, DUMMY7_FR
, DUMMY8_FR
, ALL_C
FROM APPS.BIM_MKT_KPI_INT_MV;
APPS.BIM_MKT_KPI_INT_MV does not reference any database object
APPS.BIM_MKT_KPI_INT_MV is referenced by following:
|
|
|