VIEW: APPS.IGSFV_CONCENTRATIONS

Source

View Text - Preformatted

SELECT USET.UNIT_SET_CD, USET.VERSION_NUMBER, USET.UNIT_SET_STATUS, USET.UNIT_SET_CAT, USET.START_DT, USET.REVIEW_DT, USET.EXPIRY_DT, USET.END_DT, USET.TITLE, USET.SHORT_TITLE, USET.ABBREVIATION, USET.RESPONSIBLE_ORG_UNIT_CD, USET.RESPONSIBLE_OU_START_DT, USET.ADMINISTRATIVE_IND, '_LA:ADMINISTRATIVE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', AUTHORISATION_RQRD_IND, '_LA:AUTHORISATION_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', STAT.DESCRIPTION, CAT.DESCRIPTION, ORG.PARTY_NAME, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:USET', USET.CREATED_BY, USET.CREATION_DATE, USET.LAST_UPDATED_BY, USET.LAST_UPDATE_DATE FROM IGS_EN_UNIT_SET_ALL USET, IGS_EN_UNIT_SET_STAT STAT, IGS_EN_UNIT_SET_CAT CAT, HZ_PARTIES ORG , IGS_PE_HZ_PARTIES IHP WHERE STAT.UNIT_SET_STATUS = USET.UNIT_SET_STATUS AND CAT.UNIT_SET_CAT = USET.UNIT_SET_CAT AND USET.RESPONSIBLE_ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD (+) AND ORG.PARTY_ID = IHP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT USET.UNIT_SET_CD
, USET.VERSION_NUMBER
, USET.UNIT_SET_STATUS
, USET.UNIT_SET_CAT
, USET.START_DT
, USET.REVIEW_DT
, USET.EXPIRY_DT
, USET.END_DT
, USET.TITLE
, USET.SHORT_TITLE
, USET.ABBREVIATION
, USET.RESPONSIBLE_ORG_UNIT_CD
, USET.RESPONSIBLE_OU_START_DT
, USET.ADMINISTRATIVE_IND
, '_LA:ADMINISTRATIVE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AUTHORISATION_RQRD_IND
, '_LA:AUTHORISATION_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, STAT.DESCRIPTION
, CAT.DESCRIPTION
, ORG.PARTY_NAME
, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:USET'
, USET.CREATED_BY
, USET.CREATION_DATE
, USET.LAST_UPDATED_BY
, USET.LAST_UPDATE_DATE
FROM IGS_EN_UNIT_SET_ALL USET
, IGS_EN_UNIT_SET_STAT STAT
, IGS_EN_UNIT_SET_CAT CAT
, HZ_PARTIES ORG
, IGS_PE_HZ_PARTIES IHP
WHERE STAT.UNIT_SET_STATUS = USET.UNIT_SET_STATUS
AND CAT.UNIT_SET_CAT = USET.UNIT_SET_CAT
AND USET.RESPONSIBLE_ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD (+)
AND ORG.PARTY_ID = IHP.PARTY_ID WITH READ ONLY