VIEW: APPS.IGSFV_PROG_CONCENTRATIONS

Source

View Text - Preformatted

SELECT UST.UNIT_SET_CD UNIT_SET_CODE, UST.VERSION_NUMBER, UST.UNIT_SET_STATUS, UST.UNIT_SET_CAT UNIT_SET_CATEGORY, UST.START_DT START_DATE, UST.REVIEW_DT REVIEW_DATE, UST.EXPIRY_DT EXPIRY_DATE, UST.END_DT END_DATE, UST.TITLE, UST.SHORT_TITLE, UST.ABBREVIATION, UST.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE, UST.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE, UST.ADMINISTRATIVE_IND ADMINISTRATIVE_INDICATOR, UST.AUTHORISATION_RQRD_IND AUTHORISATION_RQRD_INDICATOR, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:UST', USS.DESCRIPTION UNIT_SET_STATUS_DESC, USC.DESCRIPTION UNIT_SET_CATEGORY_DESC, HP.PARTY_NAME RESP_ORG_UNIT_DESC, UST.CREATED_BY, UST.CREATION_DATE, UST.LAST_UPDATED_BY, UST.LAST_UPDATE_DATE FROM IGS_EN_UNIT_SET_ALL UST, IGS_EN_UNIT_SET_STAT USS, IGS_EN_UNIT_SET_CAT USC, IGS_OR_INST_ORG_BASE_V HP WHERE UST.UNIT_SET_STATUS=USS.UNIT_SET_STATUS AND UST.UNIT_SET_CAT=USC.UNIT_SET_CAT AND HP.PARTY_NUMBER(+)=UST.RESPONSIBLE_ORG_UNIT_CD WITH READ ONLY

View Text - HTML Formatted

SELECT UST.UNIT_SET_CD UNIT_SET_CODE
, UST.VERSION_NUMBER
, UST.UNIT_SET_STATUS
, UST.UNIT_SET_CAT UNIT_SET_CATEGORY
, UST.START_DT START_DATE
, UST.REVIEW_DT REVIEW_DATE
, UST.EXPIRY_DT EXPIRY_DATE
, UST.END_DT END_DATE
, UST.TITLE
, UST.SHORT_TITLE
, UST.ABBREVIATION
, UST.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, UST.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, UST.ADMINISTRATIVE_IND ADMINISTRATIVE_INDICATOR
, UST.AUTHORISATION_RQRD_IND AUTHORISATION_RQRD_INDICATOR
, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:UST'
, USS.DESCRIPTION UNIT_SET_STATUS_DESC
, USC.DESCRIPTION UNIT_SET_CATEGORY_DESC
, HP.PARTY_NAME RESP_ORG_UNIT_DESC
, UST.CREATED_BY
, UST.CREATION_DATE
, UST.LAST_UPDATED_BY
, UST.LAST_UPDATE_DATE
FROM IGS_EN_UNIT_SET_ALL UST
, IGS_EN_UNIT_SET_STAT USS
, IGS_EN_UNIT_SET_CAT USC
, IGS_OR_INST_ORG_BASE_V HP
WHERE UST.UNIT_SET_STATUS=USS.UNIT_SET_STATUS
AND UST.UNIT_SET_CAT=USC.UNIT_SET_CAT
AND HP.PARTY_NUMBER(+)=UST.RESPONSIBLE_ORG_UNIT_CD WITH READ ONLY