JA_CN_CODE_COMBINATION_V

Details

• Schema: FUSION

• Object owner: JA

• Object type: VIEW

Columns

Name
CODE_COMBINATION_ID LEDGER_ID BALANCING_SEGMENT NATURAL_ACCOUNT_SEGMENT SEGMENT1 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT2 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT3 SEGMENT30 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9

Query

SQL_Statement

SELECT GCC.CODE_COMBINATION_ID,led.ledger_id,gcc.SEGMENT1 BALANCING_SEGMENT,gcc.SEGMENT5 NATURAL_ACCOUNT_SEGMENT, NULL SEGMENT1, NULL SEGMENT10, NULL SEGMENT11, NULL SEGMENT12, NULL SEGMENT13, NULL SEGMENT14, NULL SEGMENT15, NULL SEGMENT16, NULL SEGMENT17, NULL SEGMENT18, NULL SEGMENT19, NULL SEGMENT2, NULL SEGMENT20, NULL SEGMENT21, NULL SEGMENT22, NULL SEGMENT23, NULL SEGMENT24, NULL SEGMENT25, NULL SEGMENT26, NULL SEGMENT27, NULL SEGMENT28, NULL SEGMENT29, NULL SEGMENT3, NULL SEGMENT30, NULL SEGMENT4, NULL SEGMENT5, NULL SEGMENT6, NULL SEGMENT7, NULL SEGMENT8, NULL SEGMENT9 FROM gl_code_combinations gcc, GL_LEDGERS led WHERE led.chart_of_accounts_id = gcc.chart_of_accounts_id