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

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[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
INTEREST_REBATE_AMT	NUMBER			Indicates interest rebate amount.
LD_CAL_TYPE	VARCHAR2	(10)		Load calendar Type
LD_SEQUENCE_NUMBER	NUMBER	(6)		Load Sequence Number

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
,      INTEREST_REBATE_AMT
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
FROM APPS.IGF_DB_AWD_DISB_DTL;

Dependencies

[top of page]

APPS.IGF_DB_AWD_DISB_DTL references the following:

APPS: IGF_DB_AWD_DISB_DTL_ALL

APPS.IGF_DB_AWD_DISB_DTL is referenced by following:

APPS: IGF_AW_CANCEL_AWD - show dependent code; IGF_AW_GEN - show dependent code; IGF_DB_AWD_DISB_DTL_PKG - show dependent code; IGF_DB_AWD_DISB_DTL_V; IGF_DB_DISB - show dependent code; IGF_DB_DL_DISB_DTL_V; IGF_DB_SF_INTEGRATION - show dependent code; IGF_GR_GEN - show dependent code; IGF_SP_AWARD - show dependent code; IGS_FI_GEN_REFUNDS - show dependent code