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

TABLE: IEX.IEX_DLN_UWQ_SUMMARY

Object Details
Object Name: IEX_DLN_UWQ_SUMMARY
Object Type: TABLE
Owner: IEX
Subobject Name:
Status: VALID


Summary table for universal work queue collections nodes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEX_DLN_UWQ_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_USE_ID
IEX_DLN_UWQ_SUMMARY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLLECTOR_ID
IEX_DLN_UWQ_SUMMARY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLLECTOR_RESOURCE_ID
IEX_DLN_UWQ_SUMMARY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
IEX_DLN_UWQ_SUMMARY_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWKITEM_RESOURCE_ID
IEX_DLN_UWQ_SUMMARY_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
IEX_DLN_UWQ_SUMMARY_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
DLN_UWQ_SUMMARY_ID NUMBER

Delinqueny UWQ Summary ID
ORG_ID NUMBER

ORG ID
COLLECTOR_ID NUMBER

Collector ID
COLLECTOR_RESOURCE_ID NUMBER

Collector Resource ID
COLLECTOR_RES_TYPE VARCHAR2 (30)
Colletors Resource Type
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU Object Function
IEU_OBJECT_PARAMETERS VARCHAR2 (2020)
IEU Object Parameters
IEU_MEDIA_TYPE_UUID VARCHAR2 (10)
Media Type UUID
IEU_PARAM_PK_COL VARCHAR2 (40)
Parameter Primary Key Column
IEU_PARAM_PK_VALUE VARCHAR2 (40)
IEU Parameter primary key value
RESOURCE_ID NUMBER

Resource ID
RESOURCE_TYPE VARCHAR2 (11)
Resource Type
PARTY_ID NUMBER

Party ID
PARTY_NAME VARCHAR2 (360)
Party Name
CUST_ACCOUNT_ID NUMBER

Account ID
ACCOUNT_NAME VARCHAR2 (240)
Account Name
ACCOUNT_NUMBER VARCHAR2 (30)
Account Number
SITE_USE_ID NUMBER

Site Use ID
LOCATION VARCHAR2 (60)
Location
CURRENCY VARCHAR2 (20)
Currency
OP_INVOICES_COUNT NUMBER

Invoice Count
OP_DEBIT_MEMOS_COUNT NUMBER

Debit Memo Count
OP_DEPOSITS_COUNT NUMBER

Deposit Count
OP_BILLS_RECEIVABLES_COUNT NUMBER

Bills Receivable Count
OP_CHARGEBACK_COUNT NUMBER

Chargeback Count
OP_CREDIT_MEMOS_COUNT NUMBER

Credit Memos Count
UNRESOLVED_CASH_COUNT NUMBER

Unsolved Cash Count
DISPUTED_INV_COUNT NUMBER

Disputed Invoice Count
BEST_CURRENT_RECEIVABLES NUMBER

Best Current Receivables
OP_INVOICES_VALUE NUMBER

Invoice Value
OP_DEBIT_MEMOS_VALUE NUMBER

Debit Memo Value
OP_DEPOSITS_VALUE NUMBER

Deposit Value
OP_BILLS_RECEIVABLES_VALUE NUMBER

Bills Receivable Value
OP_CHARGEBACK_VALUE NUMBER

Chargeback Value
OP_CREDIT_MEMOS_VALUE NUMBER

Credit Memo Value
UNRESOLVED_CASH_VALUE NUMBER

Unsolved Cash Value
RECEIPTS_AT_RISK_VALUE NUMBER

Receipt Risk Value
INV_AMT_IN_DISPUTE NUMBER

Dispute Invoice Amount
PENDING_ADJ_VALUE NUMBER

Pending Adjustment Value
PAST_DUE_INV_VALUE NUMBER

Past Due Invoice Value
PAST_DUE_INV_INST_COUNT NUMBER

Past Due Invoice Installment Count
LAST_PAYMENT_DATE DATE

Last Payment Date
LAST_PAYMENT_AMOUNT NUMBER

Last Payment Amount
LAST_PAYMENT_AMOUNT_CURR VARCHAR2 (20)
Last Payment Amount Curr
LAST_PAYMENT_NUMBER VARCHAR2 (30)
Last Payment Number
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
NUMBER_OF_DELINQUENCIES NUMBER

Number of Delinquencies
ACTIVE_DELINQUENCIES NUMBER

Active Delinquencies
COMPLETE_DELINQUENCIES NUMBER

Complete Delinquencies
PENDING_DELINQUENCIES NUMBER

Pending Delinquencies
SCORE NUMBER

Score
ADDRESS1 VARCHAR2 (240)
Address1
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (80)
Country
PROVINCE VARCHAR2 (60)
Province
POSTAL_CODE VARCHAR2 (60)
Postal Code
PHONE_COUNTRY_CODE VARCHAR2 (10)
Phone Country Code
PHONE_AREA_CODE VARCHAR2 (10)
Phone Area Code
PHONE_NUMBER VARCHAR2 (40)
Phone Number
PHONE_EXTENSION VARCHAR2 (20)
Phone Extension
NUMBER_OF_BANKRUPTCIES NUMBER

Number of Bankrupcies
NUMBER_OF_PROMISES NUMBER

Number of Promise
BROKEN_PROMISE_AMOUNT NUMBER

Broken Promise Amount
PROMISE_AMOUNT NUMBER

Promise Amount
ACTIVE_PROMISES NUMBER

Active Promises
COMPLETE_PROMISES NUMBER

Complete Promises
PENDING_PROMISES NUMBER

Pending Promises
WORK_ITEM_ID NUMBER

Work Item Id
SCHEDULE_START DATE

Start Schedule
SCHEDULE_END DATE

End Schedule
WORK_TYPE VARCHAR2 (30)
Work Type
CATEGORY_TYPE VARCHAR2 (30)
Category Type
PRIORITY_TYPE VARCHAR2 (30)
Priority Type
WKITEM_RESOURCE_ID NUMBER

Work Item Resource ID
STRATEGY_ID NUMBER

Strategy ID
STRATEGY_TEMPLATE_ID NUMBER

Strategy Template ID
WORK_ITEM_TEMPLATE_ID NUMBER

Work Item Template ID
STATUS_CODE VARCHAR2 (30)
Status Code
START_TIME DATE

Start Time
END_TIME DATE

End time
WORK_ITEM_ORDER NUMBER

Work items displaying order
WKITEM_ESCALATED_YN VARCHAR2 (1)
Workitem Esalation Flag
Query Text

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


SELECT DLN_UWQ_SUMMARY_ID
,      ORG_ID
,      COLLECTOR_ID
,      COLLECTOR_RESOURCE_ID
,      COLLECTOR_RES_TYPE
,      IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      RESOURCE_ID
,      RESOURCE_TYPE
,      PARTY_ID
,      PARTY_NAME
,      CUST_ACCOUNT_ID
,      ACCOUNT_NAME
,      ACCOUNT_NUMBER
,      SITE_USE_ID
,      LOCATION
,      CURRENCY
,      OP_INVOICES_COUNT
,      OP_DEBIT_MEMOS_COUNT
,      OP_DEPOSITS_COUNT
,      OP_BILLS_RECEIVABLES_COUNT
,      OP_CHARGEBACK_COUNT
,      OP_CREDIT_MEMOS_COUNT
,      UNRESOLVED_CASH_COUNT
,      DISPUTED_INV_COUNT
,      BEST_CURRENT_RECEIVABLES
,      OP_INVOICES_VALUE
,      OP_DEBIT_MEMOS_VALUE
,      OP_DEPOSITS_VALUE
,      OP_BILLS_RECEIVABLES_VALUE
,      OP_CHARGEBACK_VALUE
,      OP_CREDIT_MEMOS_VALUE
,      UNRESOLVED_CASH_VALUE
,      RECEIPTS_AT_RISK_VALUE
,      INV_AMT_IN_DISPUTE
,      PENDING_ADJ_VALUE
,      PAST_DUE_INV_VALUE
,      PAST_DUE_INV_INST_COUNT
,      LAST_PAYMENT_DATE
,      LAST_PAYMENT_AMOUNT
,      LAST_PAYMENT_AMOUNT_CURR
,      LAST_PAYMENT_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NUMBER_OF_DELINQUENCIES
,      ACTIVE_DELINQUENCIES
,      COMPLETE_DELINQUENCIES
,      PENDING_DELINQUENCIES
,      SCORE
,      ADDRESS1
,      CITY
,      STATE
,      COUNTY
,      COUNTRY
,      PROVINCE
,      POSTAL_CODE
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      NUMBER_OF_BANKRUPTCIES
,      NUMBER_OF_PROMISES
,      BROKEN_PROMISE_AMOUNT
,      PROMISE_AMOUNT
,      ACTIVE_PROMISES
,      COMPLETE_PROMISES
,      PENDING_PROMISES
,      WORK_ITEM_ID
,      SCHEDULE_START
,      SCHEDULE_END
,      WORK_TYPE
,      CATEGORY_TYPE
,      PRIORITY_TYPE
,      WKITEM_RESOURCE_ID
,      STRATEGY_ID
,      STRATEGY_TEMPLATE_ID
,      WORK_ITEM_TEMPLATE_ID
,      STATUS_CODE
,      START_TIME
,      END_TIME
,      WORK_ITEM_ORDER
,      WKITEM_ESCALATED_YN
FROM IEX.IEX_DLN_UWQ_SUMMARY;

Dependencies

[top of page]

IEX.IEX_DLN_UWQ_SUMMARY does not reference any database object

IEX.IEX_DLN_UWQ_SUMMARY is referenced by following:

SchemaAPPS
SynonymIEX_DLN_UWQ_SUMMARY