[Home] [Help] [Dependency Information]
Object Name: | IEX_BKR_LEGAL_CNT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.IEX_BKR_LEGAL_CNT_V is not referenced by any database object
|
|
|