VIEW: APPS.IGS_PS_TYPE

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.course_type course_type, tab.description description, tab.govt_course_type govt_course_type, tab.award_course_ind award_course_ind, tab.course_type_group_cd course_type_group_cd, tab.tac_course_level tac_course_level, tab.research_type_ind research_type_ind, tab.closed_ind closed_ind, tab.primary_auto_select primary_auto_select, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login , tab.org_id org_id , tab.enrolment_cat enrolment_cat, tab.FIN_AID_PROGRAM_TYPE FROM igs_ps_type_all tab WHERE NVL (tab.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.GOVT_COURSE_TYPE GOVT_COURSE_TYPE
, TAB.AWARD_COURSE_IND AWARD_COURSE_IND
, TAB.COURSE_TYPE_GROUP_CD COURSE_TYPE_GROUP_CD
, TAB.TAC_COURSE_LEVEL TAC_COURSE_LEVEL
, TAB.RESEARCH_TYPE_IND RESEARCH_TYPE_IND
, TAB.CLOSED_IND CLOSED_IND
, TAB.PRIMARY_AUTO_SELECT PRIMARY_AUTO_SELECT
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
, TAB.ENROLMENT_CAT ENROLMENT_CAT
, TAB.FIN_AID_PROGRAM_TYPE
FROM IGS_PS_TYPE_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)