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.SEGMENT2 cost_segment,gcc.SEGMENT4 project_number,NULL second_tracking_col,SEGMENT4||'.'||SEGMENT5 other_columns,to_number(null)  project_id 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.SEGMENT2 COST_SEGMENT
, GCC.SEGMENT4 PROJECT_NUMBER
, NULL SECOND_TRACKING_COL
, SEGMENT4||'.'||SEGMENT5 OTHER_COLUMNS
, TO_NUMBER(NULL) PROJECT_ID
FROM GL_CODE_COMBINATIONS GCC
, GL_LEDGERS LED
WHERE LED.CHART_OF_ACCOUNTS_ID = GCC.CHART_OF_ACCOUNTS_ID