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: XLA.XLA_HISTORIC_CONTROL#

Source

View Text - Preformatted


select PRIMARY_LEDGER PRIMARY_LEDGER, SECONDARY_ALC_LEDGER SECONDARY_ALC_LEDGER, APPLICATION_ID APPLICATION_ID, UPGRADE_ID UPGRADE_ID, RELATIONSHIP_ID RELATIONSHIP_ID, SCRIPT_NAME SCRIPT_NAME, START_DATE START_DATE, END_DATE END_DATE, BATCH_SIZE BATCH_SIZE, NUM_WORKERS NUM_WORKERS, STATUS STATUS, LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, PRIMARY_CURRENCY_CODE PRIMARY_CURRENCY_CODE, SEC_ALC_CURRENCY_CODE SEC_ALC_CURRENCY_CODE, SEC_ALC_MAU SEC_ALC_MAU, SEC_ALC_PRECISION SEC_ALC_PRECISION, CONVERSION_OPTION CONVERSION_OPTION, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, PRIMARY_SLAM PRIMARY_SLAM, PRIMARY_COA PRIMARY_COA, PRIMARY_SLAM_TYPE PRIMARY_SLAM_TYPE, PRIMARY_AAD PRIMARY_AAD, PRIMARY_AAD_OWNER PRIMARY_AAD_OWNER, SECONDARY_SLAM SECONDARY_SLAM, SECONDARY_COA SECONDARY_COA, SECONDARY_SLAM_TYPE SECONDARY_SLAM_TYPE, SECONDARY_AAD SECONDARY_AAD, SECONDARY_AAD_OWNER SECONDARY_AAD_OWNER, MAPPING_RELATIONSHIP_ID MAPPING_RELATIONSHIP_ID, COA_MAPPING_NAME COA_MAPPING_NAME, PRIMARY_CAL_SET_NAME PRIMARY_CAL_SET_NAME, PRIMARY_CAL_PER_TYPE PRIMARY_CAL_PER_TYPE, PRIMARY_SEC_ALC_SET_NAME PRIMARY_SEC_ALC_SET_NAME, PRIMARY_SEC_ALC_PER_TYPE PRIMARY_SEC_ALC_PER_TYPE, DYNAMIC_INSERTS DYNAMIC_INSERTS, SEC_ALC_MIN_ACCTNG_BATCH_ID SEC_ALC_MIN_ACCTNG_BATCH_ID, PARENT_REQUEST_ID PARENT_REQUEST_ID from "XLA"."XLA_HISTORIC_CONTROL"

View Text - HTML Formatted

SELECT PRIMARY_LEDGER PRIMARY_LEDGER
, SECONDARY_ALC_LEDGER SECONDARY_ALC_LEDGER
, APPLICATION_ID APPLICATION_ID
, UPGRADE_ID UPGRADE_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
, SCRIPT_NAME SCRIPT_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, BATCH_SIZE BATCH_SIZE
, NUM_WORKERS NUM_WORKERS
, STATUS STATUS
, LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PRIMARY_CURRENCY_CODE PRIMARY_CURRENCY_CODE
, SEC_ALC_CURRENCY_CODE SEC_ALC_CURRENCY_CODE
, SEC_ALC_MAU SEC_ALC_MAU
, SEC_ALC_PRECISION SEC_ALC_PRECISION
, CONVERSION_OPTION CONVERSION_OPTION
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, PRIMARY_SLAM PRIMARY_SLAM
, PRIMARY_COA PRIMARY_COA
, PRIMARY_SLAM_TYPE PRIMARY_SLAM_TYPE
, PRIMARY_AAD PRIMARY_AAD
, PRIMARY_AAD_OWNER PRIMARY_AAD_OWNER
, SECONDARY_SLAM SECONDARY_SLAM
, SECONDARY_COA SECONDARY_COA
, SECONDARY_SLAM_TYPE SECONDARY_SLAM_TYPE
, SECONDARY_AAD SECONDARY_AAD
, SECONDARY_AAD_OWNER SECONDARY_AAD_OWNER
, MAPPING_RELATIONSHIP_ID MAPPING_RELATIONSHIP_ID
, COA_MAPPING_NAME COA_MAPPING_NAME
, PRIMARY_CAL_SET_NAME PRIMARY_CAL_SET_NAME
, PRIMARY_CAL_PER_TYPE PRIMARY_CAL_PER_TYPE
, PRIMARY_SEC_ALC_SET_NAME PRIMARY_SEC_ALC_SET_NAME
, PRIMARY_SEC_ALC_PER_TYPE PRIMARY_SEC_ALC_PER_TYPE
, DYNAMIC_INSERTS DYNAMIC_INSERTS
, SEC_ALC_MIN_ACCTNG_BATCH_ID SEC_ALC_MIN_ACCTNG_BATCH_ID
, PARENT_REQUEST_ID PARENT_REQUEST_ID
FROM "XLA"."XLA_HISTORIC_CONTROL"