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

VIEW: APPS.IEX_CU_PRO_ALL_UWQ_V

Object Details
Object Name: IEX_CU_PRO_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 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_RESOURCE_NAME VARCHAR2 (240)
COLLECTOR_RESOURCE_TYPE VARCHAR2 (4000)
COLLECTOR_RES_TYPE VARCHAR2 (30)
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU_OBJECT_PARAMETERS VARCHAR2 (4000)
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

SCORE_ID NUMBER

SCORE_NAME VARCHAR2 (240)
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
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 DLN_UWQ_SUMMARY_ID
,      ORG_ID
,      COLLECTOR_ID
,      COLLECTOR_RESOURCE_ID
,      COLLECTOR_RESOURCE_NAME
,      COLLECTOR_RESOURCE_TYPE
,      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
,      SCORE_ID
,      SCORE_NAME
,      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
,      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_PRO_ALL_UWQ_V;

Dependencies

[top of page]

APPS.IEX_CU_PRO_ALL_UWQ_V references the following:

SchemaAPPS
ViewHR_OPERATING_UNITS
SynonymIEX_DLN_UWQ_SUMMARY
PL/SQL PackageIEX_UTILITIES - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code

APPS.IEX_CU_PRO_ALL_UWQ_V is not referenced by any database object