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]

VIEW: APPS.IGF_DB_AWD_DISB_DTL_V

Object Details

Object Name:	IGF_DB_AWD_DISB_DTL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_DB_AWD_DISB_DTL_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
AWARD_ID	NUMBER	(15)	Yes
DISB_NUM	NUMBER	(15)	Yes
DISB_SEQ_NUM	NUMBER	(15)	Yes
DISB_GROSS_AMT	NUMBER	(12)	Yes
FEE_1	NUMBER	(12)
FEE_2	NUMBER	(12)
DISB_NET_AMT	NUMBER	(12)	Yes
DISB_ADJ_AMT	NUMBER	(12)
DISB_DATE	DATE		Yes
FEE_PAID_1	NUMBER	(12)
FEE_PAID_2	NUMBER	(12)
DISB_ACTIVITY	VARCHAR2	(30)
DISB_BATCH_ID	VARCHAR2	(0)		No longer used.
DISB_ACK_DATE	VARCHAR2	(0)		No longer used.
BOOKING_BATCH_ID	VARCHAR2	(0)		No longer used.
BOOKED_DATE	VARCHAR2	(0)		No longer used.
DISB_STATUS	VARCHAR2	(0)		No longer used.
DISB_STATUS_DATE	VARCHAR2	(0)		No longer used.
SF_STATUS	VARCHAR2	(30)
SF_STATUS_DATE	DATE
SF_INVOICE_NUM	NUMBER	(15)
SPNSR_CREDIT_ID	NUMBER	(15)
SPNSR_CHARGE_ID	NUMBER	(15)
SF_CREDIT_ID	NUMBER	(15)
ERROR_DESC	VARCHAR2	(2000)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
NOTIFICATION_DATE	DATE			This is Correspondence Process Date, updated by post process once the Loan Disbursement Letter has been sent to the student
DISB_STATUS_DESC	VARCHAR2	(4000)		Indicates Disbursement Status for Direct Loan Disbursements
DISB_ACTIVITY_DESC	VARCHAR2	(4000)		Indicates Disbursement Activity for Direct Loan Disbursements
SF_STATUS_DESC	VARCHAR2	(4000)		Indicates Transaction Status
INTEREST_REBATE_AMT	NUMBER			Indicates interest rebate amount.
LD_CAL_TYPE	VARCHAR2	(10)		Load calendar Type
LD_SEQUENCE_NUMBER	NUMBER	(6)		Load Sequence Number
LD_ALTERNATE_CODE	VARCHAR2	(10)

Query Text

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


SELECT ROW_ID
,      AWARD_ID
,      DISB_NUM
,      DISB_SEQ_NUM
,      DISB_GROSS_AMT
,      FEE_1
,      FEE_2
,      DISB_NET_AMT
,      DISB_ADJ_AMT
,      DISB_DATE
,      FEE_PAID_1
,      FEE_PAID_2
,      DISB_ACTIVITY
,      DISB_BATCH_ID
,      DISB_ACK_DATE
,      BOOKING_BATCH_ID
,      BOOKED_DATE
,      DISB_STATUS
,      DISB_STATUS_DATE
,      SF_STATUS
,      SF_STATUS_DATE
,      SF_INVOICE_NUM
,      SPNSR_CREDIT_ID
,      SPNSR_CHARGE_ID
,      SF_CREDIT_ID
,      ERROR_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NOTIFICATION_DATE
,      DISB_STATUS_DESC
,      DISB_ACTIVITY_DESC
,      SF_STATUS_DESC
,      INTEREST_REBATE_AMT
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
,      LD_ALTERNATE_CODE
FROM APPS.IGF_DB_AWD_DISB_DTL_V;

Dependencies

[top of page]

APPS.IGF_DB_AWD_DISB_DTL_V references the following:

APPS: IGF_AW_GEN - show dependent code; IGF_DB_AWD_DISB_DTL; IGS_CA_INST_ALL

APPS.IGF_DB_AWD_DISB_DTL_V is not referenced by any database object