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

VIEW: APPS.IGF_AW_SS_DISB_V

Object Details
Object Name: IGF_AW_SS_DISB_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AW_SS_DISB_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
AWARD_ID NUMBER (15) Yes Unique identifier for awards
FUND_ID NUMBER (15) Yes Unique identifier for each fund
OFFERED_AMT NUMBER

Total award amount offered
ACCEPTED_AMT NUMBER

Total award amount accepted
PAID_AMT NUMBER

Amount of award already paid
AWARD_STATUS VARCHAR2 (30)
Current award's status code
LD_CAL_TYPE VARCHAR2 (10) Yes Indicates code for term calendar type.
LD_SEQUENCE_NUMBER NUMBER (6) Yes Indicates unique identifier for term calendar instance
AWARD_PRD_CD VARCHAR2 (30) Yes Unique Awarding Period code within the context Award Year
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates code for award year calendar type.
CI_SEQUENCE_NUMBER NUMBER
Yes Indicates unique identifier for award year calendar instance
AWARD_PRD_DESC VARCHAR2 (80) Yes Awarding Period Description
BASE_ID NUMBER (10) Yes Identifier for student financial aid record
Query Text

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


SELECT AWARD_ID
,      FUND_ID
,      OFFERED_AMT
,      ACCEPTED_AMT
,      PAID_AMT
,      AWARD_STATUS
,      LD_CAL_TYPE
,      LD_SEQUENCE_NUMBER
,      AWARD_PRD_CD
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      AWARD_PRD_DESC
,      BASE_ID
FROM APPS.IGF_AW_SS_DISB_V;

Dependencies

[top of page]

APPS.IGF_AW_SS_DISB_V references the following:

SchemaAPPS
SynonymIGF_AP_FA_BASE_REC_ALL
SynonymIGF_AW_AWARD_ALL
SynonymIGF_AW_AWARD_PRD
SynonymIGF_AW_AWD_DISB_ALL
SynonymIGF_AW_AWD_PRD_TERM
APPS.IGF_AW_SS_DISB_V is referenced by following:

SchemaAPPS
Package BodyIGF_AW_SS_GEN_PKG - show dependent code