Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes all the columns related to non-standard unit section enrollment deadline setup |
Implementation/DBA Data: | Not implemented in this database |
SELECT NSUD.ROWID
, NSUD.NON_STD_USEC_DLS_ID
, NSUD.FUNCTION_NAME
, LKV1.MEANING
, NSUD.DEFINITION_CODE
, LKV2.MEANING
, NSUD.ORG_UNIT_CODE
, OU.DESCRIPTION
, NSUD.FORMULA_METHOD
, NSUD.ROUND_METHOD
, NSUD.OFFSET_DT_CODE
, LKV3.MEANING
, NSUD.OFFSET_DURATION
, NSUD.INCL_WKEND_DURATION_FLAG
, NSUD.CREATED_BY
, NSUD.CREATION_DATE
, NSUD.LAST_UPDATED_BY
, NSUD.LAST_UPDATE_DATE
, NSUD.LAST_UPDATE_LOGIN
FROM IGS_EN_NSU_DLSTP_ALL NSUD
, IGS_LOOKUPS_VIEW LKV1
, IGS_LOOKUPS_VIEW LKV2
, IGS_LOOKUPS_VIEW LKV3
, IGS_OR_UNIT OU
WHERE (LKV1.LOOKUP_CODE = NSUD.FUNCTION_NAME
AND LKV1.LOOKUP_TYPE = 'ENROLLMENT_FUNCTION')
AND (LKV2.LOOKUP_CODE = NSUD.DEFINITION_CODE
AND LKV2.LOOKUP_TYPE = 'DEFINITION_LEVEL')
AND (LKV3.LOOKUP_CODE = NSUD.OFFSET_DT_CODE
AND LKV3.LOOKUP_TYPE = 'OFFSET_DATE')
AND NSUD.ORG_UNIT_CODE = OU.ORG_UNIT_CD (+)
AND (NVL(NSUD.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) )