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

TABLE: APPS.BIM_R_EVEN_DIM_SUM_MV

Object Details
Object Name: BIM_R_EVEN_DIM_SUM_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
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 APPS.BIM_R_EVEN_DIM_SUM_MV;

Dependencies

[top of page]

APPS.BIM_R_EVEN_DIM_SUM_MV does not reference any database object

APPS.BIM_R_EVEN_DIM_SUM_MV is referenced by following:

SchemaAPPS
Package BodyAMS_DCF_DEFAULT_VALUES - show dependent code
Package BodyAMS_DCF_TITLE - show dependent code