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: APPS.IEX_CU_DLN_ALL_UWQ_V

Object Details

Object Name:	IEX_CU_DLN_ALL_UWQ_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
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	(2102)
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)
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes

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
,      OPERATING_UNIT_NAME
FROM APPS.IEX_CU_DLN_ALL_UWQ_V;