1. Tables and Views for Financials
  2. JA_CN_ACC_SUBS_V

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