Skip to content

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

TABLE: AMS.AMS_ACT_METRICS_ALL_DENORM

Object Details
Object Name: AMS_ACT_METRICS_ALL_DENORM
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_ACT_METRICS_ALL_DENORM
Subobject Name:
Status: VALID


This table holds the denormalized data for all associated metrics with Campaign/Schedules
/Lists etc. The data gets whown in Campaign/Audience Dashboard.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_ACT_METRICS_ALL_DENORM_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACT_METRICS_DENORM_ID
AMS_ACT_METRICS_ALL_DENORM_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
Columns
Name Datatype Length Mandatory Comments
ACT_METRICS_DENORM_ID NUMBER
Yes Primary Key
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
SECURITY_GROUP_ID NUMBER (15)
Security Group Id
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
METRIC_COLLECTION_DATE DATE
Yes Date at which metrics are collected
OBJECT_TYPE VARCHAR2 (30) Yes Object Type
OBJECT_ID NUMBER
Yes Object Id
LEADS NUMBER

Leads
TOP_LEADS NUMBER

Top Leads(A Leads)
TOP_LEADS_RATIO NUMBER

Top Leads Ratio
LEADS_ACCEPTED NUMBER

No. of Leads accepted in Sales pipeline
LEAD_ACCEPTANCE_RATE NUMBER

Lead Acceptance rate
DEAD_LEADS NUMBER

No. of dead Leads
DEAD_LEADS_RATIO NUMBER

Dead Leads Ratio
OPPORTUNITIES NUMBER

No. of Opportunities
OPPORTUNITIES_AMOUNT NUMBER

Opportunity Amount
LEADS_TO_OPPORTUNITY_RATE NUMBER

Lead to Opportunity Rate
QUOTES NUMBER

No. of Quotes
QUOTES_AMOUNT NUMBER

Quote Amount (in functional currency)
ORDERS NUMBER

No. of Orders
ORDERS_AMOUNT NUMBER

Order Amount in functional currency
BOOKED_REVENUE NUMBER

Booked Revenue in Functional Currency
INVOICED_REVENUE NUMBER

Invoiced Revenue in Functional Currency
BOOKED_REVENUE_PER_LEAD NUMBER

Booked Revenue Per Lead
INVOICED_REVENUE_PER_LEAD NUMBER

Invoiced Revenue
COST NUMBER

Cost
COST_PER_LEAD NUMBER

Cost per lead
BOOKED_ROI NUMBER

Booked ROI
INVOICED_ROI NUMBER

Invoiced ROI
TARGET_GROUP_SIZE NUMBER

Target Group SIze
RESPONSES NUMBER

No. of responses
CONTACT_GROUP_SIZE NUMBER

Contact Group
LEADS_FORECAST NUMBER

Forecast Value for Leads Metric
TOP_LEADS_FORECAST NUMBER

Forecast Value for Top Leads Metric
TOP_LEADS_RATIO_FORECAST NUMBER

Forecast value for Top Leads Ratio Metric
LEADS_ACCEPTED_FORECAST NUMBER

Forecast value for Leads Accepted Metric
LEADS_ACCEPTED_RATIO_FORECAST NUMBER

Forecast value for Leads Accepted Ration metric
DEAD_LEADS_FORECAST NUMBER

Forecast value for Dead Leads Metric
DEAD_LEADS_RATIO_FORECAST NUMBER

Forecast value for dead leads ratio metric
OPPORTUNITIES_FORECAST NUMBER

Forecast value for oportunities metric
OPPORTUNITIES_AMOUNT_FORECAST NUMBER

Forecast value for opportunities amount metric
LEAD_OPPORTUNITY_RATE_FORECAST NUMBER

Forecast value for Leads To Opportunity Rate Metric
QUOTES_FORECAST NUMBER

Forecast value for quotes metric
QUOTES_AMOUNT_FORECAST NUMBER

Forecast value for Quotes amount metric
ORDERS_FORECAST NUMBER

Forecast value for orders metric
ORDERS_AMOUNT_FORECAST NUMBER

Forecast value for orders amount metric
BOOKED_REVENUE_FORECAST NUMBER

Forecast value for booked revenue metric
INVOICED_REVENUE_FORECAST NUMBER

Forecast value for Invoiced revenue metric
BOOKED_REV_PER_LEAD_FORECAST NUMBER

Forecast value for Booked Revenues per lead metric
INVOICED_REV_PER_LEAD_FORECAST NUMBER

Forecast value for Invoiced revenue per lead metric
COST_FORECAST NUMBER

Forecast value for Cost metric
COST_PER_LEAD_FORECAST NUMBER

Forecast value for cost per lead metric
INVOICED_ROI_FORECAST NUMBER

Forecast value for Invoiced ROI metric
BOOKED_ROI_FORECAST NUMBER

Forecast value for Booked ROI Metric
TARGET_GROUP_SIZE_FORECAST NUMBER

Forecast value for Target Group Size Metric
RESPONSES_FORECAST NUMBER

Forecast value for Responses Metric
CONTACT_GROUP_SIZE_FORECAST NUMBER

Forecast value for contact group size metric
Query Text

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


SELECT ACT_METRICS_DENORM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      METRIC_COLLECTION_DATE
,      OBJECT_TYPE
,      OBJECT_ID
,      LEADS
,      TOP_LEADS
,      TOP_LEADS_RATIO
,      LEADS_ACCEPTED
,      LEAD_ACCEPTANCE_RATE
,      DEAD_LEADS
,      DEAD_LEADS_RATIO
,      OPPORTUNITIES
,      OPPORTUNITIES_AMOUNT
,      LEADS_TO_OPPORTUNITY_RATE
,      QUOTES
,      QUOTES_AMOUNT
,      ORDERS
,      ORDERS_AMOUNT
,      BOOKED_REVENUE
,      INVOICED_REVENUE
,      BOOKED_REVENUE_PER_LEAD
,      INVOICED_REVENUE_PER_LEAD
,      COST
,      COST_PER_LEAD
,      BOOKED_ROI
,      INVOICED_ROI
,      TARGET_GROUP_SIZE
,      RESPONSES
,      CONTACT_GROUP_SIZE
,      LEADS_FORECAST
,      TOP_LEADS_FORECAST
,      TOP_LEADS_RATIO_FORECAST
,      LEADS_ACCEPTED_FORECAST
,      LEADS_ACCEPTED_RATIO_FORECAST
,      DEAD_LEADS_FORECAST
,      DEAD_LEADS_RATIO_FORECAST
,      OPPORTUNITIES_FORECAST
,      OPPORTUNITIES_AMOUNT_FORECAST
,      LEAD_OPPORTUNITY_RATE_FORECAST
,      QUOTES_FORECAST
,      QUOTES_AMOUNT_FORECAST
,      ORDERS_FORECAST
,      ORDERS_AMOUNT_FORECAST
,      BOOKED_REVENUE_FORECAST
,      INVOICED_REVENUE_FORECAST
,      BOOKED_REV_PER_LEAD_FORECAST
,      INVOICED_REV_PER_LEAD_FORECAST
,      COST_FORECAST
,      COST_PER_LEAD_FORECAST
,      INVOICED_ROI_FORECAST
,      BOOKED_ROI_FORECAST
,      TARGET_GROUP_SIZE_FORECAST
,      RESPONSES_FORECAST
,      CONTACT_GROUP_SIZE_FORECAST
FROM AMS.AMS_ACT_METRICS_ALL_DENORM;

Dependencies

[top of page]

AMS.AMS_ACT_METRICS_ALL_DENORM does not reference any database object

AMS.AMS_ACT_METRICS_ALL_DENORM is referenced by following:

SchemaAMS
ViewAMS_ACT_METRICS_ALL_DENORM#