Skip to content

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 Comments
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:

SchemaAMS
TableAMS_ACT_METRICS_ALL_DENORM
AMS.AMS_ACT_METRICS_ALL_DENORM# is referenced by following:

SchemaAPPS
SynonymAMS_ACT_METRICS_ALL_DENORM