View: IGS_FI_F_TYPE_ACCTS_V

Product:	IGS - Student System
Description:	Finance Type Accounts information
Implementation/DBA Data:	APPS.IGS_FI_F_TYPE_ACCTS_V

View Text

SELECT FIFTS.ROW_ID
, FIFTS.FEE_TYPE_ACCOUNT_ID
, FIFTS.FEE_TYPE
, FIFTS.FEE_CAL_TYPE
, FIFTS.FEE_CI_SEQUENCE_NUMBER
, ACCSEG.SEGMENT
, ACCSEG.SEGMENT_NAME
, ACCSEG.SEGMENT_NUM
, FIFTS.SEGMENT_VALUE
, DECODE(FIFTS.SEGMENT_VALUE
, NULL
, NULL
, IGS_FI_GEN_007.GET_SEGVAL_DESC(ACCSEG.FLEX_VALUE_SET_ID
, FIFTS.SEGMENT_VALUE))
, ACCSEG.FLEX_VALUE_SET_ID
, ACCSEG.VALIDATION_TYPE
, ACCSEG.INDEPENDENT_SEGMENT_NUM
, ACCSEG.DISPLAY_FLAG
, FIFTS.ORG_ID
, FIFTS.CREATED_BY
, FIFTS.CREATION_DATE
, FIFTS.LAST_UPDATED_BY
, FIFTS.LAST_UPDATE_DATE
, FIFTS.LAST_UPDATE_LOGIN
FROM IGS_FI_F_TYPE_ACCTS FIFTS
, IGS_FI_ACCT_SEGS_V ACCSEG
WHERE ACCSEG.SEGMENT = FIFTS.SEGMENT(+)
AND ACCSEG.SEGMENT_NUM = FIFTS.SEGMENT_NUM(+)

Columns