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.PQP_EXCEPTION_REPORTS

Object Details

Object Name:	PQP_EXCEPTION_REPORTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_EXCEPTION_REPORTS
Subobject Name:
Status:	VALID

Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_EXCEPTION_REPORTS_PK

EXCEPTION_REPORT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_EXCEPTION_REPORTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_REPORT_ID
PQP_EXCEPTION_REPORTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_REPORT_NAME BUSINESS_GROUP_ID LEGISLATION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_REPORT_ID	NUMBER	(9)	Yes	System generated primary key column
EXCEPTION_REPORT_NAME	VARCHAR2	(80)	Yes	The name for the exception report.
LEGISLATION_CODE	VARCHAR2	(30)		The Legislation code for which the data in the table is associated with.
BUSINESS_GROUP_ID	NUMBER	(15)		The Business group for which the table row is associated with.
CURRENCY_CODE	VARCHAR2	(15)		The currency code of the Business group.
BALANCE_TYPE_ID	NUMBER	(9)		Foreign key to the PAY_BALANCE_TYPES table.
BALANCE_DIMENSION_ID	NUMBER	(9)		Foreign key to the PAY_BALANCE_DIMENSIONS table.
VARIANCE_TYPE	VARCHAR2	(30)		The variance type for the exception report. The values can be 'P' for Percentage and 'A' for Amount.
VARIANCE_VALUE	NUMBER	(11)		The variance value defined for the exception report.
COMPARISON_TYPE	VARCHAR2	(30)		The type of comparison that needs to be done for the defined balance.
COMPARISON_VALUE	NUMBER	(9)		The comparison value applicable only if the comparison type is based on average.
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	System generated version of row. Increments by one with each update.
VARIANCE_OPERATOR	VARCHAR2	(30)		Variance operator is the relationship between variance type and value. Examples are >=, >, < etc.
OUTPUT_FORMAT	VARCHAR2	(30)		The type of report required. A regular text report or a spreadsheet enabled comma delimited file.

Query Text

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


SELECT EXCEPTION_REPORT_ID
,      EXCEPTION_REPORT_NAME
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      CURRENCY_CODE
,      BALANCE_TYPE_ID
,      BALANCE_DIMENSION_ID
,      VARIANCE_TYPE
,      VARIANCE_VALUE
,      COMPARISON_TYPE
,      COMPARISON_VALUE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      VARIANCE_OPERATOR
,      OUTPUT_FORMAT
FROM HR.PQP_EXCEPTION_REPORTS;

Dependencies

[top of page]

HR.PQP_EXCEPTION_REPORTS does not reference any database object

HR.PQP_EXCEPTION_REPORTS is referenced by following:

APPS: PQP_EXCEPTION_REPORTS; PQP_EXCEPTION_REPORTS_WHO
PUBLIC: PQP_EXCEPTION_REPORTS