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.

[Home] [Help]

View: IGF_AP_TD_ITEM_MST_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_AP_TD_ITEM_MST_V

View Text

SELECT TDV.ROW_ID ROW_ID
, TDV.TODO_NUMBER
, TDV.ITEM_CODE
, TDV.CI_CAL_TYPE
, TDV.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE AWARD_YEAR
, CA.START_DT
, CA.END_DT
, TDV.DESCRIPTION
, TDV.CORSP_MESG
, TDV.CAREER_ITEM
, TDV.REQUIRED_FOR_APPLICATION
, TDV.FREQ_ATTEMPT
, TDV.MAX_ATTEMPT
, TDV.CREATED_BY
, TDV.CREATION_DATE
, TDV.LAST_UPDATED_BY
, TDV.LAST_UPDATE_DATE
, TDV.LAST_UPDATE_LOGIN
, TDV.SYSTEM_TODO_TYPE_CODE
, LK.MEANING
, TDV.APPLICATION_CODE
, TDV.DISPLAY_IN_SS_FLAG
, TDV.SS_INSTRUCTION_TXT
, TDV.ALLOW_ATTACHMENT_FLAG
, TDV.DOCUMENT_URL_TXT
, INSTAPP.APPLICATION_NAME
FROM IGF_AP_TD_ITEM_MST TDV
, IGS_CA_INST CA
, IGF_LOOKUPS_VIEW LK
, (SELECT CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, APPLICATION_CODE
, APPLICATION_NAME
FROM IGF_AP_APPL_SETUP GROUP BY CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, APPLICATION_CODE
, APPLICATION_NAME) INSTAPP
WHERE TDV.CI_CAL_TYPE = CA.CAL_TYPE(+)
AND TDV.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)
AND TDV.SYSTEM_TODO_TYPE_CODE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'IGF_AP_SYSTEM_TODO_TYPE'
AND LK.ENABLED_FLAG = 'Y'
AND TDV.APPLICATION_CODE = INSTAPP.APPLICATION_CODE
AND TDV.CI_CAL_TYPE = INSTAPP.CI_CAL_TYPE
AND TDV.CI_SEQUENCE_NUMBER = INSTAPP.CI_SEQUENCE_NUMBER
AND TDV.APPLICATION_CODE IS NOT NULL UNION ALL SELECT TDV.ROW_ID ROW_ID
, TDV.TODO_NUMBER
, TDV.ITEM_CODE
, TDV.CI_CAL_TYPE
, TDV.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE AWARD_YEAR
, CA.START_DT
, CA.END_DT
, TDV.DESCRIPTION
, TDV.CORSP_MESG
, TDV.CAREER_ITEM
, TDV.REQUIRED_FOR_APPLICATION
, TDV.FREQ_ATTEMPT
, TDV.MAX_ATTEMPT
, TDV.CREATED_BY
, TDV.CREATION_DATE
, TDV.LAST_UPDATED_BY
, TDV.LAST_UPDATE_DATE
, TDV.LAST_UPDATE_LOGIN
, TDV.SYSTEM_TODO_TYPE_CODE
, LK.MEANING
, TDV.APPLICATION_CODE
, TDV.DISPLAY_IN_SS_FLAG
, TDV.SS_INSTRUCTION_TXT
, TDV.ALLOW_ATTACHMENT_FLAG
, TDV.DOCUMENT_URL_TXT
, NULL APPLICATION_NAME
FROM IGF_AP_TD_ITEM_MST TDV
, IGS_CA_INST CA
, IGF_LOOKUPS_VIEW LK
WHERE TDV.CI_CAL_TYPE = CA.CAL_TYPE(+)
AND TDV.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)
AND TDV.SYSTEM_TODO_TYPE_CODE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'IGF_AP_SYSTEM_TODO_TYPE'
AND LK.ENABLED_FLAG = 'Y'
AND TDV.APPLICATION_CODE IS NULL

Columns

Name
ROW_ID
TODO_NUMBER
ITEM_CODE
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
AWARD_YEAR
START_DT
END_DT
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
SYSTEM_TODO_TYPE_CODE
SYSTEM_TODO_TYPE_DESC
APPLICATION_CODE
DISPLAY_IN_SS_FLAG
SS_INSTRUCTION_TXT
ALLOW_ATTACHMENT_FLAG
DOCUMENT_URL_TXT
APPLICATION_NAME