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

Object Details

Object Name:	AMS_DM_BIC_STG
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DM_BIC_STG
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_BIC_STG_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PARTY_ID

Columns

Name	Datatype	Mandatory	Comments
PARTY_ID	NUMBER	Yes	Column used to join with AMS_DM_DRV_STG.
AVG_TALK_TIME	NUMBER		Average talk time.
AVG_ORDER_AMOUNT	NUMBER		Average order amount.
AVG_UNITS_PER_ORDER	NUMBER		Average units per order.
TOT_ORDER_AMOUNT_YEAR	NUMBER		Total order amount in a the past year.
TOT_ORDER_AMOUNT_9_MONTHS	NUMBER		Total order amount in the past 9 months.
TOT_ORDER_AMOUNT_6_MONTHS	NUMBER		Total order amount in the past 6 months.
TOT_ORDER_AMOUNT_3_MONTHS	NUMBER		Total order amount in the past 3 months.
TOT_NUM_ORDERS_YEAR	NUMBER		Total number of orders in the past year.
TOT_NUM_ORDER_9_MONTHS	NUMBER		Total number of orders in the past 9 months.
TOT_NUM_ORDER_6_MONTHS	NUMBER		Total number of orders in the past 6 months.
TOT_NUM_ORDER_3_MONTHS	NUMBER		Total number of orders in the past 3 months.
NUM_OF_SR_YEAR	NUMBER		Number of service requests in the past year.
NUM_OF_SR_6_MONTHS	NUMBER		Number of service requests in the past 6 months.
NUM_OF_SR_3_MONTHS	NUMBER		Number of service requests in the past 3 months.
NUM_OF_SR_1_MONTH	NUMBER		Number of service requests in the past month.
AVG_RESOLVE_DAYS_YEAR	NUMBER		Average days for resolution in the past year.
AVG_RESOLVE_DAYS_6_MONTHS	NUMBER		Average days for resolution in the past 6 months.
AVG_RESOLVE_DAYS_3_MONTHS	NUMBER		Average days for resolution in the past 3 months.
AVG_RESOLVE_DAYS_1_MONTH	NUMBER		Average days for resolution in the past month.
ORDER_LINES_DELIVERED	NUMBER		Number of order lines delivered.
ORDER_LINES_ONTIME	NUMBER		Number of order lines delivered on time.
ORDER_QTY_CUMUL	NUMBER		Cumulative order quantity.
ORDER_RECENCY	NUMBER		Order recency.
PAYMENTS	NUMBER		Number of payments.
RETURNS	NUMBER		Number of returns.
RETURN_BY_VALUE	NUMBER		Return by value.
RETURN_BY_VALUE_PCT	NUMBER		Return by percentage of value.
ONTIME_PAYMENTS	NUMBER		Number of on time payments.
ONTIME_SHIP_PCT	NUMBER		On time ship percentage.
CLOSED_SRS	NUMBER		Number of closed service requests.
COGS	NUMBER		Cost of goods.
CONTRACTS_CUML	NUMBER		Cumulative number of contracts.
CONTRACT_AMT	NUMBER		Contract amount.
CONTRACT_DURATION	NUMBER		Duration of contract.
INACTIVE_CONTRACTS	NUMBER		Number of inactive contracts.
OPEN_CONTRACTS	NUMBER		Open contracts.
NEW_CONTRACTS	NUMBER		New contracts.
RENEWED_CONTRACTS	NUMBER		Renewed contracts/
ESCALATED_SRS	NUMBER		Escalated service requests.
FIRST_CALL_CL_RATE	NUMBER		First call close rate.
NUM_OF_COMPLAINTS	NUMBER		Number of complaints.
NUM_OF_INTERACTIONS	NUMBER		Number of interactions.
NUM_OF_TRANSFERS	NUMBER		Number of call transfers.
OPEN_SRS	NUMBER		Open service requests.
PCT_CALL_REWORK	NUMBER		Percentage of calls reworked.
PRODUCTS	NUMBER		Products.
REFERALS	NUMBER		Referrals.
REOPENED_SRS	NUMBER		Re-opened service requests.
SALES	NUMBER		Sales.
TOTAL_SR_RESPONSE_TIME	NUMBER		Total service request response time.
PCT_FIRST_CLOSED_SRS	NUMBER		Percentage of first closed service requests.
AVG_COMPLAINTS	NUMBER		Average number of complaints.
AVG_HOLD_TIME	NUMBER		Average hold time.
AVG_LEN_OF_EMP	NUMBER		Average length of employment.
AVG_TRANSFERS_PER_SR	NUMBER		Average number of transfer per service request.
AVG_WORKLOAD	NUMBER		Average workload.
TOT_CALLS	NUMBER		Total calls.
CALL_LENGTH	NUMBER		Call length.
PROFITABILITY	NUMBER		Profitability.

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 does not reference any database object

AMS.AMS_DM_BIC_STG is referenced by following:

AMS: AMS_DM_BIC_STG#