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_STR_UWQ_V

Object Details

Object Name:	IEX_CU_STR_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	Comments
IEU_OBJECT_FUNCTION	VARCHAR2	(30)		IEU Object Function
IEU_OBJECT_PARAMETERS	VARCHAR2	(4000)
IEU_MEDIA_TYPE_UUID	VARCHAR2	(10)
IEU_PARAM_PK_COL	VARCHAR2	(40)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
COLLECTOR_RESOURCE_ID	NUMBER
COLLECTOR_RESOURCE_NAME	VARCHAR2	(240)
COLLECTOR_RESOURCE_TYPE	VARCHAR2	(4000)
COLLECTOR_RES_TYPE	VARCHAR2	(30)
RESOURCE_ID	NUMBER
RESOURCE_TYPE	CHAR	(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_STRATEGIES	VARCHAR2	(0)
ACTIVE_STRATEGIES	VARCHAR2	(0)
PENDING_STRATEGIES	VARCHAR2	(0)
COMPLETE_STRATEGIES	VARCHAR2	(0)
STRATEGY_NAME	VARCHAR2	(240)	Yes
WKITEM_TEMPLATE_NAME	VARCHAR2	(240)	Yes
CATEGORY_MEANING	VARCHAR2	(4000)
CATEGORY	VARCHAR2	(30)
STATUS	VARCHAR2	(4000)
STR_STATUS	VARCHAR2	(4000)
STR_STATUS_CODE	VARCHAR2	(240)
ASSIGNED_TO	NUMBER
ASSIGNEE	VARCHAR2	(360)
START_TIME	DATE
END_TIME	DATE
SCHEDULE_START	DATE
SCHEDULE_END	DATE
WKITEM_ORDER	NUMBER
WORK_TYPE	VARCHAR2	(30)
WKITEM_ESCALATED_YN	VARCHAR2	(1)
WKITEM_ESCALATED_MEANING	VARCHAR2	(4000)
UWQ_ACTIVE_DATE	VARCHAR2	(0)
UWQ_COMPLETE_DATE	VARCHAR2	(0)
NUMBER_OF_BANKRUPTCIES	NUMBER
ORG_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
AGING_AMOUNT1	NUMBER
AGING_COUNT1	NUMBER
AGING_AMOUNT2	NUMBER
AGING_COUNT2	NUMBER
AGING_AMOUNT3	NUMBER
AGING_COUNT3	NUMBER
AGING_AMOUNT4	NUMBER
AGING_COUNT4	NUMBER
AGING_AMOUNT5	NUMBER
AGING_COUNT5	NUMBER
AGING_AMOUNT6	NUMBER
AGING_COUNT6	NUMBER
AGING_AMOUNT7	NUMBER
AGING_COUNT7	NUMBER
CASES_COUNT	NUMBER
DEL_CASES_COUNT	NUMBER
CONTRACTS_COUNT	NUMBER
DEL_CONTRACTS_COUNT	NUMBER
NET_BALANCE	NUMBER

Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      COLLECTOR_RESOURCE_ID
,      COLLECTOR_RESOURCE_NAME
,      COLLECTOR_RESOURCE_TYPE
,      COLLECTOR_RES_TYPE
,      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_STRATEGIES
,      ACTIVE_STRATEGIES
,      PENDING_STRATEGIES
,      COMPLETE_STRATEGIES
,      STRATEGY_NAME
,      WKITEM_TEMPLATE_NAME
,      CATEGORY_MEANING
,      CATEGORY
,      STATUS
,      STR_STATUS
,      STR_STATUS_CODE
,      ASSIGNED_TO
,      ASSIGNEE
,      START_TIME
,      END_TIME
,      SCHEDULE_START
,      SCHEDULE_END
,      WKITEM_ORDER
,      WORK_TYPE
,      WKITEM_ESCALATED_YN
,      WKITEM_ESCALATED_MEANING
,      UWQ_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      NUMBER_OF_BANKRUPTCIES
,      ORG_ID
,      OPERATING_UNIT_NAME
,      AGING_AMOUNT1
,      AGING_COUNT1
,      AGING_AMOUNT2
,      AGING_COUNT2
,      AGING_AMOUNT3
,      AGING_COUNT3
,      AGING_AMOUNT4
,      AGING_COUNT4
,      AGING_AMOUNT5
,      AGING_COUNT5
,      AGING_AMOUNT6
,      AGING_COUNT6
,      AGING_AMOUNT7
,      AGING_COUNT7
,      CASES_COUNT
,      DEL_CASES_COUNT
,      CONTRACTS_COUNT
,      DEL_CONTRACTS_COUNT
,      NET_BALANCE
FROM APPS.IEX_CU_STR_UWQ_V;

Dependencies

[top of page]

APPS.IEX_CU_STR_UWQ_V references the following:

APPS: ARPT_SQL_FUNC_UTIL - show dependent code; HR_OPERATING_UNITS; IEX_DLN_UWQ_SUMMARY; IEX_STRATEGY_TEMPLATES_TL; IEX_STRY_TEMP_WORK_ITEMS_TL; IEX_UTILITIES - show dependent code; JTF_RS_RESOURCE_EXTNS; MO_GLOBAL - show dependent code

APPS.IEX_CU_STR_UWQ_V is not referenced by any database object