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_TRANSACTION_STEPS

Object Details

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

HR_API_TRANSACTION_STEPS contains one row for each row of data that
will be saved for a Web Kiosk process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_API_TRANSACTION_STEPS_PK

TRANSACTION_STEP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_TRANSACTION_STEPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_STEP_ID
HR_API_TRANSACTION_STEPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
HR_API_TRANSACTION_STEPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY ACTIVITY_ID
HR_API_TRANSACTION_STEPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	API_NAME
HR_API_TRANSACTION_STEPS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_PERSON_ID
HR_API_TRANSACTION_STEPS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPDATE_PERSON_ID
HR_API_TRANSACTION_STEPS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_NAME PK1 PK2 PK3 PK4 PK5
HR_API_TRANSACTION_STEPS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_IDENTIFIER OBJECT_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_TRANSACTION_STEPS		HR_API_TRANSACTIONS	HR_API_TRANSACTION_STEPS TRANSACTION_ID
HR_API_TRANSACTION_VALUES		HR_API_TRANSACTION_STEPS	HR_API_TRANSACTION_VALUES TRANSACTION_STEP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_STEP_ID	NUMBER	(15)	Yes	System-generated primary key column.
TRANSACTION_ID	NUMBER	(15)		Foreign key to HR_API_TRANSACTIONS.
API_NAME	VARCHAR2	(61)	Yes	Name of the API that should be called to write this datarow to the HR schema.
API_DISPLAY_NAME	VARCHAR2	(61)		Name of the procedure within a web page that displays the data values for a this transaction step within the kiosk process.
PROCESSING_ORDER	NUMBER	(5)	Yes	Order that the transaction steps need to be dealt with.
ITEM_TYPE	VARCHAR2	(8)		Workflow key value.
ITEM_KEY	VARCHAR2	(240)		Workflow key value.
ACTIVITY_ID	NUMBER			Workflow key value.
CREATOR_PERSON_ID	NUMBER	(15)	Yes	Foreigh key to PER_PEOPLE_F.
UPDATE_PERSON_ID	NUMBER	(15)		Foreign key to PER_PEOPLE_F.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
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.
OBJECT_TYPE	VARCHAR2	(30)		Object Type
OBJECT_NAME	VARCHAR2	(150)		Object Name
OBJECT_IDENTIFIER	VARCHAR2	(240)		Object Identifier
PK1	VARCHAR2	(240)		PK1
PK2	VARCHAR2	(240)		PK2
PK3	VARCHAR2	(240)		PK3
PK4	VARCHAR2	(240)		PK4
PK5	VARCHAR2	(240)		PK5
OBJECT_STATE	VARCHAR2	(10)		Object State
INFORMATION_CATEGORY	VARCHAR2	(30)		Information Category
INFORMATION1	VARCHAR2	(150)		Information1
INFORMATION2	VARCHAR2	(150)		Information2
INFORMATION3	VARCHAR2	(150)		Information3
INFORMATION4	VARCHAR2	(150)		Information4
INFORMATION5	VARCHAR2	(150)		Information5
INFORMATION6	VARCHAR2	(150)		Information6
INFORMATION7	VARCHAR2	(150)		Information7
INFORMATION8	VARCHAR2	(150)		Information8
INFORMATION9	VARCHAR2	(150)		Information9
INFORMATION10	VARCHAR2	(150)		Information10
INFORMATION11	VARCHAR2	(150)		Information11
INFORMATION12	VARCHAR2	(150)		Information12
INFORMATION13	VARCHAR2	(150)		Information13
INFORMATION14	VARCHAR2	(150)		Information14
INFORMATION15	VARCHAR2	(150)		Information15
INFORMATION16	VARCHAR2	(150)		Information16
INFORMATION17	VARCHAR2	(150)		Information17
INFORMATION18	VARCHAR2	(150)		Information18
INFORMATION19	VARCHAR2	(150)		Information19
INFORMATION20	VARCHAR2	(150)		Information20
INFORMATION21	VARCHAR2	(150)		Information21
INFORMATION22	VARCHAR2	(150)		Information22
INFORMATION23	VARCHAR2	(150)		Information23
INFORMATION24	VARCHAR2	(150)		Information24
INFORMATION25	VARCHAR2	(150)		Information25
INFORMATION26	VARCHAR2	(150)		Information26
INFORMATION27	VARCHAR2	(150)		Information27
INFORMATION28	VARCHAR2	(150)		Information28
INFORMATION29	VARCHAR2	(150)		Information29
INFORMATION30	VARCHAR2	(150)		Information30

Query Text

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


SELECT TRANSACTION_STEP_ID
,      TRANSACTION_ID
,      API_NAME
,      API_DISPLAY_NAME
,      PROCESSING_ORDER
,      ITEM_TYPE
,      ITEM_KEY
,      ACTIVITY_ID
,      CREATOR_PERSON_ID
,      UPDATE_PERSON_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_TYPE
,      OBJECT_NAME
,      OBJECT_IDENTIFIER
,      PK1
,      PK2
,      PK3
,      PK4
,      PK5
,      OBJECT_STATE
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
FROM HR.HR_API_TRANSACTION_STEPS;

Dependencies

[top of page]

HR.HR_API_TRANSACTION_STEPS does not reference any database object

HR.HR_API_TRANSACTION_STEPS is referenced by following:

APPS: HR_API_TRANSACTION_STEPS; HR_API_TRANSACTION_STEPS_WHO; HR_TRAN_STEP_UPDATE_PERSON_ID
PUBLIC: HR_API_TRANSACTION_STEPS