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_CRITERIA_RATE_DEFN

Object Details

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

Table to store different criteria rate definitions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_CRITERIA_RATE_DEFN_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CRITERIA_RATE_DEFN_ID ZD_EDITION_NAME
PQH_CRITERIA_RATE_DEFN_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME BUSINESS_GROUP_ID ZD_EDITION_NAME
PQH_CRITERIA_RATE_DEFN_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PQH_CRITERIA_RATE_DEFN_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CRITERIA_RATE_DEFN_ID	NUMBER	(15)	Yes	Uniquely identifies a criteria rate definition.
SHORT_NAME	VARCHAR2	(30)	Yes	Unique short name for a criteria rate definition in the business group.
UOM	VARCHAR2	(30)	Yes	Unit of measure.
CURRENCY_CODE	VARCHAR2	(30)		Currency code.
REFERENCE_PERIOD_CD	VARCHAR2	(30)		Reference period code.
DEFINE_MAX_RATE_FLAG	VARCHAR2	(10)		Indicates if maximum rate value must be defined for this criteria rate definition.
DEFINE_MIN_RATE_FLAG	VARCHAR2	(10)		Indicates if minimum rate value must be defined for this criteria rate definition.
DEFINE_MID_RATE_FLAG	VARCHAR2	(10)		Indicates if mid rate value must be defined for this criteria rate definition.
DEFINE_STD_RATE_FLAG	VARCHAR2	(10)		Indicates if default rate value must be defined for this criteria rate definition.
RATE_CALC_CD	VARCHAR2	(30)	Yes	Rate calculation method code.
RATE_CALC_RULE	NUMBER	(15)		Fast formula for rate calculation.
PREFERENTIAL_RATE_CD	VARCHAR2	(30)	Yes	Preferential rate code.
PREFERENTIAL_RATE_RULE	NUMBER	(15)		Fast formula to calculate preferential rate.
ROUNDING_CD	VARCHAR2	(30)	Yes	Rounding code.
ROUNDING_RULE	NUMBER	(15)		Fast formula to perform rate rounding.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield segment.
LAST_UPDATE_DATE	DATE			Last update date.
LAST_UPDATED_BY	NUMBER	(15)		Last updated by.
LAST_UPDATE_LOGIN	NUMBER	(15)		Last update login.
CREATED_BY	NUMBER	(15)	Yes	Created by.
CREATION_DATE	DATE		Yes	Creation date.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Identifies the version of the criteria rate definition.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT CRITERIA_RATE_DEFN_ID
,      SHORT_NAME
,      UOM
,      CURRENCY_CODE
,      REFERENCE_PERIOD_CD
,      DEFINE_MAX_RATE_FLAG
,      DEFINE_MIN_RATE_FLAG
,      DEFINE_MID_RATE_FLAG
,      DEFINE_STD_RATE_FLAG
,      RATE_CALC_CD
,      RATE_CALC_RULE
,      PREFERENTIAL_RATE_CD
,      PREFERENTIAL_RATE_RULE
,      ROUNDING_CD
,      ROUNDING_RULE
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM HR.PQH_CRITERIA_RATE_DEFN;

Dependencies

[top of page]

HR.PQH_CRITERIA_RATE_DEFN does not reference any database object

HR.PQH_CRITERIA_RATE_DEFN is referenced by following:

HR: PQH_CRITERIA_RATE_DEFN#