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

Object Details

Object Name:	HR_API_TRANSACTIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_API_TRANSACTIONS
Subobject Name:
Status:	VALID

Kiosk processes in progress

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_API_TRANSACTIONS_PK

TRANSACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_TRANSACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
SYS_IL0000044421C00023$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000044421C00028$$	LOB	UNIQUE	APPS_TS_TX_DATA
HR_API_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY
HR_API_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_PERSON_ID SELECTED_PERSON_ID
HR_API_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELECTED_PERSON_ID STATUS
HR_API_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TRANSACTION_ID
HR_API_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_REF_ID TRANSACTION_REF_TABLE
HR_API_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_ROLE
HR_API_TRANSACTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_DATA	TRANSACTION_REF_TABLE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_TRANSACTION_STEPS		HR_API_TRANSACTIONS	HR_API_TRANSACTION_STEPS TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	System-generated primary key column.
CREATOR_PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_PEOPLE_F.
TRANSACTION_PRIVILEGE	VARCHAR2	(30)	Yes	When this column is 'Private', only the creator of the kiosk process can modify the data values associated with it.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
PRODUCT_CODE	VARCHAR2	(15)
STATUS	VARCHAR2	(10)		Transaction Status
SECTION_DISPLAY_NAME	VARCHAR2	(500)		Action Display Name
FUNCTION_ID	NUMBER	(10)		Selected Function
TRANSACTION_REF_TABLE	VARCHAR2	(100)		External TableName
TRANSACTION_REF_ID	NUMBER	(15)		External Table Primary Key
TRANSACTION_TYPE	VARCHAR2	(10)		WorkFlow or not
ASSIGNMENT_ID	NUMBER	(15)		Selected Assignment
API_ADDTNL_INFO	VARCHAR2	(1000)		Any Additional Info
SELECTED_PERSON_ID	NUMBER	(15)		Selected Person Id for this Transaction
ITEM_TYPE	VARCHAR2	(10)
ITEM_KEY	VARCHAR2	(240)
TRANSACTION_EFFECTIVE_DATE	DATE
PROCESS_NAME	VARCHAR2	(30)
URL	CLOB	(4000)		URL to relaunch the suspended Transaction
TRANSACTION_STATE	VARCHAR2	(10)
EFFECTIVE_DATE_OPTION	VARCHAR2	(10)
RPTG_GRP_ID	NUMBER	(15)
PLAN_ID	NUMBER
TRANSACTION_DOCUMENT	CLOB	(4000)
RELAUNCH_FUNCTION	VARCHAR2	(30)
TRANSACTION_GROUP	VARCHAR2	(60)
TRANSACTION_IDENTIFIER	VARCHAR2	(60)
PARENT_TRANSACTION_ID	NUMBER	(15)
CREATOR_ROLE	VARCHAR2	(320)
LAST_UPDATE_ROLE	VARCHAR2	(320)

Query Text

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


SELECT TRANSACTION_ID
,      CREATOR_PERSON_ID
,      TRANSACTION_PRIVILEGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRODUCT_CODE
,      STATUS
,      SECTION_DISPLAY_NAME
,      FUNCTION_ID
,      TRANSACTION_REF_TABLE
,      TRANSACTION_REF_ID
,      TRANSACTION_TYPE
,      ASSIGNMENT_ID
,      API_ADDTNL_INFO
,      SELECTED_PERSON_ID
,      ITEM_TYPE
,      ITEM_KEY
,      TRANSACTION_EFFECTIVE_DATE
,      PROCESS_NAME
,      URL
,      TRANSACTION_STATE
,      EFFECTIVE_DATE_OPTION
,      RPTG_GRP_ID
,      PLAN_ID
,      TRANSACTION_DOCUMENT
,      RELAUNCH_FUNCTION
,      TRANSACTION_GROUP
,      TRANSACTION_IDENTIFIER
,      PARENT_TRANSACTION_ID
,      CREATOR_ROLE
,      LAST_UPDATE_ROLE
FROM HR.HR_API_TRANSACTIONS;

Dependencies

[top of page]

HR.HR_API_TRANSACTIONS does not reference any database object

HR.HR_API_TRANSACTIONS is referenced by following:

HR: HR_API_TRANSACTIONS#