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