VIEW: APPS.IGS_AS_UAI_EXAM_CI_INIT_V

Source

View Text - Preformatted

SELECT CI.CAL_TYPE , CI.SEQUENCE_NUMBER , UAI.UNIT_CD , UAI.VERSION_NUMBER , UAI.CAL_TYPE , UAI.CI_SEQUENCE_NUMBER , UAI.ASS_ID , UAI.SEQUENCE_NUMBER , UAI.CI_START_DT , UAI.CI_END_DT , UAI. UNIT_CLASS , UAI.UNIT_MODE , UAI.LOCATION_CD , UAI.DUE_DT , UAI.REFERENCE , UAI.DFLT_ITEM_IND , UAI.LOGICAL_DELETE_DT , UAI.ACTION_DT , UAI.EXAM_CAL_TYPE , UAI.EXAM_CI_SEQUENCE_NUMBER , UAI.created_by , UAI.creation_date , UAI.last_updated_by , UAI.last_update_date , UAI.last_update_login FROM IGS_AS_UNITASS_ITEM UAI, IGS_AS_ASSESSMNT_ITM AI, IGS_AS_ASSESSMNT_TYP AT, IGS_CA_INST CI, IGS_CA_TYPE CAT, IGS_CA_STAT CS WHERE UAI.LOGICAL_DELETE_DT IS NULL AND AI.ASS_ID = UAI.ASS_ID AND AI.EXAM_SCHEDULED_IND = 'Y' AND AT.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE AND AT.EXAMINABLE_IND = 'Y' AND CAT.CAL_TYPE = CI.CAL_TYPE AND CAT.S_CAL_CAT = 'EXAM' AND CS.CAL_STATUS = CI.CAL_STATUS AND CS.S_CAL_STATUS = 'ACTIVE' AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE,CI.SEQUENCE_NUMBER, UAI.CAL_TYPE, UAI.CI_SEQUENCE_NUMBER, 'N') = 'Y'

View Text - HTML Formatted

SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.CI_START_DT
, UAI.CI_END_DT
, UAI. UNIT_CLASS
, UAI.UNIT_MODE
, UAI.LOCATION_CD
, UAI.DUE_DT
, UAI.REFERENCE
, UAI.DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT
, UAI.ACTION_DT
, UAI.EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
FROM IGS_AS_UNITASS_ITEM UAI
, IGS_AS_ASSESSMNT_ITM AI
, IGS_AS_ASSESSMNT_TYP AT
, IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE UAI.LOGICAL_DELETE_DT IS NULL
AND AI.ASS_ID = UAI.ASS_ID
AND AI.EXAM_SCHEDULED_IND = 'Y'
AND AT.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE
AND AT.EXAMINABLE_IND = 'Y'
AND CAT.CAL_TYPE = CI.CAL_TYPE
AND CAT.S_CAL_CAT = 'EXAM'
AND CS.CAL_STATUS = CI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, 'N') = 'Y'