DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGF_AW_AWD_DISB

Object Details
Object Name: IGF_AW_AWD_DISB
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AW_AWD_DISB
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
TP_CAL_TYPE VARCHAR2 (10)
TP_SEQUENCE_NUMBER NUMBER (6)
DISB_GROSS_AMT NUMBER
Yes
FEE_1 NUMBER

FEE_2 NUMBER

DISB_NET_AMT NUMBER
Yes
DISB_DATE DATE
Yes
TRANS_TYPE VARCHAR2 (30) Yes
ELIG_STATUS VARCHAR2 (30)
ELIG_STATUS_DATE DATE

AFFIRM_FLAG VARCHAR2 (30)
HOLD_REL_IND VARCHAR2 (30)
MANUAL_HOLD_IND VARCHAR2 (30)
DISB_STATUS VARCHAR2 (30)
DISB_STATUS_DATE DATE

LATE_DISB_IND VARCHAR2 (30)
FUND_DIST_MTHD VARCHAR2 (1)
PREV_REPORTED_IND VARCHAR2 (30)
FUND_RELEASE_DATE DATE

FUND_STATUS VARCHAR2 (30)
FUND_STATUS_DATE DATE

FEE_PAID_1 NUMBER

FEE_PAID_2 NUMBER

CHEQUE_NUMBER VARCHAR2 (30)
LD_CAL_TYPE VARCHAR2 (10) Yes
LD_SEQUENCE_NUMBER NUMBER (6) Yes
DISB_ACCEPTED_AMT NUMBER (13)
DISB_PAID_AMT NUMBER (13)
RVSN_ID NUMBER (15)
INT_REBATE_AMT NUMBER (15)
FORCE_DISB VARCHAR2 (30)
DISB_EXP_DT DATE

MIN_CREDIT_PTS NUMBER (7)
VERF_ENFR_DT DATE

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_SENT VARCHAR2 (0)
No longer used.
NOTIFICATION_DATE VARCHAR2 (0)
No longer used.
AUTH_ID VARCHAR2 (0)
No longer used.
AUTH_DATE VARCHAR2 (0)
No longer used.
FEE_CLASS VARCHAR2 (30)
Fee Class for which the fund can be disbursed
SHOW_ON_BILL VARCHAR2 (30)
ATTENDANCE_TYPE_CODE VARCHAR2 (30)
Attendance Type Code
BASE_ATTENDANCE_TYPE_CODE VARCHAR2 (30)
Attendance Type of the disbursement when disbursement is created/modified.
PAYMENT_PRD_ST_DATE DATE

Starting date of the Payment period
CHANGE_TYPE_CODE VARCHAR2 (30)
Change Type Code for CommonLine Disbursement Change Record
FUND_RETURN_MTHD_CODE VARCHAR2 (30)
Fund Return Method Code for CommonLine Disbursement Change Record
DIRECT_TO_BORR_FLAG VARCHAR2 (1)
Direct Disbursement to Borrower Indicator
Query Text

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


SELECT ROW_ID
,      AWARD_ID
,      DISB_NUM
,      TP_CAL_TYPE
,      TP_SEQUENCE_NUMBER
,      DISB_GROSS_AMT
,      FEE_1
,      FEE_2
,      DISB_NET_AMT
,      DISB_DATE
,      TRANS_TYPE
,      ELIG_STATUS
,      ELIG_STATUS_DATE
,      AFFIRM_FLAG
,      HOLD_REL_IND
,      MANUAL_HOLD_IND
,      DISB_STATUS
,      DISB_STATUS_DATE
,      LATE_DISB_IND
,      FUND_DIST_MTHD
,      PREV_REPORTED_IND
,      FUND_RELEASE_DATE
,      FUND_STATUS
,      FUND_STATUS_DATE
,      FEE_PAID_1
,      FEE_PAID_2
,      CHEQUE_NUMBER
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
,      DISB_ACCEPTED_AMT
,      DISB_PAID_AMT
,      RVSN_ID
,      INT_REBATE_AMT
,      FORCE_DISB
,      DISB_EXP_DT
,      MIN_CREDIT_PTS
,      VERF_ENFR_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NOTIFICATION_SENT
,      NOTIFICATION_DATE
,      AUTH_ID
,      AUTH_DATE
,      FEE_CLASS
,      SHOW_ON_BILL
,      ATTENDANCE_TYPE_CODE
,      BASE_ATTENDANCE_TYPE_CODE
,      PAYMENT_PRD_ST_DATE
,      CHANGE_TYPE_CODE
,      FUND_RETURN_MTHD_CODE
,      DIRECT_TO_BORR_FLAG
FROM APPS.IGF_AW_AWD_DISB;

Dependencies

[top of page]

APPS.IGF_AW_AWD_DISB references the following:

SchemaAPPS
SynonymIGF_AW_AWD_DISB_ALL
APPS.IGF_AW_AWD_DISB is referenced by following:

SchemaAPPS
ViewIGF_AW_AWDS_SUM_V
Package BodyIGF_AW_AWD_DISB_PKG - show dependent code
ViewIGF_AW_AWD_DISB_V
Package BodyIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_AW_GEN - show dependent code
Package BodyIGF_AW_GEN_003 - show dependent code
Package BodyIGF_AW_GEN_004 - show dependent code
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_SS_GEN_PKG - show dependent code
ViewIGF_AW_STUD_AWDS_V
Package BodyIGF_DB_CL_ROSTER - show dependent code
Package BodyIGF_DB_DISB - show dependent code
Package BodyIGF_DB_DISB_HOLDS_PKG - show dependent code
ViewIGF_DB_DL_DISB_DTL_V
Package BodyIGF_DB_DL_DISB_ORIG - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_GR_GEN - show dependent code
Package BodyIGF_GR_GEN_XML - show dependent code
Package BodyIGF_GR_LI_IMPORT - show dependent code
Package BodyIGF_GR_PELL - show dependent code
Package BodyIGF_GR_REPACKAGE - show dependent code
ViewIGF_SE_EARNINGS_SUMMARY_V
Package BodyIGF_SE_GEN_001 - show dependent code
Package BodyIGF_SL_AWARD - show dependent code
Package BodyIGF_SL_CL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_CL_ORIG - show dependent code
Package BodyIGF_SL_CL_ORIG_ACK - show dependent code
Package BodyIGF_SL_CL_VALIDATION - show dependent code
Package BodyIGF_SL_DL_CHG_ORIG - show dependent code
Package BodyIGF_SL_DL_ORIG - show dependent code
Package BodyIGF_SL_DL_PNOTE_ACK - show dependent code
Package BodyIGF_SL_DL_RECORD - show dependent code
Package BodyIGF_SL_DL_VALIDATION - show dependent code
PL/SQL PackageIGF_SL_GEN - show dependent code
Package BodyIGF_SL_GEN - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code
PL/SQL PackageIGF_SP_AWARD - show dependent code
Package BodyIGF_SP_AWARD - show dependent code
ViewIGF_SP_AWARD_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_GEN_001 - show dependent code
ViewIGS_FI_PLN_CREDITS_V
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code