VIEW: APPS.IGS_HE_ST_UNT_VS

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID ,A.HESA_ST_UNT_VS_ID HESA_ST_UNT_VS_ID ,A. UNIT_CD UNIT_CD ,A. VERSION_NUMBER VERSION_NUMBER ,A.PROP_OF_TEACHING_IN_WELSH PROP_OF_TEACHING_IN_WELSH ,A.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME ,A.MODULE_LENGTH MODULE_LENGTH ,A.PROPORTION_OF_FTE PROPORTION_OF_FTE ,A.LOCATION_CD LOCATION_CD ,A.CREATION_DATE CREATION_DATE ,A.CREATED_BY CREATED_BY ,A.LAST_UPDATE_DATE LAST_UPDATE_DATE ,A.LAST_UPDATED_BY LAST_UPDATED_BY ,A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,A.EXCLUDE_FLAG EXCLUDE_FLAG FROM IGS_HE_ST_UNT_VS_ALL A WHERE NVL (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 A.ROWID ROW_ID
, A.HESA_ST_UNT_VS_ID HESA_ST_UNT_VS_ID
, A. UNIT_CD UNIT_CD
, A. VERSION_NUMBER VERSION_NUMBER
, A.PROP_OF_TEACHING_IN_WELSH PROP_OF_TEACHING_IN_WELSH
, A.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME
, A.MODULE_LENGTH MODULE_LENGTH
, A.PROPORTION_OF_FTE PROPORTION_OF_FTE
, A.LOCATION_CD LOCATION_CD
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.EXCLUDE_FLAG EXCLUDE_FLAG
FROM IGS_HE_ST_UNT_VS_ALL A
WHERE NVL (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)