FND Design Data [Home] [Help]

View: PSBFV_GL_ACCOUNT_HIERARCHIES

Product: PSB - Public Sector Budgeting
Description:
Implementation/DBA Data: ViewAPPS.PSBFV_GL_ACCOUNT_HIERARCHIES
View Text

SELECT A.LEDGER_ID
, A.SUMMARY_CODE_COMBINATION_ID
, A.DETAIL_CODE_COMBINATION_ID
, A.TEMPLATE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
FROM GL_ACCOUNT_HIERARCHIES A
, GL_CODE_COMBINATIONS_KFV GCC
WHERE A.SUMMARY_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY

Columns

Name
LEDGER_ID
SUMMARY_CODE_COMBINATION_ID
DETAIL_CODE_COMBINATION_ID
TEMPLATE_ID
"_KF:GL_ACCOUNT"