eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PQH_DE_WRKPLC_VLDTN_VERS

Object Details

Object Name:	PQH_DE_WRKPLC_VLDTN_VERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_DE_WRKPLC_VLDTN_VERS
Subobject Name:
Status:	VALID

DE - Workplace Validation Versions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_DE_WRKPLC_VLDTN_VERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	WRKPLC_VLDTN_VER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WRKPLC_VLDTN_VER_ID	NUMBER	(15)	Yes	Primary Key
WRKPLC_VLDTN_ID	NUMBER	(15)	Yes	Workplace Validation Identifier
VERSION_NUMBER	NUMBER	(10)	Yes	Version Number
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business Group Identifier
TARIFF_CONTRACT_CODE	VARCHAR2	(30)	Yes	Tariff Contract Code
TARIFF_GROUP_CODE	VARCHAR2	(30)	Yes	Tarof Group Code
REMUNERATION_JOB_DESCRIPTION	VARCHAR2	(250)		Renumberation Job Description
JOB_GROUP_ID	NUMBER	(15)		Job Group Identifier
REMUNERATION_JOB_ID	NUMBER	(15)		Renumeration Job Identifier
DERIVED_GRADE_ID	NUMBER	(15)		Derived Grade Identifier
DERIVED_CASE_GROUP_ID	NUMBER	(15)		Derived Case Group Identifier
DERIVED_SUBCASGRP_ID	NUMBER	(15)		Derived Subcase Group Identifier
USER_ENTERABLE_GRADE_ID	NUMBER	(15)		User entered Grade Identifier
USER_ENTERABLE_CASE_GROUP_ID	NUMBER	(15)		User entered case group identifier
USER_ENTERABLE_SUBCASGRP_ID	NUMBER	(15)		User entered subcase group identifier
FREEZE	VARCHAR2	(1)	Yes	freeze flag
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_VERS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_VERS is referenced by following:

APPS: PQH_DE_WRKPLC_VLDTN_VERS; PQH_DE_WRKPLC_VLDTN_VERS_WHO
PUBLIC: PQH_DE_WRKPLC_VLDTN_VERS