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_SL_DL_SETUP_V

Object Details

Object Name:	IGF_SL_DL_SETUP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_DL_SETUP_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)
DLSET_ID	NUMBER	(15)	Yes
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates a unique identifier for the award year calender instance
CI_START_DT	DATE		Yes	Indicates the award year start date
CI_END_DT	DATE		Yes	Indicates the award year end date
CI_ALTERNATE_CODE	VARCHAR2	(10)		Indicates the alternate short reference code for identifying a award year calendar instance
SCHOOL_ID	VARCHAR2	(30)
ORIG_FEE_PERCT_STAFFORD	NUMBER	(12)	Yes
ORIG_FEE_PERCT_PLUS	NUMBER	(12)	Yes
INT_REBATE	NUMBER	(12)	Yes
PNOTE_PRINT_IND	VARCHAR2	(30)	Yes
PNOTE_PRINT_IND_DESC	VARCHAR2	(4000)
PNOTE_PRINT_COPIES	NUMBER	(15)	Yes
ACC_NOTE_FOR_DISB	VARCHAR2	(30)
AFFIRMATION_REQD	VARCHAR2	(30)
INTERVIEW_REQD	VARCHAR2	(30)
DISCLOSURE_PRINT_IND	VARCHAR2	(30)
DISCLOSURE_PRINT_DESC	VARCHAR2	(4000)
SPECIAL_SCHOOL	VARCHAR2	(30)
DL_VERSION	VARCHAR2	(30)
DL_VERSION_DESC	VARCHAR2	(4000)
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)
RESPONSE_OPTION_CODE	VARCHAR2	(30)		Indicates the response option code
RESPONSE_OPTION_DESC	VARCHAR2	(4000)		Indicates the response option
FUNDING_METHOD	VARCHAR2	(30)		Indicates the funding method code
FUNDING_METHOD_DESC	VARCHAR2	(4000)		Indicates the funding method

Query Text

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


SELECT ROW_ID
,      DLSET_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      CI_ALTERNATE_CODE
,      SCHOOL_ID
,      ORIG_FEE_PERCT_STAFFORD
,      ORIG_FEE_PERCT_PLUS
,      INT_REBATE
,      PNOTE_PRINT_IND
,      PNOTE_PRINT_IND_DESC
,      PNOTE_PRINT_COPIES
,      ACC_NOTE_FOR_DISB
,      AFFIRMATION_REQD
,      INTERVIEW_REQD
,      DISCLOSURE_PRINT_IND
,      DISCLOSURE_PRINT_DESC
,      SPECIAL_SCHOOL
,      DL_VERSION
,      DL_VERSION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESPONSE_OPTION_CODE
,      RESPONSE_OPTION_DESC
,      FUNDING_METHOD
,      FUNDING_METHOD_DESC
FROM APPS.IGF_SL_DL_SETUP_V;

Dependencies

[top of page]

APPS.IGF_SL_DL_SETUP_V references the following:

APPS: IGF_AW_GEN - show dependent code; IGF_SL_DL_SETUP; IGS_CA_INST

APPS.IGF_SL_DL_SETUP_V is referenced by following:

APPS: IGF_DB_DL_RECONC - show dependent code; IGF_SL_DL_PRINT_MANIFEST - show dependent code; IGF_SL_DL_PRINT_PNOTE - show dependent code; IGF_SL_DL_RECORD - show dependent code