eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: JA_CN_CODE_COMBINATION_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.JA_CN_CODE_COMBINATION_V

View Text

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