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_DM_BIC_STG#

Object Details

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

[View Source]

Columns

Name	Datatype	Mandatory
PARTY_ID	NUMBER	Yes
AVG_TALK_TIME	NUMBER
AVG_ORDER_AMOUNT	NUMBER
AVG_UNITS_PER_ORDER	NUMBER
TOT_ORDER_AMOUNT_YEAR	NUMBER
TOT_ORDER_AMOUNT_9_MONTHS	NUMBER
TOT_ORDER_AMOUNT_6_MONTHS	NUMBER
TOT_ORDER_AMOUNT_3_MONTHS	NUMBER
TOT_NUM_ORDERS_YEAR	NUMBER
TOT_NUM_ORDER_9_MONTHS	NUMBER
TOT_NUM_ORDER_6_MONTHS	NUMBER
TOT_NUM_ORDER_3_MONTHS	NUMBER
NUM_OF_SR_YEAR	NUMBER
NUM_OF_SR_6_MONTHS	NUMBER
NUM_OF_SR_3_MONTHS	NUMBER
NUM_OF_SR_1_MONTH	NUMBER
AVG_RESOLVE_DAYS_YEAR	NUMBER
AVG_RESOLVE_DAYS_6_MONTHS	NUMBER
AVG_RESOLVE_DAYS_3_MONTHS	NUMBER
AVG_RESOLVE_DAYS_1_MONTH	NUMBER
ORDER_LINES_DELIVERED	NUMBER
ORDER_LINES_ONTIME	NUMBER
ORDER_QTY_CUMUL	NUMBER
ORDER_RECENCY	NUMBER
PAYMENTS	NUMBER
RETURNS	NUMBER
RETURN_BY_VALUE	NUMBER
RETURN_BY_VALUE_PCT	NUMBER
ONTIME_PAYMENTS	NUMBER
ONTIME_SHIP_PCT	NUMBER
CLOSED_SRS	NUMBER
COGS	NUMBER
CONTRACTS_CUML	NUMBER
CONTRACT_AMT	NUMBER
CONTRACT_DURATION	NUMBER
INACTIVE_CONTRACTS	NUMBER
OPEN_CONTRACTS	NUMBER
NEW_CONTRACTS	NUMBER
RENEWED_CONTRACTS	NUMBER
ESCALATED_SRS	NUMBER
FIRST_CALL_CL_RATE	NUMBER
NUM_OF_COMPLAINTS	NUMBER
NUM_OF_INTERACTIONS	NUMBER
NUM_OF_TRANSFERS	NUMBER
OPEN_SRS	NUMBER
PCT_CALL_REWORK	NUMBER
PRODUCTS	NUMBER
REFERALS	NUMBER
REOPENED_SRS	NUMBER
SALES	NUMBER
TOTAL_SR_RESPONSE_TIME	NUMBER
PCT_FIRST_CLOSED_SRS	NUMBER
AVG_COMPLAINTS	NUMBER
AVG_HOLD_TIME	NUMBER
AVG_LEN_OF_EMP	NUMBER
AVG_TRANSFERS_PER_SR	NUMBER
AVG_WORKLOAD	NUMBER
TOT_CALLS	NUMBER
CALL_LENGTH	NUMBER
PROFITABILITY	NUMBER

Query Text

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


SELECT PARTY_ID
,      AVG_TALK_TIME
,      AVG_ORDER_AMOUNT
,      AVG_UNITS_PER_ORDER
,      TOT_ORDER_AMOUNT_YEAR
,      TOT_ORDER_AMOUNT_9_MONTHS
,      TOT_ORDER_AMOUNT_6_MONTHS
,      TOT_ORDER_AMOUNT_3_MONTHS
,      TOT_NUM_ORDERS_YEAR
,      TOT_NUM_ORDER_9_MONTHS
,      TOT_NUM_ORDER_6_MONTHS
,      TOT_NUM_ORDER_3_MONTHS
,      NUM_OF_SR_YEAR
,      NUM_OF_SR_6_MONTHS
,      NUM_OF_SR_3_MONTHS
,      NUM_OF_SR_1_MONTH
,      AVG_RESOLVE_DAYS_YEAR
,      AVG_RESOLVE_DAYS_6_MONTHS
,      AVG_RESOLVE_DAYS_3_MONTHS
,      AVG_RESOLVE_DAYS_1_MONTH
,      ORDER_LINES_DELIVERED
,      ORDER_LINES_ONTIME
,      ORDER_QTY_CUMUL
,      ORDER_RECENCY
,      PAYMENTS
,      RETURNS
,      RETURN_BY_VALUE
,      RETURN_BY_VALUE_PCT
,      ONTIME_PAYMENTS
,      ONTIME_SHIP_PCT
,      CLOSED_SRS
,      COGS
,      CONTRACTS_CUML
,      CONTRACT_AMT
,      CONTRACT_DURATION
,      INACTIVE_CONTRACTS
,      OPEN_CONTRACTS
,      NEW_CONTRACTS
,      RENEWED_CONTRACTS
,      ESCALATED_SRS
,      FIRST_CALL_CL_RATE
,      NUM_OF_COMPLAINTS
,      NUM_OF_INTERACTIONS
,      NUM_OF_TRANSFERS
,      OPEN_SRS
,      PCT_CALL_REWORK
,      PRODUCTS
,      REFERALS
,      REOPENED_SRS
,      SALES
,      TOTAL_SR_RESPONSE_TIME
,      PCT_FIRST_CLOSED_SRS
,      AVG_COMPLAINTS
,      AVG_HOLD_TIME
,      AVG_LEN_OF_EMP
,      AVG_TRANSFERS_PER_SR
,      AVG_WORKLOAD
,      TOT_CALLS
,      CALL_LENGTH
,      PROFITABILITY
FROM AMS.AMS_DM_BIC_STG#;

Dependencies

[top of page]

AMS.AMS_DM_BIC_STG# references the following:

AMS: AMS_DM_BIC_STG

AMS.AMS_DM_BIC_STG# is referenced by following:

APPS: AMS_DM_BIC_STG