[Home] [Help] [Dependency Information]
Object Name: | IEX_BKR_FILING_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 | ||
FILE_CONTACT_ID | NUMBER | |||
CHAPTER_CODE | VARCHAR2 | (30) | The Chapter under which the bankruptcy was filed. Eg. Chapter 7,9,11,12 | |
BANKRUPTCY_FILE_DATE | DATE | The Date the Bankruptcy was filed. | ||
FILING_NAME | VARCHAR2 | (360) | Name of this party | |
FILING_ADDRESS1 | VARCHAR2 | (240) | First line of the Identifying address | |
FILING_ADDRESS2 | VARCHAR2 | (240) | Second line of the Identifying address | |
FILING_CITY | VARCHAR2 | (60) | City of the Identifying address | |
FILING_COUNTY | VARCHAR2 | (60) | County of the Identifying address | |
FILING_STATE | VARCHAR2 | (60) | State of the Identifying address | |
FILING_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of the Identifying address | |
FILING_PHONE_NUMBER | VARCHAR2 | (40) | ||
COURT_ID | NUMBER | |||
COURT_NAME | VARCHAR2 | (360) | ||
CASE_NUMBER | VARCHAR2 | (100) | ||
COURT_CLERK_CONTACT_ID | NUMBER | |||
COURT_CLERK_CONTACT_NAME | VARCHAR2 | (360) | ||
COURT_ADDRESS1 | VARCHAR2 | (240) | ||
COURT_ADDRESS2 | VARCHAR2 | (240) | ||
COURT_CITY | VARCHAR2 | (60) | ||
COURT_COUNTY | VARCHAR2 | (60) | ||
COURT_STATE | VARCHAR2 | (60) | ||
COURT_POSTAL_CODE | VARCHAR2 | (60) | ||
COURT_PHONE_NUMBER | VARCHAR2 | (40) | ||
FUNDING_DATE | DATE | |||
COURT_ORDER_DATE | DATE | |||
OBJECT_BAR_DATE | DATE | |||
REPOSSESSION_DATE | DATE | |||
DISMISSAL_DATE | DATE | |||
DATE_341A | DATE | |||
DISCHARGE_DATE | DATE | |||
WITHDRAW_DATE | DATE | |||
CLOSE_DATE | DATE | |||
TBD_DATE | DATE | |||
FILE_PROOF_CLAIM_YN | VARCHAR2 | (1) | ||
NOTICE_ASSIGNMENT_YN | VARCHAR2 | (1) | ||
REQUEST_REPURCHASE_YN | VARCHAR2 | (1) | ||
DISPOSITION_CODE | VARCHAR2 | (30) | ||
DISPOSITION_MEANING | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT BANKRUPTCY_ID
, DELINQUENCY_ID
, FILE_CONTACT_ID
, CHAPTER_CODE
, BANKRUPTCY_FILE_DATE
, FILING_NAME
, FILING_ADDRESS1
, FILING_ADDRESS2
, FILING_CITY
, FILING_COUNTY
, FILING_STATE
, FILING_POSTAL_CODE
, FILING_PHONE_NUMBER
, COURT_ID
, COURT_NAME
, CASE_NUMBER
, COURT_CLERK_CONTACT_ID
, COURT_CLERK_CONTACT_NAME
, COURT_ADDRESS1
, COURT_ADDRESS2
, COURT_CITY
, COURT_COUNTY
, COURT_STATE
, COURT_POSTAL_CODE
, COURT_PHONE_NUMBER
, FUNDING_DATE
, COURT_ORDER_DATE
, OBJECT_BAR_DATE
, REPOSSESSION_DATE
, DISMISSAL_DATE
, DATE_341A
, DISCHARGE_DATE
, WITHDRAW_DATE
, CLOSE_DATE
, TBD_DATE
, FILE_PROOF_CLAIM_YN
, NOTICE_ASSIGNMENT_YN
, REQUEST_REPURCHASE_YN
, DISPOSITION_CODE
, DISPOSITION_MEANING
FROM APPS.IEX_BKR_FILING_V;
APPS.IEX_BKR_FILING_V is not referenced by any database object
|
|
|