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_BKR_LEGAL_CNT_V

Object Details

Object Name:	IEX_BKR_LEGAL_CNT_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
BANKRUPTCY_ID	NUMBER		Yes	Bankruptcy Identifier
DELINQUENCY_ID	NUMBER			Foreign Key to IEX_DELEINQUENCY table
FIRM_CONTACT_ID	NUMBER			Law firm who is assigned to the Bankruptcy Case.
FIRM_NAME	VARCHAR2	(360)		Name of this party
FIRM_ADDRESS1	VARCHAR2	(240)		First line of the Identifying address
FIRM_ADDRESS2	VARCHAR2	(240)		Second line of the Identifying address
FIRM_CITY	VARCHAR2	(60)		City of the Identifying address
FIRM_COUNTY	VARCHAR2	(60)		County of the Identifying address
FIRM_STATE	VARCHAR2	(60)		State of the Identifying address
FIRM_POSTAL_CODE	VARCHAR2	(60)		Postal Code of the Identifying address
FIRM_PHONE_NUMBER	VARCHAR2	(40)
FIRM_EMAIL	VARCHAR2	(2000)
FIRM_FAX	VARCHAR2	(50)
COUNSEL_CONTACT_ID	NUMBER
COUNSEL_NAME	VARCHAR2	(360)
COUNSEL_ADDRESS1	VARCHAR2	(240)
COUNSEL_ADDRESS2	VARCHAR2	(240)
COUNSEL_CITY	VARCHAR2	(60)
COUNSEL_COUNTY	VARCHAR2	(60)
COUNSEL_STATE	VARCHAR2	(60)
COUNSEL_POSTAL_CODE	VARCHAR2	(60)
COUNSEL_PHONE_NUMBER	VARCHAR2	(40)
COUNSEL_EMAIL	VARCHAR2	(2000)
COUNSEL_FAX	VARCHAR2	(50)
FEE_PAID_DATE	DATE
REAFFIRMATION_DATE	DATE
RELIEF_STAY_DATE	DATE
TRUSTEE_CONTACT_ID	NUMBER
TRUSTEE_NAME	VARCHAR2	(360)
TRUSTEE_ADDRESS1	VARCHAR2	(240)
TRUSTEE_ADDRESS2	VARCHAR2	(240)
TRUSTEE_CITY	VARCHAR2	(60)
TRUSTEE_COUNTY	VARCHAR2	(60)
TRUSTEE_STATE	VARCHAR2	(60)
TRUSTEE_POSTAL_CODE	VARCHAR2	(60)
TRUSTEE_PHONE_NUMBER	VARCHAR2	(40)
TRUSTEE_EMAIL	VARCHAR2	(2000)
TRUSTEE_FAX	VARCHAR2	(50)
DISPOSITION_CODE	VARCHAR2	(30)
DISPOSITION_MEANING	VARCHAR2	(80)

Query Text

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


SELECT BANKRUPTCY_ID
,      DELINQUENCY_ID
,      FIRM_CONTACT_ID
,      FIRM_NAME
,      FIRM_ADDRESS1
,      FIRM_ADDRESS2
,      FIRM_CITY
,      FIRM_COUNTY
,      FIRM_STATE
,      FIRM_POSTAL_CODE
,      FIRM_PHONE_NUMBER
,      FIRM_EMAIL
,      FIRM_FAX
,      COUNSEL_CONTACT_ID
,      COUNSEL_NAME
,      COUNSEL_ADDRESS1
,      COUNSEL_ADDRESS2
,      COUNSEL_CITY
,      COUNSEL_COUNTY
,      COUNSEL_STATE
,      COUNSEL_POSTAL_CODE
,      COUNSEL_PHONE_NUMBER
,      COUNSEL_EMAIL
,      COUNSEL_FAX
,      FEE_PAID_DATE
,      REAFFIRMATION_DATE
,      RELIEF_STAY_DATE
,      TRUSTEE_CONTACT_ID
,      TRUSTEE_NAME
,      TRUSTEE_ADDRESS1
,      TRUSTEE_ADDRESS2
,      TRUSTEE_CITY
,      TRUSTEE_COUNTY
,      TRUSTEE_STATE
,      TRUSTEE_POSTAL_CODE
,      TRUSTEE_PHONE_NUMBER
,      TRUSTEE_EMAIL
,      TRUSTEE_FAX
,      DISPOSITION_CODE
,      DISPOSITION_MEANING
FROM APPS.IEX_BKR_LEGAL_CNT_V;

Dependencies

[top of page]

APPS.IEX_BKR_LEGAL_CNT_V references the following:

APPS: FND_GLOBAL - show dependent code; HZ_CONTACT_POINTS; HZ_PARTIES; IEX_BANKRUPTCIES; IEX_LOOKUPS_V

APPS.IEX_BKR_LEGAL_CNT_V is not referenced by any database object