VIEW: APPS.IGS_EN_USEC_DISC_DL_V

Source

View Text - Preformatted

SELECT udd.rowid ROW_ID , udd.usec_disc_dl_id USEC_DISC_DL_ID , udd.non_std_disc_dl_stp_id NON_STD_DISC_DL_STP_ID, udd.uoo_id UOO_ID, udd.usec_disc_dl_date USEC_DISC_DL_DATE, udd.usec_disc_total_days USEC_DISC_TOTAL_DAYS, udd.usec_disc_offset_days USEC_DISC_OFFSET_DAYS, udd.administrative_unit_status ADMINISTRATIVE_UNIT_STATUS, aus.description DESCRIPTION, udd.definition_code DEFINITION_CODE, lkv1.meaning DEFINITION_CODE_MEANING, udd.org_unit_code ORG_UNIT_CODE, ou.party_name ORG_DESCRIPTION, udd.formula_method FORMULA_METHOD, udd.round_method ROUND_METHOD, udd.offset_dt_code OFFSET_DT_CODE, lkv2.meaning OFFSET_DT_CODE_MEANING, udd.offset_duration OFFSET_DURATION, udd.created_by CREATED_BY, udd.creation_date CREATION_DATE, udd.last_updated_by LAST_UPDATED_BY, udd.last_update_date LAST_UPDATE_DATE, udd.last_update_login LAST_UPDATE_LOGIN FROM igs_en_usec_disc_dl udd, igs_ad_adm_unit_stat aus, igs_lookup_values lkv1, igs_lookup_values lkv2, igs_or_inst_org_base_v ou WHERE udd.administrative_unit_status = aus.administrative_unit_status(+) AND (lkv1.lookup_code(+) = udd.definition_code AND lkv1.lookup_type(+) = 'DEFINITION_LEVEL') AND (lkv2.lookup_code(+) = udd.offset_dt_code AND lkv2.lookup_type(+) = 'OFFSET_DATE') AND udd.org_unit_code = ou.party_number (+) AND ou.inst_org_ind (+) = 'O'

View Text - HTML Formatted

SELECT UDD.ROWID ROW_ID
, UDD.USEC_DISC_DL_ID USEC_DISC_DL_ID
, UDD.NON_STD_DISC_DL_STP_ID NON_STD_DISC_DL_STP_ID
, UDD.UOO_ID UOO_ID
, UDD.USEC_DISC_DL_DATE USEC_DISC_DL_DATE
, UDD.USEC_DISC_TOTAL_DAYS USEC_DISC_TOTAL_DAYS
, UDD.USEC_DISC_OFFSET_DAYS USEC_DISC_OFFSET_DAYS
, UDD.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUS.DESCRIPTION DESCRIPTION
, UDD.DEFINITION_CODE DEFINITION_CODE
, LKV1.MEANING DEFINITION_CODE_MEANING
, UDD.ORG_UNIT_CODE ORG_UNIT_CODE
, OU.PARTY_NAME ORG_DESCRIPTION
, UDD.FORMULA_METHOD FORMULA_METHOD
, UDD.ROUND_METHOD ROUND_METHOD
, UDD.OFFSET_DT_CODE OFFSET_DT_CODE
, LKV2.MEANING OFFSET_DT_CODE_MEANING
, UDD.OFFSET_DURATION OFFSET_DURATION
, UDD.CREATED_BY CREATED_BY
, UDD.CREATION_DATE CREATION_DATE
, UDD.LAST_UPDATED_BY LAST_UPDATED_BY
, UDD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UDD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_USEC_DISC_DL UDD
, IGS_AD_ADM_UNIT_STAT AUS
, IGS_LOOKUP_VALUES LKV1
, IGS_LOOKUP_VALUES LKV2
, IGS_OR_INST_ORG_BASE_V OU
WHERE UDD.ADMINISTRATIVE_UNIT_STATUS = AUS.ADMINISTRATIVE_UNIT_STATUS(+)
AND (LKV1.LOOKUP_CODE(+) = UDD.DEFINITION_CODE
AND LKV1.LOOKUP_TYPE(+) = 'DEFINITION_LEVEL')
AND (LKV2.LOOKUP_CODE(+) = UDD.OFFSET_DT_CODE
AND LKV2.LOOKUP_TYPE(+) = 'OFFSET_DATE')
AND UDD.ORG_UNIT_CODE = OU.PARTY_NUMBER (+)
AND OU.INST_ORG_IND (+) = 'O'