Skip to content

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

SchemaAMS
TableAMS_DM_BIC_STG
AMS.AMS_DM_BIC_STG# is referenced by following:

SchemaAPPS
SynonymAMS_DM_BIC_STG