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

VIEW: APPS.IGF_AP_TD_ITEM_MST

Object Details
Object Name: IGF_AP_TD_ITEM_MST
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_TD_ITEM_MST
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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TODO_NUMBER NUMBER (15) Yes
ITEM_CODE VARCHAR2 (10) Yes
CI_CAL_TYPE VARCHAR2 (10)
CI_SEQUENCE_NUMBER NUMBER (15)
DESCRIPTION VARCHAR2 (30) Yes
CORSP_MESG VARCHAR2 (240)
CAREER_ITEM VARCHAR2 (30) Yes
REQUIRED_FOR_APPLICATION VARCHAR2 (30)
FREQ_ATTEMPT NUMBER (15)
MAX_ATTEMPT NUMBER (15)
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)
ORG_ID NUMBER (15)
Operating unit identifier
SYSTEM_TODO_TYPE_CODE VARCHAR2 (30)
System To Do Type
APPLICATION_CODE VARCHAR2 (30)
Institutional Application to which the to do item is linked to
DISPLAY_IN_SS_FLAG VARCHAR2 (1)
Indicates whether the to do item is displayed to the student in self service
SS_INSTRUCTION_TXT VARCHAR2 (4000)
Instruction text that the student views in his to do list.
ALLOW_ATTACHMENT_FLAG VARCHAR2 (1)
Indicates whether the student can attach documents to the to do item
DOCUMENT_URL_TXT VARCHAR2 (240)
A URL pointing to a document that the student has to download and fill to complete the to do item
Query Text

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


SELECT ROW_ID
,      TODO_NUMBER
,      ITEM_CODE
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      DESCRIPTION
,      CORSP_MESG
,      CAREER_ITEM
,      REQUIRED_FOR_APPLICATION
,      FREQ_ATTEMPT
,      MAX_ATTEMPT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      SYSTEM_TODO_TYPE_CODE
,      APPLICATION_CODE
,      DISPLAY_IN_SS_FLAG
,      SS_INSTRUCTION_TXT
,      ALLOW_ATTACHMENT_FLAG
,      DOCUMENT_URL_TXT
FROM APPS.IGF_AP_TD_ITEM_MST;

Dependencies

[top of page]

APPS.IGF_AP_TD_ITEM_MST references the following:

SchemaAPPS
SynonymIGF_AP_TD_ITEM_MST_ALL
APPS.IGF_AP_TD_ITEM_MST is referenced by following:

SchemaAPPS
Package BodyIGF_AP_ISIR_GEN_PKG - show dependent code
Package BodyIGF_AP_MATCHING_PROCESS_PKG - show dependent code
Package BodyIGF_AP_PROFILE_MATCHING_PKG - show dependent code
ViewIGF_AP_TD_ITEM_INST_V
Package BodyIGF_AP_TD_ITEM_MST_PKG - show dependent code
ViewIGF_AP_TD_ITEM_MST_V
Package BodyIGF_AP_TODO_GRPS_PRC_PKG - show dependent code
Package BodyIGF_AP_VER_GRPS_PRC_PKG - show dependent code
ViewIGF_AW_FUND_TD_MAP_V
Package BodyIGF_AW_LI_IMPORT - show dependent code
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_ROLLOVER - show dependent code