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: HXC.HXC_RPT_TC_AUDIT#

Source

View Text - Preformatted


select TIME_ENTRY_DATE TIME_ENTRY_DATE, ATTRIBUTE_INFO ATTRIBUTE_INFO, HOURS HOURS, ACTION ACTION, ACTION_DATE ACTION_DATE, ACTION_BY ACTION_BY, COMMENTS COMMENTS, REASONS REASONS, TRANSACTION_ID TRANSACTION_ID, DETAIL_BB_ID DETAIL_BB_ID, DETAIL_BB_OVN DETAIL_BB_OVN, TC_BB_ID TC_BB_ID, TC_BB_OVN TC_BB_OVN, ACTION_TYPE ACTION_TYPE, RESOURCE_ID RESOURCE_ID, TC_START_TIME TC_START_TIME, TC_STOP_TIME TC_STOP_TIME, ACTION_BY_PERSON ACTION_BY_PERSON, CLA_REASON CLA_REASON, RESOURCE_NAME RESOURCE_NAME, START_STOP_TIME START_STOP_TIME from "HXC"."HXC_RPT_TC_AUDIT"

View Text - HTML Formatted

SELECT TIME_ENTRY_DATE TIME_ENTRY_DATE
, ATTRIBUTE_INFO ATTRIBUTE_INFO
, HOURS HOURS
, ACTION ACTION
, ACTION_DATE ACTION_DATE
, ACTION_BY ACTION_BY
, COMMENTS COMMENTS
, REASONS REASONS
, TRANSACTION_ID TRANSACTION_ID
, DETAIL_BB_ID DETAIL_BB_ID
, DETAIL_BB_OVN DETAIL_BB_OVN
, TC_BB_ID TC_BB_ID
, TC_BB_OVN TC_BB_OVN
, ACTION_TYPE ACTION_TYPE
, RESOURCE_ID RESOURCE_ID
, TC_START_TIME TC_START_TIME
, TC_STOP_TIME TC_STOP_TIME
, ACTION_BY_PERSON ACTION_BY_PERSON
, CLA_REASON CLA_REASON
, RESOURCE_NAME RESOURCE_NAME
, START_STOP_TIME START_STOP_TIME
FROM "HXC"."HXC_RPT_TC_AUDIT"