DBA Data[Home] [Help]

VIEW: HR.PAY_SHADOW_FORMULAS#

Source

View Text - Preformatted

select FORMULA_ID FORMULA_ID, TEMPLATE_TYPE TEMPLATE_TYPE, LEGISLATION_CODE LEGISLATION_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, FORMULA_NAME FORMULA_NAME, DESCRIPTION DESCRIPTION, 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, FORMULA_TEXT FORMULA_TEXT, FORMULA_TYPE_NAME FORMULA_TYPE_NAME, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_SHADOW_FORMULAS"
View Text - HTML Formatted

SELECT FORMULA_ID FORMULA_ID
, TEMPLATE_TYPE TEMPLATE_TYPE
, LEGISLATION_CODE LEGISLATION_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, FORMULA_NAME FORMULA_NAME
, DESCRIPTION DESCRIPTION
, 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
, FORMULA_TEXT FORMULA_TEXT
, FORMULA_TYPE_NAME FORMULA_TYPE_NAME
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_SHADOW_FORMULAS"