VIEW: HR.AME_TEMP_INSERTIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, APPLICATION_ID APPLICATION_ID, INSERTION_ORDER INSERTION_ORDER, ORDER_TYPE ORDER_TYPE, PARAMETER PARAMETER, DESCRIPTION DESCRIPTION, USER_ID USER_ID, PERSON_ID PERSON_ID, API_INSERTION API_INSERTION, AUTHORITY AUTHORITY, APPROVAL_STATUS APPROVAL_STATUS, SECURITY_GROUP_ID SECURITY_GROUP_ID, NAME NAME, APPROVER_CATEGORY APPROVER_CATEGORY, ITEM_CLASS ITEM_CLASS, ITEM_ID ITEM_ID, SPECIAL_FORWARDEE SPECIAL_FORWARDEE, EFFECTIVE_DATE EFFECTIVE_DATE, REASON REASON, JUSTIFICATION JUSTIFICATION from "HR"."AME_TEMP_INSERTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, APPLICATION_ID APPLICATION_ID
, INSERTION_ORDER INSERTION_ORDER
, ORDER_TYPE ORDER_TYPE
, PARAMETER PARAMETER
, DESCRIPTION DESCRIPTION
, USER_ID USER_ID
, PERSON_ID PERSON_ID
, API_INSERTION API_INSERTION
, AUTHORITY AUTHORITY
, APPROVAL_STATUS APPROVAL_STATUS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, NAME NAME
, APPROVER_CATEGORY APPROVER_CATEGORY
, ITEM_CLASS ITEM_CLASS
, ITEM_ID ITEM_ID
, SPECIAL_FORWARDEE SPECIAL_FORWARDEE
, EFFECTIVE_DATE EFFECTIVE_DATE
, REASON REASON
, JUSTIFICATION JUSTIFICATION
FROM "HR"."AME_TEMP_INSERTIONS"