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: TablePQH.PQH_COPY_ENTITY_TXNS
Subobject Name:
Status: VALID


Batch details for Mass Processes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_COPY_ENTITY_TXNS_PK
  1. ColumnCOPY_ENTITY_TXN_ID
Unique Key: PQH_COPY_ENTITY_TXNS_UK
  1. ColumnTRANSACTION_CATEGORY_ID
  2. ColumnCONTEXT_BUSINESS_GROUP_ID
  3. ColumnDISPLAY_NAME
Indexes
Index Type Uniqueness Tablespace Column
PQH_COPY_ENTITY_TXNS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOPY_ENTITY_TXN_ID
PQH_COPY_ENTITY_TXNS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_CATEGORY_ID
ColumnCONTEXT_BUSINESS_GROUP_ID
ColumnDISPLAY_NAME
PQH_COPY_ENTITY_TXNS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTXN_CATEGORY_ATTRIBUTE_ID
PQH_COPY_ENTITY_TXNS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTEXT
PQH_COPY_ENTITY_TXNS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTEXT_BUSINESS_GROUP_ID
PQH_COPY_ENTITY_TXNS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWF_TRANSACTION_CATEGORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK4 TableHR_ALL_ORGANIZATION_UNITS PQH_COPY_ENTITY_TXNS CONTEXT_BUSINESS_GROUP_ID
PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK3 TablePQH_COPY_ENTITY_CONTEXTS PQH_COPY_ENTITY_TXNS CONTEXT
PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK5 TablePQH_TRANSACTION_CATEGORIES PQH_COPY_ENTITY_TXNS WF_TRANSACTION_CATEGORY_ID
PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK1 TablePQH_TRANSACTION_CATEGORIES PQH_COPY_ENTITY_TXNS TRANSACTION_CATEGORY_ID
PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK2 TablePQH_TXN_CATEGORY_ATTRIBUTES PQH_COPY_ENTITY_TXNS TXN_CATEGORY_ATTRIBUTE_ID
TablePQH_COPY_ENTITY_ATTRIBS PQH_COPY_ENTITY_ATTRIBS_FK1 PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_ATTRIBS COPY_ENTITY_TXN_ID
TablePQH_COPY_ENTITY_PREFS PQH_COPY_ENTITY_PREFS_FK1 PQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_PREFS COPY_ENTITY_TXN_ID
TablePQH_COPY_ENTITY_RESULTS PQH_COPY_ENTITY_RESULTS_FK1 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:

SchemaAPPS
SynonymPQH_COPY_ENTITY_TXNS
TriggerPQH_COPY_ENTITY_TXNS_WHO
SchemaPUBLIC
SynonymPQH_COPY_ENTITY_TXNS