VIEW: APPS.HR_KI_INTEGRATIONS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.INTEGRATION_ID ,B.INTEGRATION_KEY ,T.PARTNER_NAME,T.SERVICE_NAME ,B.PARTY_TYPE ,B.PARTY_NAME ,B.PARTY_SITE_NAME ,B.TRANSACTION_TYPE ,B.TRANSACTION_SUBTYPE ,B.STANDARD_CODE ,B.EXT_TRANS_TYPE ,B.EXT_TRANS_SUBTYPE ,B.TRANS_DIRECTION ,B.URL ,B.EXT_APPLICATION_ID ,B.SYNCHED ,B.APPLICATION_NAME ,B.APPLICATION_TYPE ,B.APPLICATION_URL ,B.LOGOUT_URL ,B.USER_FIELD ,B.PASSWORD_FIELD ,B.AUTHENTICATION_NEEDED ,B.FIELD_NAME1 ,B.FIELD_VALUE1 ,B.FIELD_NAME2 ,B.FIELD_VALUE2 ,B.FIELD_NAME3 ,B.FIELD_VALUE3 ,B.FIELD_NAME4 ,B.FIELD_VALUE4 ,B.FIELD_NAME5 ,B.FIELD_VALUE5 ,B.FIELD_NAME6 ,B.FIELD_VALUE6 ,B.FIELD_NAME7 ,B.FIELD_VALUE7 ,B.FIELD_NAME8 ,B.FIELD_VALUE8 ,B.FIELD_NAME9 ,B.FIELD_VALUE9 ,B.LAST_UPDATE_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_LOGIN ,B.CREATED_BY ,B.CREATION_DATE ,B.OBJECT_VERSION_NUMBER ,' ' SOURCE_TYPE ,' ' TARGET_TYPE FROM HR_KI_INTEGRATIONS B, HR_KI_INTEGRATIONS_TL T WHERE B.INTEGRATION_ID = T.INTEGRATION_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.INTEGRATION_ID
, B.INTEGRATION_KEY
, T.PARTNER_NAME
, T.SERVICE_NAME
, B.PARTY_TYPE
, B.PARTY_NAME
, B.PARTY_SITE_NAME
, B.TRANSACTION_TYPE
, B.TRANSACTION_SUBTYPE
, B.STANDARD_CODE
, B.EXT_TRANS_TYPE
, B.EXT_TRANS_SUBTYPE
, B.TRANS_DIRECTION
, B.URL
, B.EXT_APPLICATION_ID
, B.SYNCHED
, B.APPLICATION_NAME
, B.APPLICATION_TYPE
, B.APPLICATION_URL
, B.LOGOUT_URL
, B.USER_FIELD
, B.PASSWORD_FIELD
, B.AUTHENTICATION_NEEDED
, B.FIELD_NAME1
, B.FIELD_VALUE1
, B.FIELD_NAME2
, B.FIELD_VALUE2
, B.FIELD_NAME3
, B.FIELD_VALUE3
, B.FIELD_NAME4
, B.FIELD_VALUE4
, B.FIELD_NAME5
, B.FIELD_VALUE5
, B.FIELD_NAME6
, B.FIELD_VALUE6
, B.FIELD_NAME7
, B.FIELD_VALUE7
, B.FIELD_NAME8
, B.FIELD_VALUE8
, B.FIELD_NAME9
, B.FIELD_VALUE9
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
, ' ' SOURCE_TYPE
, ' ' TARGET_TYPE
FROM HR_KI_INTEGRATIONS B
, HR_KI_INTEGRATIONS_TL T
WHERE B.INTEGRATION_ID = T.INTEGRATION_ID
AND T.LANGUAGE = USERENV('LANG')