JA_CN_ACC_SUBS_V
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: VIEW
Columns
Name |
---|
ACC_NUMBER ACC_LEVEL SUB_FLAG SUB_ITEM ACC_BAL |
Query
SQL_Statement |
---|
SELECT DISTINCT FFV.FLEX_VALUE acc_number, DECODE(FFV.VALUE_CATEGORY, 'Subsidiary', nvl(FFV.ATTRIBUTE2, ''), '') acc_level, '0' sub_flag, '/' sub_item, DECODE(FFV.VALUE_CATEGORY, 'Subsidiary', nvl(FFV.ATTRIBUTE1, ''), '') 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 = 52342 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 ORDER BY FFV.FLEX_VALUE |