VIEW: APPS.IGS_FI_FTCI_ACCTS_V

Source

View Text - Preformatted

SELECT FTCI.ROWID, FTCI.ACCT_ID, FTCI.FEE_TYPE, FTCI.FEE_CAL_TYPE, FTCI.FEE_CI_SEQUENCE_NUMBER, FTCI.ORDER_SEQUENCE, FTCI.NATURAL_ACCOUNT_SEGMENT, FTCI.REV_ACCOUNT_CD, FTCI.LOCATION_CD, FTCI.ATTENDANCE_TYPE, FTCI.ATTENDANCE_MODE, FTCI.COURSE_CD, FTCI.CRS_VERSION_NUMBER, FTCI.UNIT_CD, FTCI.UNIT_VERSION_NUMBER, FTCI.ORG_UNIT_CD, FTCI.RESIDENCY_STATUS_CD, LKP.MEANING, FTCI.UOO_ID, IGS_FI_GEN_APINT.GET_UNIT_SECTION_DESC(FTCI.UOO_ID,NULL,NULL,NULL,NULL,NULL,NULL), FTCI.UNIT_LEVEL, FTCI.UNIT_TYPE_ID, PUT.LEVEL_CODE, FTCI.UNIT_CLASS, FTCI.UNIT_MODE, FTCI.CREATED_BY, FTCI.CREATION_DATE, FTCI.LAST_UPDATED_BY, FTCI.LAST_UPDATE_DATE, FTCI.LAST_UPDATE_LOGIN, FTCI.REQUEST_ID, FTCI.PROGRAM_APPLICATION_ID, FTCI.PROGRAM_ID, FTCI.PROGRAM_UPDATE_DATE FROM IGS_FI_FTCI_ACCTS FTCI, IGS_LOOKUP_VALUES LKP, IGS_PS_UNIT_TYPE_LVL PUT WHERE FTCI.RESIDENCY_STATUS_CD = LKP.LOOKUP_CODE (+) AND LKP.LOOKUP_TYPE (+) = 'PE_RES_STATUS' AND FTCI.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)

View Text - HTML Formatted

SELECT FTCI.ROWID
, FTCI.ACCT_ID
, FTCI.FEE_TYPE
, FTCI.FEE_CAL_TYPE
, FTCI.FEE_CI_SEQUENCE_NUMBER
, FTCI.ORDER_SEQUENCE
, FTCI.NATURAL_ACCOUNT_SEGMENT
, FTCI.REV_ACCOUNT_CD
, FTCI.LOCATION_CD
, FTCI.ATTENDANCE_TYPE
, FTCI.ATTENDANCE_MODE
, FTCI.COURSE_CD
, FTCI.CRS_VERSION_NUMBER
, FTCI.UNIT_CD
, FTCI.UNIT_VERSION_NUMBER
, FTCI.ORG_UNIT_CD
, FTCI.RESIDENCY_STATUS_CD
, LKP.MEANING
, FTCI.UOO_ID
, IGS_FI_GEN_APINT.GET_UNIT_SECTION_DESC(FTCI.UOO_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL)
, FTCI.UNIT_LEVEL
, FTCI.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FTCI.UNIT_CLASS
, FTCI.UNIT_MODE
, FTCI.CREATED_BY
, FTCI.CREATION_DATE
, FTCI.LAST_UPDATED_BY
, FTCI.LAST_UPDATE_DATE
, FTCI.LAST_UPDATE_LOGIN
, FTCI.REQUEST_ID
, FTCI.PROGRAM_APPLICATION_ID
, FTCI.PROGRAM_ID
, FTCI.PROGRAM_UPDATE_DATE
FROM IGS_FI_FTCI_ACCTS FTCI
, IGS_LOOKUP_VALUES LKP
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE FTCI.RESIDENCY_STATUS_CD = LKP.LOOKUP_CODE (+)
AND LKP.LOOKUP_TYPE (+) = 'PE_RES_STATUS'
AND FTCI.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)