VIEW: HR.AME_TEMP_DELETIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, APPLICATION_ID APPLICATION_ID, APPROVAL_TYPE_ID APPROVAL_TYPE_ID, GROUP_OR_CHAIN_ID GROUP_OR_CHAIN_ID, OCCURRENCE OCCURRENCE, USER_ID USER_ID, PERSON_ID PERSON_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, NAME NAME, APPROVER_CATEGORY APPROVER_CATEGORY, ITEM_CLASS ITEM_CLASS, ITEM_ID ITEM_ID, ACTION_TYPE_ID ACTION_TYPE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, REASON REASON, JUSTIFICATION JUSTIFICATION from "HR"."AME_TEMP_DELETIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, APPLICATION_ID APPLICATION_ID
, APPROVAL_TYPE_ID APPROVAL_TYPE_ID
, GROUP_OR_CHAIN_ID GROUP_OR_CHAIN_ID
, OCCURRENCE OCCURRENCE
, USER_ID USER_ID
, PERSON_ID PERSON_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, NAME NAME
, APPROVER_CATEGORY APPROVER_CATEGORY
, ITEM_CLASS ITEM_CLASS
, ITEM_ID ITEM_ID
, ACTION_TYPE_ID ACTION_TYPE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, REASON REASON
, JUSTIFICATION JUSTIFICATION
FROM "HR"."AME_TEMP_DELETIONS"