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: LNS.LNS_DISB_HEADERS

Object Details

Object Name:	LNS_DISB_HEADERS
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_DISB_HEADERS
Subobject Name:
Status:	VALID

Disbursement Headers Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_DISB_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISB_HEADER_ID
LNS_DISB_HEADERS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAN_ID DISBURSEMENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
DISB_HEADER_ID	NUMBER	(15)	Yes	Primary Key
LOAN_ID	NUMBER	(15)	Yes	FK to LNS_LOAN_HEADERS
TARGET_DATE	DATE			Target Date
PAYMENT_REQUEST_DATE	DATE			Payment Requested Date
ACTIVITY_CODE	VARCHAR2	(30)		Activity Code
DISBURSEMENT_NUMBER	NUMBER			Disbursement Number
HEADER_AMOUNT	NUMBER			Total Header Amount
HEADER_PERCENT	NUMBER			Header Percent
STATUS	VARCHAR2	(30)		Disbursement Status
AUTOFUNDING_FLAG	VARCHAR2	(1)		Flag that indicates whether funding advice is created automatically or manually
OBJECT_VERSION_NUMBER	NUMBER		Yes	Obj Version Num
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
DESCRIPTION	VARCHAR2	(250)		Disbursement Description
PHASE	VARCHAR2	(30)		Phase (Disbursement or Term)

Query Text

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


SELECT DISB_HEADER_ID
,      LOAN_ID
,      TARGET_DATE
,      PAYMENT_REQUEST_DATE
,      ACTIVITY_CODE
,      DISBURSEMENT_NUMBER
,      HEADER_AMOUNT
,      HEADER_PERCENT
,      STATUS
,      AUTOFUNDING_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      PHASE
FROM LNS.LNS_DISB_HEADERS;

Dependencies

[top of page]

LNS.LNS_DISB_HEADERS does not reference any database object

LNS.LNS_DISB_HEADERS is referenced by following:

LNS: LNS_DISB_HEADERS#