[Home] [Help] [Dependency Information]
Object Name: | BIX_DM_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | BIX |
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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEDIA_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
CLASSIFICATION_ID | NUMBER | |||
SERVER_GROUP_ID | NUMBER | |||
DNIS | NUMBER | |||
OUTCOME_ID | NUMBER | |||
PERIOD_START_DATE | DATE | |||
PERIOD_START_TIME | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PERIOD_START_DATE_TIME | DATE | |||
CALLS_OFFERED | NUMBER | |||
CALLS_IN_QUEUE | NUMBER | |||
IN_CALLS_HANDLED | NUMBER | |||
CALLS_TRANSFERED | NUMBER | |||
CALLS_ABANDONED | NUMBER | |||
OUT_CALLS_HANDLED | NUMBER | |||
IVR_TIME | NUMBER | |||
ROUTE_TIME | NUMBER | |||
QUEUE_TIME | NUMBER | |||
IN_TALK_TIME | NUMBER | |||
IN_WRAP_TIME | NUMBER | |||
ABANDON_TIME | NUMBER | |||
OUT_TALK_TIME | NUMBER | |||
OUT_WRAP_TIME | NUMBER | |||
CAMPAIGN_ID | NUMBER | |||
CAMPAIGN_SCHEDULE_ID | NUMBER | |||
SOURCE_LIST_ID | NUMBER | |||
SUBLIST_ID | NUMBER | |||
DIRECTION | NUMBER | |||
LEADS_AMOUNT | NUMBER | |||
OPPORTUNITIES_WON_AMOUNT | NUMBER | |||
LEADS_AMOUNT_TXN | NUMBER | |||
OPPORTUNITIES_WON_AMOUNT_TXN | NUMBER | |||
SERVICE_REQUESTS_CREATED | NUMBER | |||
SERVICE_REQUESTS_CLOSED | NUMBER | |||
LEADS_CREATED | NUMBER | |||
LEADS_UPDATED | NUMBER | |||
OPPORTUNITIES_CREATED | NUMBER | |||
OPPORTUNITIES_UPDATED | NUMBER | |||
OPPORTUNITIES_WON | NUMBER | |||
SERVICE_REQUESTS_OPENED | NUMBER | |||
SERVICE_REQUESTS_INFO_REQ | NUMBER | |||
SERVICE_REQUESTS_KB_UPDATES | NUMBER | |||
SERVICE_REQUESTS_CONTACT_CL | NUMBER | |||
OPPORTUNITIES_CROSS_SOLD | NUMBER | |||
OPPORTUNITIES_UP_SOLD | NUMBER | |||
OPPORTUNITIES_DECLINED | NUMBER | |||
OPPORTUNITIES_LOST | NUMBER | |||
LEADS_CONV_TO_OPP | NUMBER | |||
ROW_TYPE | VARCHAR2 | (1) | ||
IN_CALLS_HANDLD_GT_THN_X_TIME | NUMBER | |||
OUT_CALLS_HANDLD_GT_THN_X_TIME | NUMBER | |||
CALLS_ANSWRD_WITHIN_X_TIME | NUMBER | |||
QUEUE_TIME_FOR_CALLS_HANDLED | NUMBER | |||
NUMBER_OF_REROUTS | NUMBER | |||
OUT_PREVIEW_TIME | NUMBER | OUT_PREVIEW_TIME | ||
OUT_CONTACT_HANDLE_TIME | NUMBER | OUT_CONTACT_HANDLE_TIME | ||
OUT_CALLS_DIALED | NUMBER | OUT_CALLS_DIALED | ||
OUT_CONNECT_COUNT | NUMBER | OUT_CONNECT_COUNT | ||
OUT_NON_CONNECT_COUNT | NUMBER | OUT_NON_CONNECT_COUNT | ||
OUT_CONTACT_COUNT | NUMBER | OUT_CONTACT_COUNT | ||
OUT_NON_CONTACT_COUNT | NUMBER | OUT_NON_CONTACT_COUNT | ||
OUT_POSITIVE_RESPONSE_COUNT | NUMBER | OUT_POSITIVE_RESPONSE_COUNT | ||
OUT_BUSY_COUNT | NUMBER | OUT_BUSY_COUNT | ||
OUT_ABANDON_COUNT | NUMBER | OUT_ABANDON_COUNT | ||
OUT_RING_NOANSWER_COUNT | NUMBER | OUT_RING_NOANSWER_COUNT | ||
OUT_ANS_MC_COUNT | NUMBER | OUT_ANS_MC_COUNT | ||
OUT_SIT_COUNT | NUMBER | OUT_SIT_COUNT | ||
OUT_OTHER_OUTCOME_COUNT | NUMBER | OUT_OTHER_OUTCOME_COUNT | ||
RESULT_ID | NUMBER | RESULT_ID | ||
REASON_ID | NUMBER | REASON_ID | ||
CLASSIFICATION_VALUE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT MEDIA_ID
, RESOURCE_ID
, CLASSIFICATION_ID
, SERVER_GROUP_ID
, DNIS
, OUTCOME_ID
, PERIOD_START_DATE
, PERIOD_START_TIME
, CURRENCY_CODE
, PERIOD_START_DATE_TIME
, CALLS_OFFERED
, CALLS_IN_QUEUE
, IN_CALLS_HANDLED
, CALLS_TRANSFERED
, CALLS_ABANDONED
, OUT_CALLS_HANDLED
, IVR_TIME
, ROUTE_TIME
, QUEUE_TIME
, IN_TALK_TIME
, IN_WRAP_TIME
, ABANDON_TIME
, OUT_TALK_TIME
, OUT_WRAP_TIME
, CAMPAIGN_ID
, CAMPAIGN_SCHEDULE_ID
, SOURCE_LIST_ID
, SUBLIST_ID
, DIRECTION
, LEADS_AMOUNT
, OPPORTUNITIES_WON_AMOUNT
, LEADS_AMOUNT_TXN
, OPPORTUNITIES_WON_AMOUNT_TXN
, SERVICE_REQUESTS_CREATED
, SERVICE_REQUESTS_CLOSED
, LEADS_CREATED
, LEADS_UPDATED
, OPPORTUNITIES_CREATED
, OPPORTUNITIES_UPDATED
, OPPORTUNITIES_WON
, SERVICE_REQUESTS_OPENED
, SERVICE_REQUESTS_INFO_REQ
, SERVICE_REQUESTS_KB_UPDATES
, SERVICE_REQUESTS_CONTACT_CL
, OPPORTUNITIES_CROSS_SOLD
, OPPORTUNITIES_UP_SOLD
, OPPORTUNITIES_DECLINED
, OPPORTUNITIES_LOST
, LEADS_CONV_TO_OPP
, ROW_TYPE
, IN_CALLS_HANDLD_GT_THN_X_TIME
, OUT_CALLS_HANDLD_GT_THN_X_TIME
, CALLS_ANSWRD_WITHIN_X_TIME
, QUEUE_TIME_FOR_CALLS_HANDLED
, NUMBER_OF_REROUTS
, OUT_PREVIEW_TIME
, OUT_CONTACT_HANDLE_TIME
, OUT_CALLS_DIALED
, OUT_CONNECT_COUNT
, OUT_NON_CONNECT_COUNT
, OUT_CONTACT_COUNT
, OUT_NON_CONTACT_COUNT
, OUT_POSITIVE_RESPONSE_COUNT
, OUT_BUSY_COUNT
, OUT_ABANDON_COUNT
, OUT_RING_NOANSWER_COUNT
, OUT_ANS_MC_COUNT
, OUT_SIT_COUNT
, OUT_OTHER_OUTCOME_COUNT
, RESULT_ID
, REASON_ID
, CLASSIFICATION_VALUE_ID
FROM BIX.BIX_DM_INTERFACE;
BIX.BIX_DM_INTERFACE does not reference any database object
BIX.BIX_DM_INTERFACE is referenced by following:
|
|
|