VIEW: HR.PQH_BUDGET_SETS#

Source

View Text - Preformatted

select BUDGET_SET_ID BUDGET_SET_ID, DFLT_BUDGET_SET_ID DFLT_BUDGET_SET_ID, BUDGET_PERIOD_ID BUDGET_PERIOD_ID, BUDGET_UNIT1_PERCENT BUDGET_UNIT1_PERCENT, BUDGET_UNIT2_PERCENT BUDGET_UNIT2_PERCENT, BUDGET_UNIT3_PERCENT BUDGET_UNIT3_PERCENT, BUDGET_UNIT1_VALUE BUDGET_UNIT1_VALUE, BUDGET_UNIT2_VALUE BUDGET_UNIT2_VALUE, BUDGET_UNIT3_VALUE BUDGET_UNIT3_VALUE, BUDGET_UNIT1_VALUE_TYPE_CD BUDGET_UNIT1_VALUE_TYPE_CD, BUDGET_UNIT2_VALUE_TYPE_CD BUDGET_UNIT2_VALUE_TYPE_CD, BUDGET_UNIT3_VALUE_TYPE_CD BUDGET_UNIT3_VALUE_TYPE_CD, BUDGET_UNIT1_AVAILABLE BUDGET_UNIT1_AVAILABLE, BUDGET_UNIT2_AVAILABLE BUDGET_UNIT2_AVAILABLE, BUDGET_UNIT3_AVAILABLE BUDGET_UNIT3_AVAILABLE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PQH_BUDGET_SETS"

View Text - HTML Formatted

SELECT BUDGET_SET_ID BUDGET_SET_ID
, DFLT_BUDGET_SET_ID DFLT_BUDGET_SET_ID
, BUDGET_PERIOD_ID BUDGET_PERIOD_ID
, BUDGET_UNIT1_PERCENT BUDGET_UNIT1_PERCENT
, BUDGET_UNIT2_PERCENT BUDGET_UNIT2_PERCENT
, BUDGET_UNIT3_PERCENT BUDGET_UNIT3_PERCENT
, BUDGET_UNIT1_VALUE BUDGET_UNIT1_VALUE
, BUDGET_UNIT2_VALUE BUDGET_UNIT2_VALUE
, BUDGET_UNIT3_VALUE BUDGET_UNIT3_VALUE
, BUDGET_UNIT1_VALUE_TYPE_CD BUDGET_UNIT1_VALUE_TYPE_CD
, BUDGET_UNIT2_VALUE_TYPE_CD BUDGET_UNIT2_VALUE_TYPE_CD
, BUDGET_UNIT3_VALUE_TYPE_CD BUDGET_UNIT3_VALUE_TYPE_CD
, BUDGET_UNIT1_AVAILABLE BUDGET_UNIT1_AVAILABLE
, BUDGET_UNIT2_AVAILABLE BUDGET_UNIT2_AVAILABLE
, BUDGET_UNIT3_AVAILABLE BUDGET_UNIT3_AVAILABLE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PQH_BUDGET_SETS"