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_REPORT_GROUPS

Object Details

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

This table is used to group the exception report definitions so that multiple exception definitions can be run at once.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_EXCEPTION_REPORT_GROUPS_PK

EXCEPTION_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_EXCEPTION_REPORT_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_GROUP_ID
PQP_EXCEPTION_REPORT_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_GROUP_NAME BUSINESS_GROUP_ID LEGISLATION_CODE
PQP_EXCEPTION_REPORT_GROUPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_REPORT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_GROUP_ID	NUMBER	(9)	Yes	System generated primary key column
EXCEPTION_GROUP_NAME	VARCHAR2	(80)	Yes	The name of the exception report group
EXCEPTION_REPORT_ID	NUMBER	(9)	Yes	The exception report id from PQP_EXCEPTION_REPORTS table
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.
CONSOLIDATION_SET_ID	NUMBER	(9)		The consolidation set for which the exception group reports will be run.
PAYROLL_ID	NUMBER	(9)		The payroll for which the exception group reports will be run.
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.
OUTPUT_FORMAT	VARCHAR2	(30)		The type of output required. ie. Text or Spreadsheet enabled

Query Text

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


SELECT EXCEPTION_GROUP_ID
,      EXCEPTION_GROUP_NAME
,      EXCEPTION_REPORT_ID
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      CONSOLIDATION_SET_ID
,      PAYROLL_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      OUTPUT_FORMAT
FROM HR.PQP_EXCEPTION_REPORT_GROUPS;

Dependencies

[top of page]

HR.PQP_EXCEPTION_REPORT_GROUPS does not reference any database object

HR.PQP_EXCEPTION_REPORT_GROUPS is referenced by following:

HR: PQP_EXCEPTION_REPORT_GROUPS#