DBA Data[Home] [Help]

VIEW: HR.PAY_RETRO_COMPONENT_USAGES#

Source

View Text - Preformatted

select RETRO_COMPONENT_USAGE_ID RETRO_COMPONENT_USAGE_ID, RETRO_COMPONENT_ID RETRO_COMPONENT_ID, CREATOR_ID CREATOR_ID, CREATOR_TYPE CREATOR_TYPE, DEFAULT_COMPONENT DEFAULT_COMPONENT, REPROCESS_TYPE REPROCESS_TYPE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REPLACE_RUN_FLAG REPLACE_RUN_FLAG, USE_OVERRIDE_DATES USE_OVERRIDE_DATES, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_RETRO_COMPONENT_USAGES"
View Text - HTML Formatted

SELECT RETRO_COMPONENT_USAGE_ID RETRO_COMPONENT_USAGE_ID
, RETRO_COMPONENT_ID RETRO_COMPONENT_ID
, CREATOR_ID CREATOR_ID
, CREATOR_TYPE CREATOR_TYPE
, DEFAULT_COMPONENT DEFAULT_COMPONENT
, REPROCESS_TYPE REPROCESS_TYPE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REPLACE_RUN_FLAG REPLACE_RUN_FLAG
, USE_OVERRIDE_DATES USE_OVERRIDE_DATES
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_RETRO_COMPONENT_USAGES"