FND Design Data [Home] [Help]

View: JA_CN_ACC_SUBS_V

Product: FND - Application Object Library
Description:
Implementation/DBA Data: ViewAPPS.JA_CN_ACC_SUBS_V
View Text

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