VIEW: APPS.IGS_AS_ITEM_ASSESSOR_V

Source

View Text - Preformatted

SELECT IA.ROWID ROW_ID, P.PERSON_NUMBER PERSON_NUMBER, P.PREFERRED_NAME DSP_PREFERRED_NAME, IA.ASS_ID ASS_ID, IA.PERSON_ID PERSON_ID, IA.SEQUENCE_NUMBER SEQUENCE_NUMBER, IA.ASS_ASSESSOR_TYPE ASS_ASSESSOR_TYPE, IA.PRIMARY_ASSESSOR_IND PRIMARY_ASSESSOR_IND, IA.ITEM_LIMIT ITEM_LIMIT, IA.LOCATION_CD LOCATION_CD, IA.UNIT_MODE UNIT_MODE, IA.UNIT_CLASS UNIT_CLASS, IA.COMMENTS COMMENTS, UCL.DESCRIPTION DSP_DESCRIPTION, UCL.UNIT_MODE DSP_UNIT_MODE, UCL.CLOSED_IND DSP_CLOSED_IND, UM.DESCRIPTION DSP_DESCRIPTION2, UM.CLOSED_IND DSP_CLOSED_IND2, ASST.DESCRIPTION DSP_DESCRIPTION3, ASST.DFLT_IND DSP_DFLT_IND, ASST.CLOSED_IND DSP_CLOSED_IND3, LOC.DESCRIPTION DSP_DESCRIPTION4, LOC.CLOSED_IND DSP_CLOSED_IND4, LOC.LOCATION_TYPE DSP_LOCATION_TYPE, LOCT.S_LOCATION_TYPE DSP_S_LOCATION_TYPE, IA.CREATED_BY CREATED_BY, IA.CREATION_DATE CREATION_DATE, IA.LAST_UPDATED_BY LAST_UPDATED_BY, IA.LAST_UPDATE_DATE LAST_UPDATE_DATE, IA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_ITEM_ASSESSOR IA, IGS_PE_PERSON_V P, IGS_AS_UNIT_CLASS UCL, IGS_AS_UNIT_MODE UM, IGS_AS_ASSESSOR_TYPE ASST, IGS_AD_LOCATION LOC, IGS_AD_LOCATION_TYPE LOCT WHERE IA.PERSON_ID = P.PERSON_ID AND IA.UNIT_CLASS = UCL.UNIT_CLASS (+) AND IA.UNIT_MODE = UM.UNIT_MODE (+) AND IA.ASS_ASSESSOR_TYPE = ASST.ASS_ASSESSOR_TYPE AND IA.LOCATION_CD = LOC.LOCATION_CD (+) AND UPPER(LOC.LOCATION_TYPE) = UPPER(LOCT.LOCATION_TYPE(+))

View Text - HTML Formatted

SELECT IA.ROWID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, P.PREFERRED_NAME DSP_PREFERRED_NAME
, IA.ASS_ID ASS_ID
, IA.PERSON_ID PERSON_ID
, IA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, IA.ASS_ASSESSOR_TYPE ASS_ASSESSOR_TYPE
, IA.PRIMARY_ASSESSOR_IND PRIMARY_ASSESSOR_IND
, IA.ITEM_LIMIT ITEM_LIMIT
, IA.LOCATION_CD LOCATION_CD
, IA.UNIT_MODE UNIT_MODE
, IA.UNIT_CLASS UNIT_CLASS
, IA.COMMENTS COMMENTS
, UCL.DESCRIPTION DSP_DESCRIPTION
, UCL.UNIT_MODE DSP_UNIT_MODE
, UCL.CLOSED_IND DSP_CLOSED_IND
, UM.DESCRIPTION DSP_DESCRIPTION2
, UM.CLOSED_IND DSP_CLOSED_IND2
, ASST.DESCRIPTION DSP_DESCRIPTION3
, ASST.DFLT_IND DSP_DFLT_IND
, ASST.CLOSED_IND DSP_CLOSED_IND3
, LOC.DESCRIPTION DSP_DESCRIPTION4
, LOC.CLOSED_IND DSP_CLOSED_IND4
, LOC.LOCATION_TYPE DSP_LOCATION_TYPE
, LOCT.S_LOCATION_TYPE DSP_S_LOCATION_TYPE
, IA.CREATED_BY CREATED_BY
, IA.CREATION_DATE CREATION_DATE
, IA.LAST_UPDATED_BY LAST_UPDATED_BY
, IA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_ITEM_ASSESSOR IA
, IGS_PE_PERSON_V P
, IGS_AS_UNIT_CLASS UCL
, IGS_AS_UNIT_MODE UM
, IGS_AS_ASSESSOR_TYPE ASST
, IGS_AD_LOCATION LOC
, IGS_AD_LOCATION_TYPE LOCT
WHERE IA.PERSON_ID = P.PERSON_ID
AND IA.UNIT_CLASS = UCL.UNIT_CLASS (+)
AND IA.UNIT_MODE = UM.UNIT_MODE (+)
AND IA.ASS_ASSESSOR_TYPE = ASST.ASS_ASSESSOR_TYPE
AND IA.LOCATION_CD = LOC.LOCATION_CD (+)
AND UPPER(LOC.LOCATION_TYPE) = UPPER(LOCT.LOCATION_TYPE(+))