[Home] [Help] [Dependency Information]
Object Name: | HR_API_TRANSACTIONS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | (15) | Yes | |
CREATOR_PERSON_ID | NUMBER | (15) | Yes | |
TRANSACTION_PRIVILEGE | VARCHAR2 | (30) | Yes | |
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PRODUCT_CODE | VARCHAR2 | (15) | ||
STATUS | VARCHAR2 | (10) | ||
SECTION_DISPLAY_NAME | VARCHAR2 | (500) | ||
FUNCTION_ID | NUMBER | (10) | ||
TRANSACTION_REF_TABLE | VARCHAR2 | (100) | ||
TRANSACTION_REF_ID | NUMBER | (15) | ||
TRANSACTION_TYPE | VARCHAR2 | (10) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
API_ADDTNL_INFO | VARCHAR2 | (1000) | ||
SELECTED_PERSON_ID | NUMBER | (15) | ||
ITEM_TYPE | VARCHAR2 | (10) | ||
ITEM_KEY | VARCHAR2 | (240) | ||
TRANSACTION_EFFECTIVE_DATE | DATE | |||
PROCESS_NAME | VARCHAR2 | (30) | ||
URL | CLOB | (4000) | ||
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) |
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#;
|
|
|