Product: | IGS - Student System (Obsolete) |
---|---|
Description: | revenue segment values for an organization unit |
Implementation/DBA Data: | Not implemented in this database |
SELECT ORUA.ROW_ID
, ORUA.ORG_ACCOUNT_ID
, ORUA.ORG_UNIT_CD
, ORUA.START_DT
, ACCSEG.SEGMENT
, ACCSEG.SEGMENT_NAME
, ACCSEG.SEGMENT_NUM
, ORUA.SEGMENT_VALUE
, DECODE(ORUA.SEGMENT_VALUE
, NULL
, NULL
, IGS_FI_GEN_007.GET_SEGVAL_DESC(ACCSEG.FLEX_VALUE_SET_ID
, ORUA.SEGMENT_VALUE))
, ACCSEG.FLEX_VALUE_SET_ID
, ACCSEG.VALIDATION_TYPE
, ACCSEG.INDEPENDENT_SEGMENT_NUM
, ACCSEG.DISPLAY_FLAG
, ORUA.ORG_ID
, ORUA.CREATED_BY
, ORUA.CREATION_DATE
, ORUA.LAST_UPDATED_BY
, ORUA.LAST_UPDATE_DATE
, ORUA.LAST_UPDATE_LOGIN
FROM IGS_OR_UNIT_ACCTS ORUA
, IGS_FI_ACCT_SEGS_V ACCSEG
WHERE ACCSEG.SEGMENT = ORUA.SEGMENT(+)
AND ACCSEG.SEGMENT_NUM = ORUA.SEGMENT_NUM(+) ORDER BY ACCSEG.SEGMENT_NUM