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_PROFILE_DELINQUENCIES_V

Object Details

Object Name:	IEX_PROFILE_DELINQUENCIES_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
PARTY_CUST_ID	NUMBER	(15)	Yes
CUST_ACCOUNT_ID	NUMBER	(15)	Yes
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
CUSTOMER_TRX_ID	NUMBER	(15)	Yes
INVOICE_NUMBER	VARCHAR2	(20)	Yes
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes
DUE_DATE	DATE		Yes
AMOUNT_DUE	NUMBER		Yes
AMOUNT_DUE_CC	VARCHAR2	(15)	Yes
CURRENCY	VARCHAR2	(15)	Yes
ORIGINAL_AMOUNT_DUE	NUMBER		Yes
ORIGINAL_AMOUNT_DUE_CC	VARCHAR2	(15)	Yes
AMOUNT_IN_DISPUTE	NUMBER
AMOUNT_IN_DISPUTE_CC	VARCHAR2	(15)	Yes
LAST_PAYMENT_AMOUNT	VARCHAR2	(40)
LAST_PAYMENT_AMOUNT_CC	VARCHAR2	(15)
LAST_PAYMENT_DATE	DATE
RECEIVABLE_APPLICATION_ID	NUMBER	(15)
CUSTOMER_SITE_USE_ID	NUMBER	(15)
DELINQUENCY_ID	NUMBER		Yes
PARTY_SITE_NUMBER	VARCHAR2	(30)	Yes
LOCATION	VARCHAR2	(40)	Yes
ADDRESS	VARCHAR2	(307)
ORG_ID	NUMBER	(15)
OPERATING_UNIT	VARCHAR2	(240)
CONS_BILLING_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT PARTY_CUST_ID
,      CUST_ACCOUNT_ID
,      ACCOUNT_NUMBER
,      CUSTOMER_TRX_ID
,      INVOICE_NUMBER
,      PAYMENT_SCHEDULE_ID
,      DUE_DATE
,      AMOUNT_DUE
,      AMOUNT_DUE_CC
,      CURRENCY
,      ORIGINAL_AMOUNT_DUE
,      ORIGINAL_AMOUNT_DUE_CC
,      AMOUNT_IN_DISPUTE
,      AMOUNT_IN_DISPUTE_CC
,      LAST_PAYMENT_AMOUNT
,      LAST_PAYMENT_AMOUNT_CC
,      LAST_PAYMENT_DATE
,      RECEIVABLE_APPLICATION_ID
,      CUSTOMER_SITE_USE_ID
,      DELINQUENCY_ID
,      PARTY_SITE_NUMBER
,      LOCATION
,      ADDRESS
,      ORG_ID
,      OPERATING_UNIT
,      CONS_BILLING_NUMBER
FROM APPS.IEX_PROFILE_DELINQUENCIES_V;

Dependencies

[top of page]

APPS.IEX_PROFILE_DELINQUENCIES_V references the following:

APPS: AR_CASH_RECEIPTS; AR_CASH_RECEIPT_HISTORY; AR_CONS_INV; AR_PAYMENT_SCHEDULES; AR_RECEIVABLE_APPLICATIONS; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; IEX_CUST_SITE_USES_V; IEX_DELINQUENCIES; RA_CM_REQUESTS; RA_CUSTOMER_TRX

APPS.IEX_PROFILE_DELINQUENCIES_V is not referenced by any database object