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]

TABLE: IEX.IEX_BANKRUPTCIES

Object Details

Object Name:	IEX_BANKRUPTCIES
Object Type:	TABLE
Owner:	IEX
FND Design Data:	IEX.IEX_BANKRUPTCIES
Subobject Name:
Status:	VALID

This entity keeps information on Bankrupt cases. Bankruptcy information such the category, the jurisdiction, date initiated, court proceedings, trustee, debtor, and collection invoicing flags

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEX_BANKRUPTCIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BANKRUPTCY_ID
IEX_BANKRUPTCIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAS_ID
IEX_BANKRUPTCIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELINQUENCY_ID
IEX_BANKRUPTCIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
IEX_BANKRUPTCIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COUNSEL_CONTACT_ID
IEX_BANKRUPTCIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURT_ID
IEX_BANKRUPTCIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FIRM_CONTACT_ID
IEX_BANKRUPTCIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRUSTEE_CONTACT_ID
IEX_BANKRUPTCIES_N8	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRUNC("CREATION_DATE")

Columns

Name	Datatype	Length	Mandatory	Comments
BANKRUPTCY_ID	NUMBER		Yes	Bankruptcy Identifier
CAS_ID	NUMBER			Foreign Key to Iex_cases_b table
DELINQUENCY_ID	NUMBER			Foreign Key to IEX_DELEINQUENCY table
PARTY_ID	NUMBER		Yes	Party Filing for Bankruptcy
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Indicates the State of a case whether it is active or on active. This is usedsince the record is not removed from the database.
TRUSTEE_CONTACT_ID	NUMBER			The individual from the Trustee Organization who is assigned to the Bankruptcy Case.
COURT_ID	NUMBER			Court or district where the filing was made.
FIRM_CONTACT_ID	NUMBER			Law firm who is assigned to the Bankruptcy Case.
COUNSEL_CONTACT_ID	NUMBER			Attorney who is assigned to the Bankruptcy Case.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	For HTML support.
CHAPTER_CODE	VARCHAR2	(30)		The Chapter under which the bankruptcy was filed. Eg. Chapter 7,9,11,12
ASSET_AMOUNT	NUMBER			Asset value of the delinquency
ASSET_CURRENCY_CODE	VARCHAR2	(30)		Currency of the Asset Valuation
PAYOFF_AMOUNT	NUMBER			Payoff Amount
PAYOFF_CURRENCY_CODE	VARCHAR2	(240)		Currency of the Payoff Valuation
BANKRUPTCY_FILE_DATE	DATE			The Date the Bankruptcy was filed.
COURT_ORDER_DATE	DATE			The date the court proceedings will be initiated.
FUNDING_DATE	DATE			Date funding was allocated.
OBJECT_BAR_DATE	DATE			For HTML support.
REPOSSESSION_DATE	DATE			Date on which the delinquent item was repossessed
DISMISSAL_DATE	DATE			Date on which court dismissed the Bankruptcy claim
DATE_341A	DATE			341 is the first meeting of the creditors.It is mandatory meeting of the debitors and creditors usually held within a month of the filing of the bankruptcy.
DISCHARGE_DATE	DATE			Date on which court dismissed the Bankruptcy claim
WITHDRAW_DATE	DATE			Date on which debtor withdre bankruptcy claim
CLOSE_DATE	DATE			Date on which the case was closed by the court.
PROCEDURE_CODE	VARCHAR2	(30)		Procedures which the collector wishes to initiate like debt not reaffirmed and pending discharge, relieve from stay,place account on hold
MOTION_CODE	VARCHAR2	(30)		Motions that can be filed based on the status of the caselike relief from stay,Motion for adequate protection,Consent Order
CHECKLIST_CODE	VARCHAR2	(30)		Checklist or guidelines for collectors neede for a particular status or function like -Filing , contact, chapter etc.
CEASE_COLLECTIONS_YN	VARCHAR2	(1)		Notify flag for turning an account from collections
TURN_OFF_INVOICING_YN	VARCHAR2	(1)		Notify flag for turning normal cycle invoicing to off.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CREDIT_HOLD_REQUEST_FLAG	VARCHAR2	(1)		Was credit hold requested Y/N?
CREDIT_HOLD_APPROVED_FLAG	VARCHAR2	(1)		Was credit hold approved Y/N?
SERVICE_HOLD_REQUEST_FLAG	VARCHAR2	(1)		Was service hold requested Y/N?
SERVICE_HOLD_APPROVED_FLAG	VARCHAR2	(1)		Was service hold approved Y/N?
DISPOSITION_CODE	VARCHAR2	(30)		Bankruptcy disposition. Lookup.
TURN_OFF_INVOICE_YN	VARCHAR2	(1)		Stop invoicing when customer goes bankrupt?
NOTICE_ASSIGNMENT_YN	VARCHAR2	(1)		Did we receive notice of assignment?
FILE_PROOF_CLAIM_YN	VARCHAR2	(1)		Did we file proof of claim?
REQUEST_REPURCHASE_YN	VARCHAR2	(1)		Should we request repurchase?
FEE_PAID_DATE	DATE			Date have we paid the court fees.
REAFFIRMATION_DATE	DATE			Date of the court reaffirmation for the bankruptcy
RELIEF_STAY_DATE	DATE			Bankruptcy RELEIF date.
FILE_CONTACT_ID	NUMBER			Contact foreign key.
CASE_NUMBER	VARCHAR2	(100)		Case number in court.
COURT_CLERK_CONTACT_ID	NUMBER			Contact ID foreign key for the court clerk.
CUST_ACCOUNT_ID	NUMBER			Customer account ID
CUSTOMER_SITE_USE_ID	NUMBER	(22)		Customer Site Use ID
ORG_ID	NUMBER			Operating Unit ID
APPROVAL_DATE	DATE			Bankrutpcy Approval Date

Query Text

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


SELECT BANKRUPTCY_ID
,      CAS_ID
,      DELINQUENCY_ID
,      PARTY_ID
,      ACTIVE_FLAG
,      TRUSTEE_CONTACT_ID
,      COURT_ID
,      FIRM_CONTACT_ID
,      COUNSEL_CONTACT_ID
,      OBJECT_VERSION_NUMBER
,      CHAPTER_CODE
,      ASSET_AMOUNT
,      ASSET_CURRENCY_CODE
,      PAYOFF_AMOUNT
,      PAYOFF_CURRENCY_CODE
,      BANKRUPTCY_FILE_DATE
,      COURT_ORDER_DATE
,      FUNDING_DATE
,      OBJECT_BAR_DATE
,      REPOSSESSION_DATE
,      DISMISSAL_DATE
,      DATE_341A
,      DISCHARGE_DATE
,      WITHDRAW_DATE
,      CLOSE_DATE
,      PROCEDURE_CODE
,      MOTION_CODE
,      CHECKLIST_CODE
,      CEASE_COLLECTIONS_YN
,      TURN_OFF_INVOICING_YN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CREDIT_HOLD_REQUEST_FLAG
,      CREDIT_HOLD_APPROVED_FLAG
,      SERVICE_HOLD_REQUEST_FLAG
,      SERVICE_HOLD_APPROVED_FLAG
,      DISPOSITION_CODE
,      TURN_OFF_INVOICE_YN
,      NOTICE_ASSIGNMENT_YN
,      FILE_PROOF_CLAIM_YN
,      REQUEST_REPURCHASE_YN
,      FEE_PAID_DATE
,      REAFFIRMATION_DATE
,      RELIEF_STAY_DATE
,      FILE_CONTACT_ID
,      CASE_NUMBER
,      COURT_CLERK_CONTACT_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_SITE_USE_ID
,      ORG_ID
,      APPROVAL_DATE
FROM IEX.IEX_BANKRUPTCIES;

Dependencies

[top of page]

IEX.IEX_BANKRUPTCIES does not reference any database object

IEX.IEX_BANKRUPTCIES is referenced by following:

IEX: IEX_BANKRUPTCIES#