Skip to content

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

VIEW: BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1#

Object Details
Object Name: BIM_R_EVEN_DIM_SUM_MV_TEMP1#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_HEADER_AREA2 VARCHAR2 (30)
EVENT_COUNTRY VARCHAR2 (30)
EVENT_TYPE VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

YEAR VARCHAR2 (30)
QTR VARCHAR2 (30)
MONTH VARCHAR2 (30)
MONTH_ORDER NUMBER

AGGREGATE_BY VARCHAR2 (5)
HEADER_COUNT NUMBER

REGISTRATIONS NUMBER

CANCELLATIONS NUMBER

LEADS_OPEN NUMBER

LEADS_OPEN_AMT NUMBER

LEADS_CLOSED NUMBER

LEADS_CLOSED_AMT NUMBER

OPPORTUNITIES NUMBER

OPPORTUNITY_AMT NUMBER

ATTENDANCE NUMBER

FORECASTED_COST NUMBER

FORECASTED_REVENUE NUMBER

ACTUAL_COST NUMBER

REVENUE NUMBER

ORDER_AMT NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_APPROVED NUMBER

RESOURCE_ID NUMBER

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# references the following:

SchemaBIM
TableBIM_R_EVEN_DIM_SUM_MV_TEMP1
BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1# is referenced by following:

SchemaAPPS
SynonymBIM_R_EVEN_DIM_SUM_MV_TEMP1