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_COPY_ENTITY_TXNS

Object Details

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

Batch details for Mass Processes

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_COPY_ENTITY_TXNS_PK

COPY_ENTITY_TXN_ID

Unique Key: PQH_COPY_ENTITY_TXNS_UK

TRANSACTION_CATEGORY_ID
CONTEXT_BUSINESS_GROUP_ID
DISPLAY_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_COPY_ENTITY_TXNS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	COPY_ENTITY_TXN_ID
PQH_COPY_ENTITY_TXNS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_CATEGORY_ID CONTEXT_BUSINESS_GROUP_ID DISPLAY_NAME
PQH_COPY_ENTITY_TXNS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TXN_CATEGORY_ATTRIBUTE_ID
PQH_COPY_ENTITY_TXNS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTEXT
PQH_COPY_ENTITY_TXNS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTEXT_BUSINESS_GROUP_ID
PQH_COPY_ENTITY_TXNS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_TRANSACTION_CATEGORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_COPY_ENTITY_TXNS	HR_ALL_ORGANIZATION_UNITS	PQH_COPY_ENTITY_TXNS CONTEXT_BUSINESS_GROUP_ID
PQH_COPY_ENTITY_TXNS	PQH_COPY_ENTITY_CONTEXTS	PQH_COPY_ENTITY_TXNS CONTEXT
PQH_COPY_ENTITY_TXNS	PQH_TRANSACTION_CATEGORIES	PQH_COPY_ENTITY_TXNS WF_TRANSACTION_CATEGORY_ID
PQH_COPY_ENTITY_TXNS	PQH_TRANSACTION_CATEGORIES	PQH_COPY_ENTITY_TXNS TRANSACTION_CATEGORY_ID
PQH_COPY_ENTITY_TXNS	PQH_TXN_CATEGORY_ATTRIBUTES	PQH_COPY_ENTITY_TXNS TXN_CATEGORY_ATTRIBUTE_ID
PQH_COPY_ENTITY_ATTRIBS	PQH_COPY_ENTITY_TXNS	PQH_COPY_ENTITY_ATTRIBS COPY_ENTITY_TXN_ID
PQH_COPY_ENTITY_PREFS	PQH_COPY_ENTITY_TXNS	PQH_COPY_ENTITY_PREFS COPY_ENTITY_TXN_ID
PQH_COPY_ENTITY_RESULTS	PQH_COPY_ENTITY_TXNS	PQH_COPY_ENTITY_RESULTS COPY_ENTITY_TXN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COPY_ENTITY_TXN_ID	NUMBER	(15)	Yes	Primary Key ( Batch Identifer )
CONTEXT	VARCHAR2	(27)	Yes	Context Identifier
ACTION_DATE	DATE			Transaction Effective Date
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	Transaction Category identifier
SRC_EFFECTIVE_DATE	DATE			Effective to query Original Record
TXN_CATEGORY_ATTRIBUTE_ID	NUMBER	(15)		Attribute identifier for special operation
DISPLAY_NAME	VARCHAR2	(100)	Yes	Batch Name
REPLACEMENT_TYPE_CD	VARCHAR2	(30)		Special Operation (Replace/Prefix/ Suffix)
START_WITH	VARCHAR2	(255)		Start with (Used in conjuction with special operation)
INCREMENT_BY	NUMBER	(15)		Increment value (used in conjuction with start with)
NUMBER_OF_COPIES	NUMBER	(10)		Default number of copies
STATUS	VARCHAR2	(30)		Batch Status (Pending Query/Pending Original records/Pending New Records/Error New records/ completed)
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version Number
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		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
CONTEXT_BUSINESS_GROUP_ID	NUMBER	(15)		Transaction Business Group
DATETRACK_MODE	VARCHAR2	(30)		Date track mode for Date track mass updates (Update/ correction/update insert/update override)
WF_TRANSACTION_CATEGORY_ID	NUMBER	(15)		Transaction Category Identifier for Work flow

Query Text

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


SELECT COPY_ENTITY_TXN_ID
,      CONTEXT
,      ACTION_DATE
,      TRANSACTION_CATEGORY_ID
,      SRC_EFFECTIVE_DATE
,      TXN_CATEGORY_ATTRIBUTE_ID
,      DISPLAY_NAME
,      REPLACEMENT_TYPE_CD
,      START_WITH
,      INCREMENT_BY
,      NUMBER_OF_COPIES
,      STATUS
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CONTEXT_BUSINESS_GROUP_ID
,      DATETRACK_MODE
,      WF_TRANSACTION_CATEGORY_ID
FROM HR.PQH_COPY_ENTITY_TXNS;

Dependencies

[top of page]

HR.PQH_COPY_ENTITY_TXNS does not reference any database object

HR.PQH_COPY_ENTITY_TXNS is referenced by following:

APPS: PQH_COPY_ENTITY_TXNS; PQH_COPY_ENTITY_TXNS_WHO
PUBLIC: PQH_COPY_ENTITY_TXNS