View: IGI_DOS_SOURCE_ACCOUNTS

Product:	IGI - Public Sector Financials International
Description:	Based on IGI_DOS_DOC_TYPES, GL_CODE_COMBINATIONS_KFV, IGI_DOS_SOURCES and IGI_DOS_SOURCE_USAGES
Implementation/DBA Data:	APPS.IGI_DOS_SOURCE_ACCOUNTS

View Text

SELECT DISTINCT DECODE(SUSE1.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT1
, KFV.SEGMENT1
, 'X')
, KFV.SEGMENT1) ||'-'|| DECODE(SUSE2.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT2
, KFV.SEGMENT2
, 'X')
, KFV.SEGMENT2) ||'-'|| DECODE(SUSE3.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT3
, KFV.SEGMENT3
, 'X' )
, KFV.SEGMENT3) ||'-' ||DECODE(SUSE4.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT4
, KFV.SEGMENT4
, 'X')
, KFV.SEGMENT4)||'-'|| DECODE(SUSE5.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT5
, KFV.SEGMENT5
, 'X')
, KFV.SEGMENT5)||'-'|| DECODE(SUSE6.VISIBILITY
, 'N'
, TRANSLATE(KFV.SEGMENT6
, KFV.SEGMENT6
, 'X')
, KFV.SEGMENT6)
, KFV.ROWID
, DTYPE.DOSSIER_ID
, SOURCE.SOURCE_ID
, KFV.CONCATENATED_SEGMENTS
, KFV.CODE_COMBINATION_ID
, KFV.CHART_OF_ACCOUNTS_ID
, KFV.SEGMENT1
, SUSE1.UPDATABLE
, KFV.SEGMENT2
, SUSE2.UPDATABLE
, KFV.SEGMENT3
, SUSE3.UPDATABLE
, KFV.SEGMENT4
, SUSE4.UPDATABLE
, KFV.SEGMENT5
, SUSE5.UPDATABLE
, KFV.SEGMENT6
, SUSE6.UPDATABLE
FROM GL_CODE_COMBINATIONS_KFV KFV
, IGI_DOS_DOC_TYPES DTYPE
, IGI_DOS_SOURCES SOURCE
, IGI_DOS_SOURCE_USAGES SUSE1
, IGI_DOS_SOURCE_USAGES SUSE2
, IGI_DOS_SOURCE_USAGES SUSE3
, IGI_DOS_SOURCE_USAGES SUSE4
, IGI_DOS_SOURCE_USAGES SUSE5
, IGI_DOS_SOURCE_USAGES SUSE6
WHERE SOURCE.DOSSIER_ID = DTYPE.DOSSIER_ID
AND SOURCE.SOURCE_ID = SUSE1.SOURCE_ID
AND SOURCE.SOURCE_ID = SUSE2.SOURCE_ID
AND SOURCE.SOURCE_ID = SUSE3.SOURCE_ID
AND SOURCE.SOURCE_ID = SUSE4.SOURCE_ID
AND SUSE1.SEGMENT_NAME ='SEGMENT1'
AND SUSE2.SEGMENT_NAME ='SEGMENT2'
AND SUSE3.SEGMENT_NAME ='SEGMENT3'
AND SUSE4.SEGMENT_NAME ='SEGMENT4'
AND KFV.CONCATENATED_SEGMENTS >= SOURCE.SEGMENTS_LOW_CCID_DESC
AND KFV.CONCATENATED_SEGMENTS <= SOURCE.SEGMENTS_HIGH_CCID_DESC
AND SOURCE.SOURCE_ID = SUSE5.SOURCE_ID
AND SUSE5.SEGMENT_NAME ='SEGMENT5'
AND SOURCE.SOURCE_ID = SUSE6.SOURCE_ID
AND SUSE6.SEGMENT_NAME ='SEGMENT6'

Columns