VIEW: APPS.IGI_DOS_DEST_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,dest.source_id, dest.destination_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_DESTINATIONS DEST, IGI_DOS_DESTINATION_USAGES SUSE1, IGI_DOS_DOC_TYPES DTYPE, IGI_DOS_DESTINATION_USAGES SUSE2, IGI_DOS_DESTINATION_USAGES SUSE3, IGI_DOS_DESTINATION_USAGES SUSE4, IGI_DOS_DESTINATION_USAGES SUSE5, IGI_DOS_DESTINATION_USAGES SUSE6 WHERE dest.dossier_id = dtype.dossier_id and dest.destination_id = suse1.destination_id and dest.destination_id = suse2.destination_id and dest.destination_id = suse3.destination_id and dest.destination_id = suse4.destination_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 >= dest.SEGMENTS_LOW_CCID_DESC and kfv.concatenated_segments <= dest.SEGMENTS_HIGH_CCID_DESC and dest.destination_id = suse5.destination_id and suse5.segment_name ='SEGMENT5' and dest.destination_id = suse6.destination_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
, DEST.SOURCE_ID
, DEST.DESTINATION_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_DESTINATIONS DEST
, IGI_DOS_DESTINATION_USAGES SUSE1
, IGI_DOS_DOC_TYPES DTYPE
, IGI_DOS_DESTINATION_USAGES SUSE2
, IGI_DOS_DESTINATION_USAGES SUSE3
, IGI_DOS_DESTINATION_USAGES SUSE4
, IGI_DOS_DESTINATION_USAGES SUSE5
, IGI_DOS_DESTINATION_USAGES SUSE6
WHERE DEST.DOSSIER_ID = DTYPE.DOSSIER_ID
AND DEST.DESTINATION_ID = SUSE1.DESTINATION_ID
AND DEST.DESTINATION_ID = SUSE2.DESTINATION_ID
AND DEST.DESTINATION_ID = SUSE3.DESTINATION_ID
AND DEST.DESTINATION_ID = SUSE4.DESTINATION_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 >= DEST.SEGMENTS_LOW_CCID_DESC
AND KFV.CONCATENATED_SEGMENTS <= DEST.SEGMENTS_HIGH_CCID_DESC
AND DEST.DESTINATION_ID = SUSE5.DESTINATION_ID
AND SUSE5.SEGMENT_NAME ='SEGMENT5'
AND DEST.DESTINATION_ID = SUSE6.DESTINATION_ID
AND SUSE6.SEGMENT_NAME ='SEGMENT6'