VIEW: APPS.IGS_AD_APPL_PGMAPPRV_V

Source

View Text - Preformatted

SELECT AP.ROWID ROW_ID, AP.APPL_PGMAPPRV_ID APPL_PGMAPPRV_ID, AP.PERSON_ID PERSON_ID, P.PERSON_NUMBER PERSON_NUMBER, AP.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER, AP.NOMINATED_COURSE_CD NOMINATED_COURSE_CD, AP.SEQUENCE_NUMBER SEQUENCE_NUMBER, AP.PGM_APPROVER_ID PGM_APPROVER_ID, P.FULL_NAME FULL_NAME, AP.ASSIGN_TYPE ASSIGN_TYPE, AP.ASSIGN_DATE ASSIGN_DATE, AP.PROGRAM_APPROVAL_DATE PROGRAM_APPROVAL_DATE, AP.PROGRAM_APPROVAL_STATUS PROGRAM_APPROVAL_STATUS, L.MEANING MEANING, AP.APPROVAL_NOTES APPROVAL_NOTES, AP.CREATED_BY CREATED_BY, AP.CREATION_DATE CREATION_DATE, AP.LAST_UPDATED_BY LAST_UPDATED_BY, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE, AP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AP.REQUEST_ID REQUEST_ID, AP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, AP.PROGRAM_ID PROGRAM_ID, AP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE FROM IGS_AD_APPL_PGMAPPRV AP, IGS_LOOKUP_VALUES L, IGS_PE_PERSON_BASE_V P WHERE AP.PROGRAM_APPROVAL_STATUS = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'PROGRAM_APPROVAL_STATUS' AND AP.PGM_APPROVER_ID = P.PERSON_ID

View Text - HTML Formatted

SELECT AP.ROWID ROW_ID
, AP.APPL_PGMAPPRV_ID APPL_PGMAPPRV_ID
, AP.PERSON_ID PERSON_ID
, P.PERSON_NUMBER PERSON_NUMBER
, AP.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AP.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AP.PGM_APPROVER_ID PGM_APPROVER_ID
, P.FULL_NAME FULL_NAME
, AP.ASSIGN_TYPE ASSIGN_TYPE
, AP.ASSIGN_DATE ASSIGN_DATE
, AP.PROGRAM_APPROVAL_DATE PROGRAM_APPROVAL_DATE
, AP.PROGRAM_APPROVAL_STATUS PROGRAM_APPROVAL_STATUS
, L.MEANING MEANING
, AP.APPROVAL_NOTES APPROVAL_NOTES
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AP.REQUEST_ID REQUEST_ID
, AP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AP.PROGRAM_ID PROGRAM_ID
, AP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_AD_APPL_PGMAPPRV AP
, IGS_LOOKUP_VALUES L
, IGS_PE_PERSON_BASE_V P
WHERE AP.PROGRAM_APPROVAL_STATUS = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'PROGRAM_APPROVAL_STATUS'
AND AP.PGM_APPROVER_ID = P.PERSON_ID