[Home] [Help] [Dependency Information]
Object Name: | BIX_SERVER_IB |
---|---|
Object Type: | TABLE |
Owner: | BIX |
FND Design Data: | BIX.BIX_SERVER_IB |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIX_SERVER_IB_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | MINUTE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_IB_ID | VARCHAR2 | (240) | Yes | Primary Key |
MINUTE | DATE | Time to the minute | ||
SITE_ID | NUMBER | Site ID | ||
MEDIA_ITEM_TYPE | VARCHAR2 | (240) | Media type | |
LOS_CATEGORY_ID | NUMBER | category ID | ||
NUMBER_OF_ITEMS_QUEUED | NUMBER | number of items queued | ||
NUMBER_OF_ITEMS_SERVICED | NUMBER | number of items serviced | ||
ITEMS_SERVICED_WITHIN_LOS | NUMBER | item serviced | ||
ITEMS_NOT_SERVICED_WITHIN_LOS | NUMBER | items not services | ||
NUMBER_AGENTS_WORKING | NUMBER | Number of agents working in this media, los | ||
MINIMUM_NUMBER_OF_AGENTS_REQ | NUMBER | minimum number of agent request | ||
LOS_CATEGORY_DIRECTION | NUMBER | category direction | ||
ITEMS_LEFT_TO_BE_SERVICED | NUMBER | items left to be serviced | ||
ITEMS_SERVICED_TODAY | NUMBER | items serviced today | ||
SECURITY_GROUP_ID | NUMBER | column for CRM hosting |
Cut, paste (and edit) the following text to query this object:
SELECT SERVER_IB_ID
, MINUTE
, SITE_ID
, MEDIA_ITEM_TYPE
, LOS_CATEGORY_ID
, NUMBER_OF_ITEMS_QUEUED
, NUMBER_OF_ITEMS_SERVICED
, ITEMS_SERVICED_WITHIN_LOS
, ITEMS_NOT_SERVICED_WITHIN_LOS
, NUMBER_AGENTS_WORKING
, MINIMUM_NUMBER_OF_AGENTS_REQ
, LOS_CATEGORY_DIRECTION
, ITEMS_LEFT_TO_BE_SERVICED
, ITEMS_SERVICED_TODAY
, SECURITY_GROUP_ID
FROM BIX.BIX_SERVER_IB;
BIX.BIX_SERVER_IB does not reference any database object
BIX.BIX_SERVER_IB is referenced by following:
|
|
|