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.IGS_DA_SETUP_V

Object Details

Object Name:	IGS_DA_SETUP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_DA_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)		Rowid
S_CONTROL_NUM	NUMBER	(1)	Yes	PK, default to 1
PROGRAM_DEFINITION_IND	VARCHAR2	(1)	Yes	Determines what program information is sent to third party software
DEFAULT_STUDENT_ID_TYPE	VARCHAR2	(30)		Determines what student id value is sent to third party software
DEFAULT_INST_ID_TYPE	VARCHAR2	(30)		Determines what institution id value is sent to third party software
DEFAULT_ADDRESS_TYPE	VARCHAR2	(30)	Yes	Determines what address information is sent to third party software
WIF_MAJOR_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF majors in self service
WIF_MINOR_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF minors in self service
WIF_TRACK_UNIT_SET_CAT	VARCHAR2	(10)	Yes	Determines what unit set values are displayed for WIF tracks in self service
WIF_UNIT_SET_TITLE	VARCHAR2	(30)	Yes	Determines what unit set titles are displayed for WIF unit sets in self service
THIRD_PARTY_OPTIONS	VARCHAR2	(30)	Yes	Determines which request features are displayed in request template configuration
DISPLAY_CONTAINER_IND	VARCHAR2	(1)	Yes	Determines whether or not to display the content container containing a link to the third party software
CONTAINER_TITLE	VARCHAR2	(100)		Contains the title to be displayed in the content container
LINK_TEXT	VARCHAR2	(100)		Contains the link text to be displayed in the content container
LINK_URL	VARCHAR2	(256)		Contains the URL to the third party software
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 ROW_ID
,      S_CONTROL_NUM
,      PROGRAM_DEFINITION_IND
,      DEFAULT_STUDENT_ID_TYPE
,      DEFAULT_INST_ID_TYPE
,      DEFAULT_ADDRESS_TYPE
,      WIF_MAJOR_UNIT_SET_CAT
,      WIF_MINOR_UNIT_SET_CAT
,      WIF_TRACK_UNIT_SET_CAT
,      WIF_UNIT_SET_TITLE
,      THIRD_PARTY_OPTIONS
,      DISPLAY_CONTAINER_IND
,      CONTAINER_TITLE
,      LINK_TEXT
,      LINK_URL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_DA_SETUP_V;

Dependencies

[top of page]

APPS.IGS_DA_SETUP_V references the following:

APPS: IGS_DA_SETUP

APPS.IGS_DA_SETUP_V is not referenced by any database object