Product: | IGI - Public Sector Financials International |
---|---|
Description: | Based on IGI_DOS_DOC_TYPES, GL_CODE_COMBINATIONS_KFV, IGI_DOS_DESTINATIONS and IGI_DOS_DESTINATION_USAGES |
Implementation/DBA Data: | APPS.IGI_DOS_DEST_ACCOUNTS |
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'