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

TABLE: BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1

Object Details
Object Name: BIM_R_EVEN_DIM_SUM_MV_TEMP1
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Temporary table to store Event Dimension Summation data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EVENT_HEADER_AREA2 VARCHAR2 (30)
Event Header Area
EVENT_COUNTRY VARCHAR2 (30)
Event Country
EVENT_TYPE VARCHAR2 (30)
Type of the Event
BUSINESS_UNIT_ID NUMBER

Business Unit Identifier
YEAR VARCHAR2 (30)
Year
QTR VARCHAR2 (30)
Quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month Order
AGGREGATE_BY VARCHAR2 (5)
Summation By
HEADER_COUNT NUMBER

Header Count
REGISTRATIONS NUMBER

Number of registrations
CANCELLATIONS NUMBER

Number of cancellations
LEADS_OPEN NUMBER

Count of open leads
LEADS_OPEN_AMT NUMBER

Amount of open leads
LEADS_CLOSED NUMBER

Count of closed leads
LEADS_CLOSED_AMT NUMBER

Amount of closed leads
OPPORTUNITIES NUMBER

Opportunities
OPPORTUNITY_AMT NUMBER

Opportunity Amount
ATTENDANCE NUMBER

Attendance
FORECASTED_COST NUMBER

Forecasted cost
FORECASTED_REVENUE NUMBER

Forecasted revenue
ACTUAL_COST NUMBER

Actual cost
REVENUE NUMBER

Revenue
ORDER_AMT NUMBER

Order Amount
BUDGET_REQUESTED NUMBER

Requested Budget Amount
BUDGET_APPROVED NUMBER

Approved Budget Amount
RESOURCE_ID NUMBER

Resource Identifier
Query Text

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


SELECT EVENT_HEADER_AREA2
,      EVENT_COUNTRY
,      EVENT_TYPE
,      BUSINESS_UNIT_ID
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      HEADER_COUNT
,      REGISTRATIONS
,      CANCELLATIONS
,      LEADS_OPEN
,      LEADS_OPEN_AMT
,      LEADS_CLOSED
,      LEADS_CLOSED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ATTENDANCE
,      FORECASTED_COST
,      FORECASTED_REVENUE
,      ACTUAL_COST
,      REVENUE
,      ORDER_AMT
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      RESOURCE_ID
FROM BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1;

Dependencies

[top of page]

BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1 does not reference any database object

BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1 is referenced by following:

SchemaBIM
ViewBIM_R_EVEN_DIM_SUM_MV_TEMP1#