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]

TABLE: AMS.AMS_DM_BIC_STG_GT

Object Details

Object Name:	AMS_DM_BIC_STG_GT
Object Type:	TABLE
Owner:	AMS
Subobject Name:
Status:	VALID

Temporary Table Details

AMS.AMS_DM_BIC_STG_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_BIC_STG_GT_U1	NORMAL	UNIQUE		PARTY_ID

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_GT;

Dependencies

[top of page]

AMS.AMS_DM_BIC_STG_GT does not reference any database object

AMS.AMS_DM_BIC_STG_GT is referenced by following:

APPS: AMS_DM_BIC_STG_GT