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

VIEW: APPS.IEX_PROFILE_CASE_DEL_V

Object Details
Object Name: IEX_PROFILE_CASE_DEL_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
PARTY_ID NUMBER

CUST_ACCOUNT_ID NUMBER

DELINQUENCY_ID NUMBER
Yes
CASE_ID NUMBER

CASE_NUMBER VARCHAR2 (240) Yes
CASE_DUE_DATE DATE

AMOUNT_DUE NUMBER

AMOUNT_DUE_CC VARCHAR2 (240)
AMOUNT_OVERDUE NUMBER

AMOUNT_OVERDUE_CC VARCHAR2 (240)
ACCOUNT_NUMBER VARCHAR2 (240)
CURRENCY VARCHAR2 (240)
CUSTOMER_SITE_USE_ID NUMBER

PARTY_SITE_NUMBER VARCHAR2 (30) Yes
LOCATION VARCHAR2 (40) Yes
ADDRESS VARCHAR2 (307)
Query Text

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


SELECT PARTY_ID
,      CUST_ACCOUNT_ID
,      DELINQUENCY_ID
,      CASE_ID
,      CASE_NUMBER
,      CASE_DUE_DATE
,      AMOUNT_DUE
,      AMOUNT_DUE_CC
,      AMOUNT_OVERDUE
,      AMOUNT_OVERDUE_CC
,      ACCOUNT_NUMBER
,      CURRENCY
,      CUSTOMER_SITE_USE_ID
,      PARTY_SITE_NUMBER
,      LOCATION
,      ADDRESS
FROM APPS.IEX_PROFILE_CASE_DEL_V;

Dependencies

[top of page]

APPS.IEX_PROFILE_CASE_DEL_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
ViewIEX_CASES_V
SynonymIEX_CASE_DEFINITIONS
PL/SQL PackageIEX_CASE_INFO_PUB - show dependent code
SynonymIEX_CASE_OBJECTS
ViewIEX_CUST_SITE_USES_V
SynonymIEX_DELINQUENCIES
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymOKL_CNSLD_AR_STRMS_B

APPS.IEX_PROFILE_CASE_DEL_V is not referenced by any database object