VIEW: APPS.IGS_EN_NSTD_USEC_DL_V

Source

View Text - Preformatted

SELECT nsdl.rowid, nsdl. nstd_usec_dl_id, nsdl.non_std_usec_dls_id, nsdl.uoo_id, nsdl.enr_dl_date, nsdl.enr_dl_total_days , nsdl.enr_dl_offset_days, nsdl.function_name, lkv1.meaning , nsdl.definition_code, lkv2.meaning, nsdl.org_unit_code, ou.description , nsdl.formula_method, nsdl.round_method, nsdl.offset_dt_code, lkv3.meaning, nsdl.offset_duration, nsdl.created_by, nsdl.creation_date , nsdl.last_updated_by , nsdl.last_update_date, nsdl.last_update_login FROM igs_en_nstd_usec_dl nsdl, igs_or_unit ou, igs_lookups_view lkv1, igs_lookups_view lkv2, igs_lookups_view lkv3 WHERE nsdl.org_unit_code = ou.org_unit_cd (+) AND (lkv1.lookup_code (+) = nsdl.function_name AND lkv1.lookup_type(+) = 'ENROLLMENT_FUNCTION') and (lkv2.lookup_code (+) = nsdl.definition_code AND lkv2.lookup_type(+) = 'DEFINITION_LEVEL') AND (lkv3.lookup_code (+) = nsdl.offset_dt_code AND lkv3.lookup_type(+) = 'OFFSET_DATE')

View Text - HTML Formatted

SELECT NSDL.ROWID
, NSDL. NSTD_USEC_DL_ID
, NSDL.NON_STD_USEC_DLS_ID
, NSDL.UOO_ID
, NSDL.ENR_DL_DATE
, NSDL.ENR_DL_TOTAL_DAYS
, NSDL.ENR_DL_OFFSET_DAYS
, NSDL.FUNCTION_NAME
, LKV1.MEANING
, NSDL.DEFINITION_CODE
, LKV2.MEANING
, NSDL.ORG_UNIT_CODE
, OU.DESCRIPTION
, NSDL.FORMULA_METHOD
, NSDL.ROUND_METHOD
, NSDL.OFFSET_DT_CODE
, LKV3.MEANING
, NSDL.OFFSET_DURATION
, NSDL.CREATED_BY
, NSDL.CREATION_DATE
, NSDL.LAST_UPDATED_BY
, NSDL.LAST_UPDATE_DATE
, NSDL.LAST_UPDATE_LOGIN
FROM IGS_EN_NSTD_USEC_DL NSDL
, IGS_OR_UNIT OU
, IGS_LOOKUPS_VIEW LKV1
, IGS_LOOKUPS_VIEW LKV2
, IGS_LOOKUPS_VIEW LKV3
WHERE NSDL.ORG_UNIT_CODE = OU.ORG_UNIT_CD (+)
AND (LKV1.LOOKUP_CODE (+) = NSDL.FUNCTION_NAME
AND LKV1.LOOKUP_TYPE(+) = 'ENROLLMENT_FUNCTION')
AND (LKV2.LOOKUP_CODE (+) = NSDL.DEFINITION_CODE
AND LKV2.LOOKUP_TYPE(+) = 'DEFINITION_LEVEL')
AND (LKV3.LOOKUP_CODE (+) = NSDL.OFFSET_DT_CODE
AND LKV3.LOOKUP_TYPE(+) = 'OFFSET_DATE')