DBA Data[Home] [Help]

VIEW: APPS.HR_KI_TOPIC_INTEGRATIONS_V

Source

View Text - Preformatted

SELECT tpint.topic_integrations_id, tpc.topic_key, int.integration_key, tpint.object_version_number, tpint.param_name1, tpint.param_value1, tpint.param_name2, tpint.param_value2, tpint.param_name3, tpint.param_value3, tpint.param_name4, tpint.param_value4, tpint.param_name5, tpint.param_value5, tpint.param_name6, tpint.param_value6, tpint.param_name7, tpint.param_value7, tpint.param_name8, tpint.param_value8, tpint.param_name9, tpint.param_value9, tpint.param_name10, tpint.param_value10 from hr_ki_topic_integrations tpint, hr_ki_topics tpc, hr_ki_integrations int WHERE tpc.topic_id = tpint.topic_id and tpint.integration_id = int.integration_id
View Text - HTML Formatted

SELECT TPINT.TOPIC_INTEGRATIONS_ID
, TPC.TOPIC_KEY
, INT.INTEGRATION_KEY
, TPINT.OBJECT_VERSION_NUMBER
, TPINT.PARAM_NAME1
, TPINT.PARAM_VALUE1
, TPINT.PARAM_NAME2
, TPINT.PARAM_VALUE2
, TPINT.PARAM_NAME3
, TPINT.PARAM_VALUE3
, TPINT.PARAM_NAME4
, TPINT.PARAM_VALUE4
, TPINT.PARAM_NAME5
, TPINT.PARAM_VALUE5
, TPINT.PARAM_NAME6
, TPINT.PARAM_VALUE6
, TPINT.PARAM_NAME7
, TPINT.PARAM_VALUE7
, TPINT.PARAM_NAME8
, TPINT.PARAM_VALUE8
, TPINT.PARAM_NAME9
, TPINT.PARAM_VALUE9
, TPINT.PARAM_NAME10
, TPINT.PARAM_VALUE10
FROM HR_KI_TOPIC_INTEGRATIONS TPINT
, HR_KI_TOPICS TPC
, HR_KI_INTEGRATIONS INT
WHERE TPC.TOPIC_ID = TPINT.TOPIC_ID
AND TPINT.INTEGRATION_ID = INT.INTEGRATION_ID