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: IGF.IGF_SL_AWD_DISB_LOC_ALL

Object Details

Object Name:	IGF_SL_AWD_DISB_LOC_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_AWD_DISB_LOC_ALL
Subobject Name:
Status:	VALID

IGF_SL_AWD_DISB_LOC_ALL holds the loan disbursement data for each loan, at the time of origination or changes sent. This always reflects the data currently in the LOC.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_AWD_DISB_LOC_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_ID DISB_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISB_NUM	NUMBER	(15)	Yes	Indicates disbursement number
DISB_GROSS_AMT	NUMBER	(12)	Yes	Indicates disbursement gross amount
FEE_1	NUMBER	(12)		Indicates origination fees in case of Direct Loans and CommonLine loans
FEE_2	NUMBER	(12)		Indicates guarantor fees in case of CommonLine loans
DISB_NET_AMT	NUMBER	(12)	Yes	Indicates disbursement net amount
DISB_DATE	DATE		Yes	Indicates anticipated or actual disbursement date depending upon transaction type
HOLD_REL_IND	VARCHAR2	(30)		Indicates hold release indicator
FEE_PAID_1	NUMBER	(12)		Indicates origination fees paid
FEE_PAID_2	NUMBER	(12)		Indicates guarantee fees paid
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard Who column for concurrent programs
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT AWARD_ID
,      DISB_NUM
,      DISB_GROSS_AMT
,      FEE_1
,      FEE_2
,      DISB_NET_AMT
,      DISB_DATE
,      HOLD_REL_IND
,      FEE_PAID_1
,      FEE_PAID_2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM IGF.IGF_SL_AWD_DISB_LOC_ALL;

Dependencies

[top of page]

IGF.IGF_SL_AWD_DISB_LOC_ALL does not reference any database object

IGF.IGF_SL_AWD_DISB_LOC_ALL is referenced by following:

APPS: IGF_SL_AWD_DISB_LOC_ALL