VIEW: APPS.IGS_PE_ACAD_INTENTS_V

Source

View Text - Preformatted

SELECT ACAD.ROWID ROW_ID, ACAD.ACAD_INTENT_ID, ACAD.PERSON_ID, ACAD.CAL_TYPE, ACAD.SEQUENCE_NUMBER, ACAD.ACAD_INTENT_CODE, CAL.DESCRIPTION CALENDAR_DESC, LKUPS.MEANING ACAD_INTENT_DESC, CAL.START_DT, CAL.END_DT, ACAD.ACTIVE_FLAG, ACAD.CREATED_BY, ACAD.CREATION_DATE, ACAD.LAST_UPDATED_BY, ACAD.LAST_UPDATE_DATE, ACAD.LAST_UPDATE_LOGIN FROM IGS_PE_ACAD_INTENTS ACAD, IGS_CA_INST_ALL CAL, IGS_LOOKUP_VALUES LKUPS WHERE ACAD.CAL_TYPE = CAL.CAL_TYPE AND ACAD.SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER AND ACAD.ACAD_INTENT_CODE = LKUPS.LOOKUP_CODE AND LKUPS.LOOKUP_TYPE = 'PE_ACAD_INTENTS'

View Text - HTML Formatted

SELECT ACAD.ROWID ROW_ID
, ACAD.ACAD_INTENT_ID
, ACAD.PERSON_ID
, ACAD.CAL_TYPE
, ACAD.SEQUENCE_NUMBER
, ACAD.ACAD_INTENT_CODE
, CAL.DESCRIPTION CALENDAR_DESC
, LKUPS.MEANING ACAD_INTENT_DESC
, CAL.START_DT
, CAL.END_DT
, ACAD.ACTIVE_FLAG
, ACAD.CREATED_BY
, ACAD.CREATION_DATE
, ACAD.LAST_UPDATED_BY
, ACAD.LAST_UPDATE_DATE
, ACAD.LAST_UPDATE_LOGIN
FROM IGS_PE_ACAD_INTENTS ACAD
, IGS_CA_INST_ALL CAL
, IGS_LOOKUP_VALUES LKUPS
WHERE ACAD.CAL_TYPE = CAL.CAL_TYPE
AND ACAD.SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER
AND ACAD.ACAD_INTENT_CODE = LKUPS.LOOKUP_CODE
AND LKUPS.LOOKUP_TYPE = 'PE_ACAD_INTENTS'