eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: IEX.IEX_DLN_UWQ_SUMMARY#

Object Details

Object Name:	IEX_DLN_UWQ_SUMMARY#
Object Type:	VIEW
Owner:	IEX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
DLN_UWQ_SUMMARY_ID	NUMBER
ORG_ID	NUMBER
COLLECTOR_ID	NUMBER
COLLECTOR_RESOURCE_ID	NUMBER
COLLECTOR_RES_TYPE	VARCHAR2	(30)
IEU_OBJECT_FUNCTION	VARCHAR2	(30)
IEU_OBJECT_PARAMETERS	VARCHAR2	(2020)
IEU_MEDIA_TYPE_UUID	VARCHAR2	(10)
IEU_PARAM_PK_COL	VARCHAR2	(40)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
RESOURCE_ID	NUMBER
RESOURCE_TYPE	VARCHAR2	(11)
PARTY_ID	NUMBER
PARTY_NAME	VARCHAR2	(360)
CUST_ACCOUNT_ID	NUMBER
ACCOUNT_NAME	VARCHAR2	(240)
ACCOUNT_NUMBER	VARCHAR2	(30)
SITE_USE_ID	NUMBER
LOCATION	VARCHAR2	(60)
CURRENCY	VARCHAR2	(20)
OP_INVOICES_COUNT	NUMBER
OP_DEBIT_MEMOS_COUNT	NUMBER
OP_DEPOSITS_COUNT	NUMBER
OP_BILLS_RECEIVABLES_COUNT	NUMBER
OP_CHARGEBACK_COUNT	NUMBER
OP_CREDIT_MEMOS_COUNT	NUMBER
UNRESOLVED_CASH_COUNT	NUMBER
DISPUTED_INV_COUNT	NUMBER
BEST_CURRENT_RECEIVABLES	NUMBER
OP_INVOICES_VALUE	NUMBER
OP_DEBIT_MEMOS_VALUE	NUMBER
OP_DEPOSITS_VALUE	NUMBER
OP_BILLS_RECEIVABLES_VALUE	NUMBER
OP_CHARGEBACK_VALUE	NUMBER
OP_CREDIT_MEMOS_VALUE	NUMBER
UNRESOLVED_CASH_VALUE	NUMBER
RECEIPTS_AT_RISK_VALUE	NUMBER
INV_AMT_IN_DISPUTE	NUMBER
PENDING_ADJ_VALUE	NUMBER
PAST_DUE_INV_VALUE	NUMBER
PAST_DUE_INV_INST_COUNT	NUMBER
LAST_PAYMENT_DATE	DATE
LAST_PAYMENT_AMOUNT	NUMBER
LAST_PAYMENT_AMOUNT_CURR	VARCHAR2	(20)
LAST_PAYMENT_NUMBER	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
NUMBER_OF_DELINQUENCIES	NUMBER
ACTIVE_DELINQUENCIES	NUMBER
COMPLETE_DELINQUENCIES	NUMBER
PENDING_DELINQUENCIES	NUMBER
SCORE	NUMBER
ADDRESS1	VARCHAR2	(240)
CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
COUNTRY	VARCHAR2	(80)
PROVINCE	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
PHONE_COUNTRY_CODE	VARCHAR2	(10)
PHONE_AREA_CODE	VARCHAR2	(10)
PHONE_NUMBER	VARCHAR2	(40)
PHONE_EXTENSION	VARCHAR2	(20)
NUMBER_OF_BANKRUPTCIES	NUMBER
NUMBER_OF_PROMISES	NUMBER
BROKEN_PROMISE_AMOUNT	NUMBER
PROMISE_AMOUNT	NUMBER
ACTIVE_PROMISES	NUMBER
COMPLETE_PROMISES	NUMBER
PENDING_PROMISES	NUMBER
WORK_ITEM_ID	NUMBER
SCHEDULE_START	DATE
SCHEDULE_END	DATE
WORK_TYPE	VARCHAR2	(30)
CATEGORY_TYPE	VARCHAR2	(30)
PRIORITY_TYPE	VARCHAR2	(30)
WKITEM_RESOURCE_ID	NUMBER
STRATEGY_ID	NUMBER
STRATEGY_TEMPLATE_ID	NUMBER
WORK_ITEM_TEMPLATE_ID	NUMBER
STATUS_CODE	VARCHAR2	(30)
START_TIME	DATE
END_TIME	DATE
WORK_ITEM_ORDER	NUMBER
WKITEM_ESCALATED_YN	VARCHAR2	(1)
STR_STATUS	VARCHAR2	(240)
AGING_AMOUNT1	NUMBER
AGING_AMOUNT2	NUMBER
AGING_AMOUNT3	NUMBER
AGING_AMOUNT4	NUMBER
AGING_AMOUNT5	NUMBER
AGING_AMOUNT6	NUMBER
AGING_AMOUNT7	NUMBER
AGING_COUNT1	NUMBER
AGING_COUNT2	NUMBER
AGING_COUNT3	NUMBER
AGING_COUNT4	NUMBER
AGING_COUNT5	NUMBER
AGING_COUNT6	NUMBER
AGING_COUNT7	NUMBER
CASES_COUNT	NUMBER
DEL_CASES_COUNT	NUMBER
CONTRACTS_COUNT	NUMBER
DEL_CONTRACTS_COUNT	NUMBER
COLLECTOR_RESOURCE_NAME	VARCHAR2	(240)
SCORE_ID	NUMBER
SCORE_NAME	VARCHAR2	(240)
BUSINESS_LEVEL	VARCHAR2	(240)
NET_BALANCE	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER

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
,      STR_STATUS
,      AGING_AMOUNT1
,      AGING_AMOUNT2
,      AGING_AMOUNT3
,      AGING_AMOUNT4
,      AGING_AMOUNT5
,      AGING_AMOUNT6
,      AGING_AMOUNT7
,      AGING_COUNT1
,      AGING_COUNT2
,      AGING_COUNT3
,      AGING_COUNT4
,      AGING_COUNT5
,      AGING_COUNT6
,      AGING_COUNT7
,      CASES_COUNT
,      DEL_CASES_COUNT
,      CONTRACTS_COUNT
,      DEL_CONTRACTS_COUNT
,      COLLECTOR_RESOURCE_NAME
,      SCORE_ID
,      SCORE_NAME
,      BUSINESS_LEVEL
,      NET_BALANCE
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
FROM IEX.IEX_DLN_UWQ_SUMMARY#;

Dependencies

[top of page]

IEX.IEX_DLN_UWQ_SUMMARY# references the following:

IEX: IEX_DLN_UWQ_SUMMARY

IEX.IEX_DLN_UWQ_SUMMARY# is referenced by following:

APPS: IEX_DLN_UWQ_SUMMARY