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: BIC.BIC_PARTY_SUMM#

Object Details

Object Name:	BIC_PARTY_SUMM#
Object Type:	VIEW
Owner:	BIC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PERIOD_START_DATE	DATE		Yes
PARTY_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATED_BY	NUMBER		Yes
ORG_ID	NUMBER
LOYALTY	NUMBER
SATISFACTION	NUMBER
SF_BILLING	NUMBER
SF_CONTRACT	NUMBER
SF_QUALITY	NUMBER
SF_SERVICE	NUMBER
SF_SHIPMENT	NUMBER
ORDER_AMT	NUMBER
ORDER_LINES_DELIVERED	NUMBER
ORDER_LINES_ONTIME	NUMBER
ORDER_NUM	NUMBER
ORDER_QTY	NUMBER
ORDER_QTY_CUML	NUMBER
ORDER_RECENCY	NUMBER
PAYMENTS	NUMBER
RETURNS	NUMBER
RETURN_BY_VALUE	NUMBER
RETURN_BY_VALUE_PCT	NUMBER
RETURN_QTY	NUMBER
PCT_RETURN_QTY	NUMBER
OL_DEL_VALUE	NUMBER
OL_ONTIME_VALUE	NUMBER
ONTIME_PAYMENTS	NUMBER
ONTIME_SHIP_PCT	NUMBER
ONTIME_VALUE_PCT	NUMBER
ON_TIME_PAYMENT_RATE	NUMBER
ASSOCIATION_YRS	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
ESC_SRS	NUMBER
FIRST_CALL_CL_RATE	NUMBER
INTERACTIONS	NUMBER
INTERAC_CUML	NUMBER
NO_OF_COMPLAINTS	NUMBER
NO_OF_INTERACTIONS	NUMBER
NO_OF_TRANSFERS	NUMBER
OPEN_SRS	NUMBER
PCT_ESC_SRS	NUMBER
PCT_REOPENED_SRS	NUMBER
PERCT_CALL_REWORK	NUMBER
PRODUCTS	NUMBER
REFERALS	NUMBER
REOPENED_SRS	NUMBER
SALES	NUMBER
SRS_LOGGED	NUMBER
SR_CLOSED_INT	NUMBER
TOTAL_HOLD_TIME	NUMBER
TOTAL_LEN_OF_EMP	NUMBER
TOTAL_SR_RESL_TIME	NUMBER
TOTAL_SR_RESPONSE_TIME	NUMBER
AVG_CLOSED_SRS	NUMBER
AVG_COMPLAINTS	NUMBER
AVG_HOLD_TIME	NUMBER
AVG_INTERACTIONS	NUMBER
AVG_INTERACTIONS_PER_SR	NUMBER
AVG_LEN_OF_EMP	NUMBER
AVG_OUTSTANDING_SRS	NUMBER
AVG_PERIOD_FOR_ACTIVE_CONT	NUMBER
AVG_SRS_LOGGED	NUMBER
AVG_SR_RESL_TIME	NUMBER
AVG_SR_RESPONSE_TIME	NUMBER
AVG_TALK_TIME	NUMBER
AVG_TRANSFERS_BEF_RESL	NUMBER
AVG_TRANSFERS_PER_SR	NUMBER
AVG_WORKLOAD	NUMBER
CALLS	NUMBER
CALL_LENGTH	NUMBER
CALL_TYPE_INTERACTIONS	NUMBER
MARKET_SEGMENT_ID	NUMBER
PROFITABILITY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
SECURITY_GROUP_ID	NUMBER	(15)

Query Text

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


SELECT PERIOD_START_DATE
,      PARTY_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      ORG_ID
,      LOYALTY
,      SATISFACTION
,      SF_BILLING
,      SF_CONTRACT
,      SF_QUALITY
,      SF_SERVICE
,      SF_SHIPMENT
,      ORDER_AMT
,      ORDER_LINES_DELIVERED
,      ORDER_LINES_ONTIME
,      ORDER_NUM
,      ORDER_QTY
,      ORDER_QTY_CUML
,      ORDER_RECENCY
,      PAYMENTS
,      RETURNS
,      RETURN_BY_VALUE
,      RETURN_BY_VALUE_PCT
,      RETURN_QTY
,      PCT_RETURN_QTY
,      OL_DEL_VALUE
,      OL_ONTIME_VALUE
,      ONTIME_PAYMENTS
,      ONTIME_SHIP_PCT
,      ONTIME_VALUE_PCT
,      ON_TIME_PAYMENT_RATE
,      ASSOCIATION_YRS
,      CLOSED_SRS
,      COGS
,      CONTRACTS_CUML
,      CONTRACT_AMT
,      CONTRACT_DURATION
,      INACTIVE_CONTRACTS
,      OPEN_CONTRACTS
,      NEW_CONTRACTS
,      RENEWED_CONTRACTS
,      ESC_SRS
,      FIRST_CALL_CL_RATE
,      INTERACTIONS
,      INTERAC_CUML
,      NO_OF_COMPLAINTS
,      NO_OF_INTERACTIONS
,      NO_OF_TRANSFERS
,      OPEN_SRS
,      PCT_ESC_SRS
,      PCT_REOPENED_SRS
,      PERCT_CALL_REWORK
,      PRODUCTS
,      REFERALS
,      REOPENED_SRS
,      SALES
,      SRS_LOGGED
,      SR_CLOSED_INT
,      TOTAL_HOLD_TIME
,      TOTAL_LEN_OF_EMP
,      TOTAL_SR_RESL_TIME
,      TOTAL_SR_RESPONSE_TIME
,      AVG_CLOSED_SRS
,      AVG_COMPLAINTS
,      AVG_HOLD_TIME
,      AVG_INTERACTIONS
,      AVG_INTERACTIONS_PER_SR
,      AVG_LEN_OF_EMP
,      AVG_OUTSTANDING_SRS
,      AVG_PERIOD_FOR_ACTIVE_CONT
,      AVG_SRS_LOGGED
,      AVG_SR_RESL_TIME
,      AVG_SR_RESPONSE_TIME
,      AVG_TALK_TIME
,      AVG_TRANSFERS_BEF_RESL
,      AVG_TRANSFERS_PER_SR
,      AVG_WORKLOAD
,      CALLS
,      CALL_LENGTH
,      CALL_TYPE_INTERACTIONS
,      MARKET_SEGMENT_ID
,      PROFITABILITY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM BIC.BIC_PARTY_SUMM#;

Dependencies

[top of page]

BIC.BIC_PARTY_SUMM# references the following:

BIC: BIC_PARTY_SUMM

BIC.BIC_PARTY_SUMM# is referenced by following:

APPS: BIC_PARTY_SUMM