VIEW: HR.AME_TEMP_OLD_APPROVER_LISTS#

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, ORDER_NUMBER ORDER_NUMBER, 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, ACTION_TYPE_ID ACTION_TYPE_ID from "HR"."AME_TEMP_OLD_APPROVER_LISTS"

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
, ORDER_NUMBER ORDER_NUMBER
, 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
, ACTION_TYPE_ID ACTION_TYPE_ID
FROM "HR"."AME_TEMP_OLD_APPROVER_LISTS"