Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GLFV_GL_ACCOUNTS |
SELECT GL_ACCOUNT.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GL_ACCOUNT'
, GL_ACCOUNT.CHART_OF_ACCOUNTS_ID
, CHART_OF_ACCOUNTS_TL.ID_FLEX_STRUCTURE_NAME
, '_LA:GL_ACCOUNT.ACCOUNT_TYPE:GL_LOOKUPS:ACCOUNT TYPE:DESCRIPTION'
, GL_ACCOUNT.DESCRIPTION
, GL_ACCOUNT.START_DATE_ACTIVE
, GL_ACCOUNT.END_DATE_ACTIVE
, '_LA:GL_ACCOUNT.ENABLED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_ACCOUNT.DETAIL_POSTING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GL_ACCOUNT.DETAIL_BUDGETING_ALLOWED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:DECODE(GL_ACCOUNT.SUMMARY_FLAG
, ''N''
, ''DTL''
, ''SUM''):GL_LOOKUPS:SUMMARY_FLAG:MEANING'
, '_LA:GL_ACCOUNT.PRESERVE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_DF:SQLGL:GL_CODE_COMBINATIONS:GL_ACCOUNT'
FROM GL_CODE_COMBINATIONS GL_ACCOUNT
, FND_ID_FLEX_STRUCTURES_TL CHART_OF_ACCOUNTS_TL
WHERE (GL_ACCOUNT.CHART_OF_ACCOUNTS_ID = CHART_OF_ACCOUNTS_TL.ID_FLEX_NUM)
AND (CHART_OF_ACCOUNTS_TL.LANGUAGE = USERENV('LANG')
AND CHART_OF_ACCOUNTS_TL.APPLICATION_ID = 101
AND CHART_OF_ACCOUNTS_TL.ID_FLEX_CODE = 'GL#')
AND '_SEC:GL:NULL
, GL_ACCOUNT.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY