[Home] [Help] [Dependency Information]
Object Name: | BIC_PARTY_SUMM |
---|---|
Object Type: | TABLE |
Owner: | BIC |
FND Design Data: | BIC.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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIC_PARTY_SUMM_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERIOD_START_DATE
PARTY_ID ORG_ID |
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 |
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;
BIC.BIC_PARTY_SUMM does not reference any database object
BIC.BIC_PARTY_SUMM is referenced by following:
|
|
|