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.

VIEW: JL.JL_CL_GL_ACCT_HIER_TMP#

Source

View Text - Preformatted


select PARENT_VALUE PARENT_VALUE, CHILD_VALUE CHILD_VALUE, ACCOUNT_TYPE ACCOUNT_TYPE, SUMMARY_FLAG SUMMARY_FLAG, HIERARCHY_LEVEL HIERARCHY_LEVEL, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID, ADDITIONS_DR ADDITIONS_DR, ADDITIONS_CR ADDITIONS_CR, BALANCE_DR BALANCE_DR, BALANCE_CR BALANCE_CR, INVENTORY_ASSET INVENTORY_ASSET, INVENTORY_LIABILITY INVENTORY_LIABILITY, PNL_LOSS PNL_LOSS, PNL_GAIN PNL_GAIN, REPORTABLE_FLAG REPORTABLE_FLAG from "JL"."JL_CL_GL_ACCT_HIER_TMP"

View Text - HTML Formatted

SELECT PARENT_VALUE PARENT_VALUE
, CHILD_VALUE CHILD_VALUE
, ACCOUNT_TYPE ACCOUNT_TYPE
, SUMMARY_FLAG SUMMARY_FLAG
, HIERARCHY_LEVEL HIERARCHY_LEVEL
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, ADDITIONS_DR ADDITIONS_DR
, ADDITIONS_CR ADDITIONS_CR
, BALANCE_DR BALANCE_DR
, BALANCE_CR BALANCE_CR
, INVENTORY_ASSET INVENTORY_ASSET
, INVENTORY_LIABILITY INVENTORY_LIABILITY
, PNL_LOSS PNL_LOSS
, PNL_GAIN PNL_GAIN
, REPORTABLE_FLAG REPORTABLE_FLAG
FROM "JL"."JL_CL_GL_ACCT_HIER_TMP"