VIEW: APPS.JA_CN_CODE_COMBINATION_V

Source

View Text - Preformatted

select GCC.CODE_COMBINATION_ID,led.ledger_id,gcc.SEGMENT1 company_segment,gcc.SEGMENT3 account_segment, gcc.SEGMENT1 SEGMENT1, gcc.SEGMENT2 SEGMENT2, gcc.SEGMENT4 SEGMENT4, gcc.SEGMENT5 SEGMENT3, NULL SEGMENT10, NULL SEGMENT11, NULL SEGMENT12, NULL SEGMENT13, NULL SEGMENT14, NULL SEGMENT15, NULL SEGMENT16, NULL SEGMENT17, NULL SEGMENT18, NULL SEGMENT19, NULL SEGMENT20, NULL SEGMENT21, NULL SEGMENT22, NULL SEGMENT23, NULL SEGMENT24, NULL SEGMENT25, NULL SEGMENT26, NULL SEGMENT27, NULL SEGMENT28, NULL SEGMENT29, NULL SEGMENT30, 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

View Text - HTML Formatted

SELECT GCC.CODE_COMBINATION_ID
, LED.LEDGER_ID
, GCC.SEGMENT1 COMPANY_SEGMENT
, GCC.SEGMENT3 ACCOUNT_SEGMENT
, GCC.SEGMENT1 SEGMENT1
, GCC.SEGMENT2 SEGMENT2
, GCC.SEGMENT4 SEGMENT4
, GCC.SEGMENT5 SEGMENT3
, NULL SEGMENT10
, NULL SEGMENT11
, NULL SEGMENT12
, NULL SEGMENT13
, NULL SEGMENT14
, NULL SEGMENT15
, NULL SEGMENT16
, NULL SEGMENT17
, NULL SEGMENT18
, NULL SEGMENT19
, NULL SEGMENT20
, NULL SEGMENT21
, NULL SEGMENT22
, NULL SEGMENT23
, NULL SEGMENT24
, NULL SEGMENT25
, NULL SEGMENT26
, NULL SEGMENT27
, NULL SEGMENT28
, NULL SEGMENT29
, NULL SEGMENT30
, 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