DBA Data[Home] [Help] [Dependency Information]

TABLE: BIC.BIC_PARTY_SUMM

Object Details
Object Name: BIC_PARTY_SUMM
Object Type: TABLE
Owner: BIC
FND Design Data: TableBIC.BIC_PARTY_SUMM
Subobject Name:
Status: VALID


From Customer Summary table, the rows are transposed as columns for matrix reporting. i.e., Flattened table for org striped measures.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIC_PARTY_SUMM_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERIOD_START_DATE
ColumnPARTY_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
PERIOD_START_DATE DATE
Yes Period Start Date
PARTY_ID NUMBER
Yes FK to Hz_Parties
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER

Organization identifier
LOYALTY NUMBER

Loyalty
SATISFACTION NUMBER

Satisfaction
SF_BILLING NUMBER

Satisfaction's sub-measure : Billing
SF_CONTRACT NUMBER

Satisfaction's sub-measure : Contract
SF_QUALITY NUMBER

Satisfaction's sub-measure : Quality
SF_SERVICE NUMBER

Satisfaction's sub-measure : Service
SF_SHIPMENT NUMBER

Satisfaction's sub-measure : Shipment
ORDER_AMT NUMBER

Order Amount
ORDER_LINES_DELIVERED NUMBER

Order Lines Delivered
ORDER_LINES_ONTIME NUMBER

Order Lines Ontime
ORDER_NUM NUMBER

Order Number
ORDER_QTY NUMBER

Order Quantity
ORDER_QTY_CUML NUMBER

Order Quantity Cumulative
ORDER_RECENCY NUMBER

How recent is this order
PAYMENTS NUMBER

Payments
RETURNS NUMBER

Returns
RETURN_BY_VALUE NUMBER

Return by Value
RETURN_BY_VALUE_PCT NUMBER

Return by Value percent
RETURN_QTY NUMBER

Return Quantity
PCT_RETURN_QTY NUMBER

Pct Return Quantity
OL_DEL_VALUE NUMBER

Del Value
OL_ONTIME_VALUE NUMBER

On time value
ONTIME_PAYMENTS NUMBER

On time payments
ONTIME_SHIP_PCT NUMBER

On time shipment percent
ONTIME_VALUE_PCT NUMBER

on time value percent
ON_TIME_PAYMENT_RATE NUMBER

on time payment rate
ASSOCIATION_YRS NUMBER

Association years
CLOSED_SRS NUMBER

Closed Service Requests
COGS NUMBER

Cost of Goods
CONTRACTS_CUML NUMBER

Contracts
CONTRACT_AMT NUMBER

Contract Amount
CONTRACT_DURATION NUMBER

Contract Duration
INACTIVE_CONTRACTS NUMBER

Inactive Contracts
OPEN_CONTRACTS NUMBER

Open Contracts
NEW_CONTRACTS NUMBER

New Contracts
RENEWED_CONTRACTS NUMBER

Renewed Contracts
ESC_SRS NUMBER

Escalated Service Requests
FIRST_CALL_CL_RATE NUMBER

First Call Rate
INTERACTIONS NUMBER

Interactions
INTERAC_CUML NUMBER

Total Interactions
NO_OF_COMPLAINTS NUMBER

Number of Complaints
NO_OF_INTERACTIONS NUMBER

Number of Interactions
NO_OF_TRANSFERS NUMBER

Number of Transfers
OPEN_SRS NUMBER

Open Service Requests
PCT_ESC_SRS NUMBER

Escalated Service Requests
PCT_REOPENED_SRS NUMBER

Reopened Service Requests
PERCT_CALL_REWORK NUMBER

Call rework
PRODUCTS NUMBER

Products
REFERALS NUMBER

Referals
REOPENED_SRS NUMBER

Reopened Service Requests
SALES NUMBER

Sales
SRS_LOGGED NUMBER

Service Requests Logged
SR_CLOSED_INT NUMBER

Closed Service Requests
TOTAL_HOLD_TIME NUMBER

Total hold time
TOTAL_LEN_OF_EMP NUMBER

Total len of Employee
TOTAL_SR_RESL_TIME NUMBER

Total Service Request Resolution time
TOTAL_SR_RESPONSE_TIME NUMBER

Total Service Request Response time
AVG_CLOSED_SRS NUMBER

Average Closed Service Requests
AVG_COMPLAINTS NUMBER

Average Complaints
AVG_HOLD_TIME NUMBER

Average Hold time
AVG_INTERACTIONS NUMBER

Average Interactions
AVG_INTERACTIONS_PER_SR NUMBER

Average Interactions per Service request
AVG_LEN_OF_EMP NUMBER

Average Len of Employee
AVG_OUTSTANDING_SRS NUMBER

Average Outstanding Service Requests
AVG_PERIOD_FOR_ACTIVE_CONT NUMBER

Average Period for Active Contracts
AVG_SRS_LOGGED NUMBER

Average Service Requests Logged
AVG_SR_RESL_TIME NUMBER

Average Service Request resolution time
AVG_SR_RESPONSE_TIME NUMBER

Average Service request Response time
AVG_TALK_TIME NUMBER

Average talk time
AVG_TRANSFERS_BEF_RESL NUMBER

Average transfers before resolution
AVG_TRANSFERS_PER_SR NUMBER

Average transfers per Service Request
AVG_WORKLOAD NUMBER

Average workload
CALLS NUMBER

Calls
CALL_LENGTH NUMBER

Call Length
CALL_TYPE_INTERACTIONS NUMBER

Call type Interactions
MARKET_SEGMENT_ID NUMBER

Id of Marget Segment
PROFITABILITY NUMBER

Profitability
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
SECURITY_GROUP_ID NUMBER (15)
Security Group id
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 does not reference any database object

BIC.BIC_PARTY_SUMM is referenced by following:

SchemaBIC
ViewBIC_PARTY_SUMM#