VIEW: APPS.IGI_DOS_SOURCE_ACCOUNTS

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'