[Home] [Help]
View: JA_CN_CODE_COMBINATION_V
View Text
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