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
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
|
|
|