eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: AMS.AMS_ACT_METRICS_ALL_DENORM#

Object Details

Object Name:	AMS_ACT_METRICS_ALL_DENORM#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACT_METRICS_DENORM_ID	NUMBER		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
METRIC_COLLECTION_DATE	DATE		Yes
OBJECT_TYPE	VARCHAR2	(30)	Yes
OBJECT_ID	NUMBER		Yes
LEADS	NUMBER
TOP_LEADS	NUMBER
TOP_LEADS_RATIO	NUMBER
LEADS_ACCEPTED	NUMBER
LEAD_ACCEPTANCE_RATE	NUMBER
DEAD_LEADS	NUMBER
DEAD_LEADS_RATIO	NUMBER
OPPORTUNITIES	NUMBER
OPPORTUNITIES_AMOUNT	NUMBER
LEADS_TO_OPPORTUNITY_RATE	NUMBER
QUOTES	NUMBER
QUOTES_AMOUNT	NUMBER
ORDERS	NUMBER
ORDERS_AMOUNT	NUMBER
BOOKED_REVENUE	NUMBER
INVOICED_REVENUE	NUMBER
BOOKED_REVENUE_PER_LEAD	NUMBER
INVOICED_REVENUE_PER_LEAD	NUMBER
COST	NUMBER
COST_PER_LEAD	NUMBER
BOOKED_ROI	NUMBER
INVOICED_ROI	NUMBER
TARGET_GROUP_SIZE	NUMBER
RESPONSES	NUMBER
CONTACT_GROUP_SIZE	NUMBER
LEADS_FORECAST	NUMBER
TOP_LEADS_FORECAST	NUMBER
TOP_LEADS_RATIO_FORECAST	NUMBER
LEADS_ACCEPTED_FORECAST	NUMBER
LEADS_ACCEPTED_RATIO_FORECAST	NUMBER
DEAD_LEADS_FORECAST	NUMBER
DEAD_LEADS_RATIO_FORECAST	NUMBER
OPPORTUNITIES_FORECAST	NUMBER
OPPORTUNITIES_AMOUNT_FORECAST	NUMBER
LEAD_OPPORTUNITY_RATE_FORECAST	NUMBER
QUOTES_FORECAST	NUMBER
QUOTES_AMOUNT_FORECAST	NUMBER
ORDERS_FORECAST	NUMBER
ORDERS_AMOUNT_FORECAST	NUMBER
BOOKED_REVENUE_FORECAST	NUMBER
INVOICED_REVENUE_FORECAST	NUMBER
BOOKED_REV_PER_LEAD_FORECAST	NUMBER
INVOICED_REV_PER_LEAD_FORECAST	NUMBER
COST_FORECAST	NUMBER
COST_PER_LEAD_FORECAST	NUMBER
INVOICED_ROI_FORECAST	NUMBER
BOOKED_ROI_FORECAST	NUMBER
TARGET_GROUP_SIZE_FORECAST	NUMBER
RESPONSES_FORECAST	NUMBER
CONTACT_GROUP_SIZE_FORECAST	NUMBER

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

AMS: AMS_ACT_METRICS_ALL_DENORM

AMS.AMS_ACT_METRICS_ALL_DENORM# is referenced by following:

APPS: AMS_ACT_METRICS_ALL_DENORM