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

Source

View Text - Preformatted


select TIME_BUILDING_BLOCK_ID TIME_BUILDING_BLOCK_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXP_TYPE EXP_TYPE, BILLABLE_FLAG BILLABLE_FLAG, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, JOB_ID JOB_ID, WORK_TYPE_ID WORK_TYPE_ID, LOCATION_ID LOCATION_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, BATCH_LINE_ID BATCH_LINE_ID, BATCH_ID BATCH_ID, XFERRED_TO_PA_FLAG XFERRED_TO_PA_FLAG, DATE_WORKED DATE_WORKED, TIMECARD_ID TIMECARD_ID from "HXC"."HXC_PAY_PA_LINK_ALL"

View Text - HTML Formatted

SELECT TIME_BUILDING_BLOCK_ID TIME_BUILDING_BLOCK_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXP_TYPE EXP_TYPE
, BILLABLE_FLAG BILLABLE_FLAG
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, JOB_ID JOB_ID
, WORK_TYPE_ID WORK_TYPE_ID
, LOCATION_ID LOCATION_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, BATCH_LINE_ID BATCH_LINE_ID
, BATCH_ID BATCH_ID
, XFERRED_TO_PA_FLAG XFERRED_TO_PA_FLAG
, DATE_WORKED DATE_WORKED
, TIMECARD_ID TIMECARD_ID
FROM "HXC"."HXC_PAY_PA_LINK_ALL"