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: HR.PAY_NO_ALTINN_TRANSFERS#

Source

View Text - Preformatted


select TRANSFER_ID TRANSFER_ID, TRANSFER_STATUS TRANSFER_STATUS, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, PAYROLL_ACTION_ID PAYROLL_ACTION_ID, REPORT_NAME REPORT_NAME, RUN_EFFECTIVE_DATE RUN_EFFECTIVE_DATE, SHIPMENT_REFERENCE SHIPMENT_REFERENCE, ORGANIZATION_ID ORGANIZATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RECEIPT_ID RECEIPT_ID, RECEIPT_STATUS RECEIPT_STATUS, RECEIPT_TEXT RECEIPT_TEXT, RECEIPT_LAST_UPDATED RECEIPT_LAST_UPDATED, ALT_ELEMENT_ID ALT_ELEMENT_ID, ALT_ARCHIVE_REF ALT_ARCHIVE_REF, CURR_STATE CURR_STATE, NEXT_STATE NEXT_STATE, TFR_INFORMATION_CATEGORY TFR_INFORMATION_CATEGORY, TFR_INFORMATION1 TFR_INFORMATION1, TFR_INFORMATION2 TFR_INFORMATION2, TFR_INFORMATION3 TFR_INFORMATION3, TFR_INFORMATION4 TFR_INFORMATION4, TFR_INFORMATION5 TFR_INFORMATION5, TFR_INFORMATION6 TFR_INFORMATION6, TFR_INFORMATION7 TFR_INFORMATION7, TFR_INFORMATION8 TFR_INFORMATION8, TFR_INFORMATION9 TFR_INFORMATION9, TFR_INFORMATION10 TFR_INFORMATION10, TFR_INFORMATION11 TFR_INFORMATION11, TFR_INFORMATION12 TFR_INFORMATION12, TFR_INFORMATION13 TFR_INFORMATION13, TFR_INFORMATION14 TFR_INFORMATION14, TFR_INFORMATION15 TFR_INFORMATION15, TFR_INFORMATION16 TFR_INFORMATION16, TFR_INFORMATION17 TFR_INFORMATION17, TFR_INFORMATION18 TFR_INFORMATION18, TFR_INFORMATION19 TFR_INFORMATION19, TFR_INFORMATION20 TFR_INFORMATION20, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."PAY_NO_ALTINN_TRANSFERS"

View Text - HTML Formatted

SELECT TRANSFER_ID TRANSFER_ID
, TRANSFER_STATUS TRANSFER_STATUS
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, REPORT_NAME REPORT_NAME
, RUN_EFFECTIVE_DATE RUN_EFFECTIVE_DATE
, SHIPMENT_REFERENCE SHIPMENT_REFERENCE
, ORGANIZATION_ID ORGANIZATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RECEIPT_ID RECEIPT_ID
, RECEIPT_STATUS RECEIPT_STATUS
, RECEIPT_TEXT RECEIPT_TEXT
, RECEIPT_LAST_UPDATED RECEIPT_LAST_UPDATED
, ALT_ELEMENT_ID ALT_ELEMENT_ID
, ALT_ARCHIVE_REF ALT_ARCHIVE_REF
, CURR_STATE CURR_STATE
, NEXT_STATE NEXT_STATE
, TFR_INFORMATION_CATEGORY TFR_INFORMATION_CATEGORY
, TFR_INFORMATION1 TFR_INFORMATION1
, TFR_INFORMATION2 TFR_INFORMATION2
, TFR_INFORMATION3 TFR_INFORMATION3
, TFR_INFORMATION4 TFR_INFORMATION4
, TFR_INFORMATION5 TFR_INFORMATION5
, TFR_INFORMATION6 TFR_INFORMATION6
, TFR_INFORMATION7 TFR_INFORMATION7
, TFR_INFORMATION8 TFR_INFORMATION8
, TFR_INFORMATION9 TFR_INFORMATION9
, TFR_INFORMATION10 TFR_INFORMATION10
, TFR_INFORMATION11 TFR_INFORMATION11
, TFR_INFORMATION12 TFR_INFORMATION12
, TFR_INFORMATION13 TFR_INFORMATION13
, TFR_INFORMATION14 TFR_INFORMATION14
, TFR_INFORMATION15 TFR_INFORMATION15
, TFR_INFORMATION16 TFR_INFORMATION16
, TFR_INFORMATION17 TFR_INFORMATION17
, TFR_INFORMATION18 TFR_INFORMATION18
, TFR_INFORMATION19 TFR_INFORMATION19
, TFR_INFORMATION20 TFR_INFORMATION20
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."PAY_NO_ALTINN_TRANSFERS"