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]

VIEW: APPS.PQH_CRITERIA_RATE_DEFN_VL

Object Details

Object Name:	PQH_CRITERIA_RATE_DEFN_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Criteria Rate View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CRITERIA_RATE_DEFN_ID	NUMBER	(15)	Yes	Uniquely identifies a criteria rate definition.
NAME	VARCHAR2	(240)	Yes	Criteria rate definition name.
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.

Query Text

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


SELECT CRITERIA_RATE_DEFN_ID
,      NAME
,      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
FROM APPS.PQH_CRITERIA_RATE_DEFN_VL;

Dependencies

[top of page]

APPS.PQH_CRITERIA_RATE_DEFN_VL references the following:

APPS: PQH_CRITERIA_RATE_DEFN; PQH_CRITERIA_RATE_DEFN_TL

APPS.PQH_CRITERIA_RATE_DEFN_VL is referenced by following:

APPS: PQH_CRL_UPD - show dependent code; PQH_RBC_LOAD_OBJECTS - show dependent code; PQH_RBC_STAGE - show dependent code; PQH_RBC_STAGE_TO_RBC - show dependent code; PQH_RBC_UTILITY - show dependent code; PQH_RBC_VALIDATE - show dependent code