[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
---|
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 |
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;
HR.PQH_COPY_ENTITY_TXNS does not reference any database object
HR.PQH_COPY_ENTITY_TXNS is referenced by following:
|
|
|