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.HR_KI_INTEGRATIONS#

Source

View Text - Preformatted


select INTEGRATION_ID INTEGRATION_ID, INTEGRATION_KEY INTEGRATION_KEY, PARTY_TYPE PARTY_TYPE, PARTY_NAME PARTY_NAME, PARTY_SITE_NAME PARTY_SITE_NAME, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE, STANDARD_CODE STANDARD_CODE, EXT_TRANS_TYPE EXT_TRANS_TYPE, EXT_TRANS_SUBTYPE EXT_TRANS_SUBTYPE, TRANS_DIRECTION TRANS_DIRECTION, URL URL, SYNCHED SYNCHED, EXT_APPLICATION_ID EXT_APPLICATION_ID, APPLICATION_NAME APPLICATION_NAME, APPLICATION_TYPE APPLICATION_TYPE, APPLICATION_URL APPLICATION_URL, LOGOUT_URL LOGOUT_URL, USER_FIELD USER_FIELD, PASSWORD_FIELD PASSWORD_FIELD, AUTHENTICATION_NEEDED AUTHENTICATION_NEEDED, FIELD_NAME1 FIELD_NAME1, FIELD_VALUE1 FIELD_VALUE1, FIELD_NAME2 FIELD_NAME2, FIELD_VALUE2 FIELD_VALUE2, FIELD_NAME3 FIELD_NAME3, FIELD_VALUE3 FIELD_VALUE3, FIELD_NAME4 FIELD_NAME4, FIELD_VALUE4 FIELD_VALUE4, FIELD_NAME5 FIELD_NAME5, FIELD_VALUE5 FIELD_VALUE5, FIELD_NAME6 FIELD_NAME6, FIELD_VALUE6 FIELD_VALUE6, FIELD_NAME7 FIELD_NAME7, FIELD_VALUE7 FIELD_VALUE7, FIELD_NAME8 FIELD_NAME8, FIELD_VALUE8 FIELD_VALUE8, FIELD_NAME9 FIELD_NAME9, FIELD_VALUE9 FIELD_VALUE9, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."HR_KI_INTEGRATIONS"

View Text - HTML Formatted

SELECT INTEGRATION_ID INTEGRATION_ID
, INTEGRATION_KEY INTEGRATION_KEY
, PARTY_TYPE PARTY_TYPE
, PARTY_NAME PARTY_NAME
, PARTY_SITE_NAME PARTY_SITE_NAME
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, STANDARD_CODE STANDARD_CODE
, EXT_TRANS_TYPE EXT_TRANS_TYPE
, EXT_TRANS_SUBTYPE EXT_TRANS_SUBTYPE
, TRANS_DIRECTION TRANS_DIRECTION
, URL URL
, SYNCHED SYNCHED
, EXT_APPLICATION_ID EXT_APPLICATION_ID
, APPLICATION_NAME APPLICATION_NAME
, APPLICATION_TYPE APPLICATION_TYPE
, APPLICATION_URL APPLICATION_URL
, LOGOUT_URL LOGOUT_URL
, USER_FIELD USER_FIELD
, PASSWORD_FIELD PASSWORD_FIELD
, AUTHENTICATION_NEEDED AUTHENTICATION_NEEDED
, FIELD_NAME1 FIELD_NAME1
, FIELD_VALUE1 FIELD_VALUE1
, FIELD_NAME2 FIELD_NAME2
, FIELD_VALUE2 FIELD_VALUE2
, FIELD_NAME3 FIELD_NAME3
, FIELD_VALUE3 FIELD_VALUE3
, FIELD_NAME4 FIELD_NAME4
, FIELD_VALUE4 FIELD_VALUE4
, FIELD_NAME5 FIELD_NAME5
, FIELD_VALUE5 FIELD_VALUE5
, FIELD_NAME6 FIELD_NAME6
, FIELD_VALUE6 FIELD_VALUE6
, FIELD_NAME7 FIELD_NAME7
, FIELD_VALUE7 FIELD_VALUE7
, FIELD_NAME8 FIELD_NAME8
, FIELD_VALUE8 FIELD_VALUE8
, FIELD_NAME9 FIELD_NAME9
, FIELD_VALUE9 FIELD_VALUE9
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."HR_KI_INTEGRATIONS"