DBA Data[Home] [Help]

VIEW: HR.PAY_TEMPLATE_CORE_OBJECTS#

Source

View Text - Preformatted

select TEMPLATE_CORE_OBJECT_ID TEMPLATE_CORE_OBJECT_ID, TEMPLATE_ID TEMPLATE_ID, CORE_OBJECT_TYPE CORE_OBJECT_TYPE, CORE_OBJECT_ID CORE_OBJECT_ID, SHADOW_OBJECT_ID SHADOW_OBJECT_ID, EFFECTIVE_DATE EFFECTIVE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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 from "HR"."PAY_TEMPLATE_CORE_OBJECTS"
View Text - HTML Formatted

SELECT TEMPLATE_CORE_OBJECT_ID TEMPLATE_CORE_OBJECT_ID
, TEMPLATE_ID TEMPLATE_ID
, CORE_OBJECT_TYPE CORE_OBJECT_TYPE
, CORE_OBJECT_ID CORE_OBJECT_ID
, SHADOW_OBJECT_ID SHADOW_OBJECT_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
FROM "HR"."PAY_TEMPLATE_CORE_OBJECTS"