[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_CO_ITM

Object Details

Object Name:	IGS_CO_ITM
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_CO_ITM
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.

IGS_CO_ITM describes correspondence items that are sent to students. These may be system generated items or non system generated items that users have chosen to register against students.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CORRESPONDENCE_TYPE
,      REFERENCE_NUMBER
,      CREATE_DT
,      S_JOB_NAME
,      REQUEST_JOB_ID
,      OUTPUT_NUM
,      REQUEST_JOB_RUN_ID
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      COURSE_CD
,      CV_VERSION_NUMBER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ORIGINATOR_PERSON_ID
,      REQUEST_NUM
,      JOB_REQUEST_ID
,      ORG_ID
FROM APPS.IGS_CO_ITM;

Dependencies

[top of page]

APPS

IGS_CO_ITM_ALL

APPS

IGS_AD_GEN_011 - show dependent code

IGS_AS_GEN_006 - show dependent code

IGS_CO_GEN_002 - show dependent code

IGS_CO_GEN_002 - show dependent code

IGS_CO_ITM_V

IGS_CO_OU_CO_V

IGS_CO_PROCESS - show dependent code