VIEW: APPS.IGF_AW_COA_RATE_DET_V

Source

View Text - Preformatted

SELECT RD.ROWID, RD.CI_CAL_TYPE, RD.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, RD.ITEM_CODE, IT.DESCRIPTION, RD.RATE_ORDER_NUM, RD.PID_GROUP_CD, RD.ORG_UNIT_CD, RD.PROGRAM_TYPE, RD.PROGRAM_LOCATION_CD, RD.PROGRAM_CD, RD.CLASS_STANDING, RD.RESIDENCY_STATUS_CODE, RD.HOUSING_STATUS_CODE, RD.ATTENDANCE_TYPE, RD.ATTENDANCE_MODE, RD.LD_CAL_TYPE, RD.LD_SEQUENCE_NUMBER, CALD.ALTERNATE_CODE, RD.MULT_FACTOR_CODE, RD.MULT_AMOUNT_NUM, RD.CREATED_BY, RD.CREATION_DATE, RD.LAST_UPDATED_BY, RD.LAST_UPDATE_DATE, RD.LAST_UPDATE_LOGIN FROM IGF_AW_COA_RATE_DET RD, IGF_AW_ITEM IT, IGS_CA_INST CA, IGS_CA_INST CALD WHERE RD.ITEM_CODE = IT.ITEM_CODE AND CA.CAL_TYPE = RD.CI_CAL_TYPE AND CA.SEQUENCE_NUMBER = RD.CI_SEQUENCE_NUMBER AND CALD.CAL_TYPE(+) = RD.LD_CAL_TYPE AND CALD.SEQUENCE_NUMBER(+) = RD.LD_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT RD.ROWID
, RD.CI_CAL_TYPE
, RD.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, RD.ITEM_CODE
, IT.DESCRIPTION
, RD.RATE_ORDER_NUM
, RD.PID_GROUP_CD
, RD.ORG_UNIT_CD
, RD.PROGRAM_TYPE
, RD.PROGRAM_LOCATION_CD
, RD.PROGRAM_CD
, RD.CLASS_STANDING
, RD.RESIDENCY_STATUS_CODE
, RD.HOUSING_STATUS_CODE
, RD.ATTENDANCE_TYPE
, RD.ATTENDANCE_MODE
, RD.LD_CAL_TYPE
, RD.LD_SEQUENCE_NUMBER
, CALD.ALTERNATE_CODE
, RD.MULT_FACTOR_CODE
, RD.MULT_AMOUNT_NUM
, RD.CREATED_BY
, RD.CREATION_DATE
, RD.LAST_UPDATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATE_LOGIN
FROM IGF_AW_COA_RATE_DET RD
, IGF_AW_ITEM IT
, IGS_CA_INST CA
, IGS_CA_INST CALD
WHERE RD.ITEM_CODE = IT.ITEM_CODE
AND CA.CAL_TYPE = RD.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = RD.CI_SEQUENCE_NUMBER
AND CALD.CAL_TYPE(+) = RD.LD_CAL_TYPE
AND CALD.SEQUENCE_NUMBER(+) = RD.LD_SEQUENCE_NUMBER