VIEW: APPS.JA_CN_ACC_SUBS_V

Source

View Text - Preformatted

SELECT DISTINCT      FFV.FLEX_VALUE                       acc_number           ,DECODE(FFV.VALUE_CATEGORY,'Subsidiary',        nvl(FFV.ATTRIBUTE5, ''),              '')                             acc_level            ,DECODE(FFV.VALUE_CATEGORY,'Subsidiary',        DECODE(                                                       nvl(FFV.ATTRIBUTE4, 'N') ||             nvl(FFV.ATTRIBUTE2, 'N') ||             nvl(FFV.ATTRIBUTE1, 'N') ||             nvl(FFV.ATTRIBUTE3, 'N')            , 'NNNN', '0', '1'),                              '0')                            sub_flag             ,DECODE(FFV.VALUE_CATEGORY,'Subsidiary',           nvl(DECODE(nvl(FFV.ATTRIBUTE4, 'N'),              'Y', 'Project/', '')||                        DECODE(nvl(FFV.ATTRIBUTE2, 'N'),              'S', 'Supplier/','C', 'Customer/', '')||            DECODE(nvl(FFV.ATTRIBUTE1, 'N'),              'Y', 'Cost Center/', '')||                        DECODE(nvl(FFV.ATTRIBUTE3,                     'N'), 'Y', 'Personnel/', ''),          '/'), '/')                    sub_item             ,DECODE(FFV.VALUE_CATEGORY,'Subsidiary',        nvl(FFV.ATTRIBUTE7, ''),                '')                             acc_bal           FROM FND_ID_FLEX_SEGMENTS                FIFS                  ,FND_SEGMENT_ATTRIBUTE_VALUES        FSAV                  ,FND_FLEX_VALUE_SETS                 FFVS                  ,FND_FLEX_VALUES                     FFV               WHERE                                                            FIFS.id_flex_num =  53301                   AND FIFS.id_flex_num = FSAV.id_flex_num                    AND FIFS.application_id = 101                              AND FIFS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME    AND FIFS.application_id = FSAV.application_id              AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'           AND FSAV.ATTRIBUTE_VALUE = 'Y'                           AND FFVS.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID        AND FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID      

View Text - HTML Formatted

SELECT DISTINCT FFV.FLEX_VALUE ACC_NUMBER
, DECODE(FFV.VALUE_CATEGORY
, 'SUBSIDIARY'
, NVL(FFV.ATTRIBUTE5
, '')
, '') ACC_LEVEL
, DECODE(FFV.VALUE_CATEGORY
, 'SUBSIDIARY'
, DECODE( NVL(FFV.ATTRIBUTE4
, 'N') || NVL(FFV.ATTRIBUTE2
, 'N') || NVL(FFV.ATTRIBUTE1
, 'N') || NVL(FFV.ATTRIBUTE3
, 'N')
, 'NNNN'
, '0'
, '1')
, '0') SUB_FLAG
, DECODE(FFV.VALUE_CATEGORY
, 'SUBSIDIARY'
, NVL(DECODE(NVL(FFV.ATTRIBUTE4
, 'N')
, 'Y'
, 'PROJECT/'
, '')|| DECODE(NVL(FFV.ATTRIBUTE2
, 'N')
, 'S'
, 'SUPPLIER/'
, 'C'
, 'CUSTOMER/'
, '')|| DECODE(NVL(FFV.ATTRIBUTE1
, 'N')
, 'Y'
, 'COST CENTER/'
, '')|| DECODE(NVL(FFV.ATTRIBUTE3
, 'N')
, 'Y'
, 'PERSONNEL/'
, '')
, '/')
, '/') SUB_ITEM
, DECODE(FFV.VALUE_CATEGORY
, 'SUBSIDIARY'
, NVL(FFV.ATTRIBUTE7
, '')
, '') ACC_BAL
FROM FND_ID_FLEX_SEGMENTS FIFS
, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
, FND_FLEX_VALUE_SETS FFVS
, FND_FLEX_VALUES FFV
WHERE FIFS.ID_FLEX_NUM = 53301
AND FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FIFS.APPLICATION_ID = 101
AND FIFS.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
AND FIFS.APPLICATION_ID = FSAV.APPLICATION_ID
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FFVS.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID
AND FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID