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

VIEW: APPS.IGF_SL_DL_CHG_FLD_V

Object Details
Object Name: IGF_SL_DL_CHG_FLD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_SL_DL_CHG_FLD_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGF_SL_DL_CHG_FLD_V selects the change field codes for Direct Loans. These codes are used to send the changed information from the school to the LOC.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DL_VERSION VARCHAR2 (30) Yes Indicates different releases of Direct Loan specifications
LOAN_CATG VARCHAR2 (30) Yes Indicates Direct Loan category
CHG_CODE VARCHAR2 (30) Yes Indicates change field numbers, which are pre-defined
FLD_NAME VARCHAR2 (30) Yes Indicates database field name, whose value changes
FLD_LENGTH NUMBER (15)
Indicates maximum string length for field in change file
DESCRIPTION VARCHAR2 (80) Yes Indicates description of field changed
ENABLED VARCHAR2 (1) Yes Indicates whether field's value changes should be sent to LOC
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
Query Text

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


SELECT DL_VERSION
,      LOAN_CATG
,      CHG_CODE
,      FLD_NAME
,      FLD_LENGTH
,      DESCRIPTION
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGF_SL_DL_CHG_FLD_V;

Dependencies

[top of page]

APPS.IGF_SL_DL_CHG_FLD_V references the following:

SchemaAPPS
ViewIGF_LOOKUPS_VIEW
SynonymIGF_SL_DL_CHG_FLD
APPS.IGF_SL_DL_CHG_FLD_V is referenced by following:

SchemaAPPS
Package BodyIGF_SL_DL_CHG_ACK - show dependent code