VIEW: HR.PQH_DE_WRKPLC_VLDTN_VERS#

Source

View Text - Preformatted

select WRKPLC_VLDTN_VER_ID WRKPLC_VLDTN_VER_ID, WRKPLC_VLDTN_ID WRKPLC_VLDTN_ID, VERSION_NUMBER VERSION_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, TARIFF_CONTRACT_CODE TARIFF_CONTRACT_CODE, TARIFF_GROUP_CODE TARIFF_GROUP_CODE, REMUNERATION_JOB_DESCRIPTION REMUNERATION_JOB_DESCRIPTION, JOB_GROUP_ID JOB_GROUP_ID, REMUNERATION_JOB_ID REMUNERATION_JOB_ID, DERIVED_GRADE_ID DERIVED_GRADE_ID, DERIVED_CASE_GROUP_ID DERIVED_CASE_GROUP_ID, DERIVED_SUBCASGRP_ID DERIVED_SUBCASGRP_ID, USER_ENTERABLE_GRADE_ID USER_ENTERABLE_GRADE_ID, USER_ENTERABLE_CASE_GROUP_ID USER_ENTERABLE_CASE_GROUP_ID, USER_ENTERABLE_SUBCASGRP_ID USER_ENTERABLE_SUBCASGRP_ID, FREEZE FREEZE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PQH_DE_WRKPLC_VLDTN_VERS"

View Text - HTML Formatted

SELECT WRKPLC_VLDTN_VER_ID WRKPLC_VLDTN_VER_ID
, WRKPLC_VLDTN_ID WRKPLC_VLDTN_ID
, VERSION_NUMBER VERSION_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TARIFF_CONTRACT_CODE TARIFF_CONTRACT_CODE
, TARIFF_GROUP_CODE TARIFF_GROUP_CODE
, REMUNERATION_JOB_DESCRIPTION REMUNERATION_JOB_DESCRIPTION
, JOB_GROUP_ID JOB_GROUP_ID
, REMUNERATION_JOB_ID REMUNERATION_JOB_ID
, DERIVED_GRADE_ID DERIVED_GRADE_ID
, DERIVED_CASE_GROUP_ID DERIVED_CASE_GROUP_ID
, DERIVED_SUBCASGRP_ID DERIVED_SUBCASGRP_ID
, USER_ENTERABLE_GRADE_ID USER_ENTERABLE_GRADE_ID
, USER_ENTERABLE_CASE_GROUP_ID USER_ENTERABLE_CASE_GROUP_ID
, USER_ENTERABLE_SUBCASGRP_ID USER_ENTERABLE_SUBCASGRP_ID
, FREEZE FREEZE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PQH_DE_WRKPLC_VLDTN_VERS"