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.

[Home] [Help]

VIEW: HR.AME_TXN_APPROVERS#

Source

View Text - Preformatted


select TXN_APPROVERS_ID TXN_APPROVERS_ID, TEMP_TRANSACTIONS_ID TEMP_TRANSACTIONS_ID, NAME NAME, ORIG_SYSTEM ORIG_SYSTEM, ORIG_SYSTEM_ID ORIG_SYSTEM_ID, DISPLAY_NAME DISPLAY_NAME, APPROVER_CATEGORY APPROVER_CATEGORY, API_INSERTION API_INSERTION, AUTHORITY AUTHORITY, APPROVAL_STATUS APPROVAL_STATUS, ACTION_TYPE_ID ACTION_TYPE_ID, GROUP_OR_CHAIN_ID GROUP_OR_CHAIN_ID, OCCURRENCE OCCURRENCE, SOURCE SOURCE, ITEM_CLASS ITEM_CLASS, ITEM_ID ITEM_ID, ITEM_CLASS_ORDER_NUMBER ITEM_CLASS_ORDER_NUMBER, ITEM_ORDER_NUMBER ITEM_ORDER_NUMBER, SUB_LIST_ORDER_NUMBER SUB_LIST_ORDER_NUMBER, ACTION_TYPE_ORDER_NUMBER ACTION_TYPE_ORDER_NUMBER, GROUP_OR_CHAIN_ORDER_NUMBER GROUP_OR_CHAIN_ORDER_NUMBER, MEMBER_ORDER_NUMBER MEMBER_ORDER_NUMBER, APPROVER_ORDER_NUMBER APPROVER_ORDER_NUMBER, EFFECTIVE_DATE EFFECTIVE_DATE, REASON REASON, JUSTIFICATION JUSTIFICATION, TXN_ATTRIBUTE_1 TXN_ATTRIBUTE_1, TXN_ATTRIBUTE_2 TXN_ATTRIBUTE_2, TXN_ATTRIBUTE_3 TXN_ATTRIBUTE_3, TXN_ATTRIBUTE_4 TXN_ATTRIBUTE_4, TXN_ATTRIBUTE_5 TXN_ATTRIBUTE_5, TXN_ATTRIBUTE_6 TXN_ATTRIBUTE_6, TXN_ATTRIBUTE_7 TXN_ATTRIBUTE_7, TXN_ATTRIBUTE_8 TXN_ATTRIBUTE_8, TXN_ATTRIBUTE_9 TXN_ATTRIBUTE_9, TXN_ATTRIBUTE_10 TXN_ATTRIBUTE_10 from "HR"."AME_TXN_APPROVERS"

View Text - HTML Formatted

SELECT TXN_APPROVERS_ID TXN_APPROVERS_ID
, TEMP_TRANSACTIONS_ID TEMP_TRANSACTIONS_ID
, NAME NAME
, ORIG_SYSTEM ORIG_SYSTEM
, ORIG_SYSTEM_ID ORIG_SYSTEM_ID
, DISPLAY_NAME DISPLAY_NAME
, APPROVER_CATEGORY APPROVER_CATEGORY
, API_INSERTION API_INSERTION
, AUTHORITY AUTHORITY
, APPROVAL_STATUS APPROVAL_STATUS
, ACTION_TYPE_ID ACTION_TYPE_ID
, GROUP_OR_CHAIN_ID GROUP_OR_CHAIN_ID
, OCCURRENCE OCCURRENCE
, SOURCE SOURCE
, ITEM_CLASS ITEM_CLASS
, ITEM_ID ITEM_ID
, ITEM_CLASS_ORDER_NUMBER ITEM_CLASS_ORDER_NUMBER
, ITEM_ORDER_NUMBER ITEM_ORDER_NUMBER
, SUB_LIST_ORDER_NUMBER SUB_LIST_ORDER_NUMBER
, ACTION_TYPE_ORDER_NUMBER ACTION_TYPE_ORDER_NUMBER
, GROUP_OR_CHAIN_ORDER_NUMBER GROUP_OR_CHAIN_ORDER_NUMBER
, MEMBER_ORDER_NUMBER MEMBER_ORDER_NUMBER
, APPROVER_ORDER_NUMBER APPROVER_ORDER_NUMBER
, EFFECTIVE_DATE EFFECTIVE_DATE
, REASON REASON
, JUSTIFICATION JUSTIFICATION
, TXN_ATTRIBUTE_1 TXN_ATTRIBUTE_1
, TXN_ATTRIBUTE_2 TXN_ATTRIBUTE_2
, TXN_ATTRIBUTE_3 TXN_ATTRIBUTE_3
, TXN_ATTRIBUTE_4 TXN_ATTRIBUTE_4
, TXN_ATTRIBUTE_5 TXN_ATTRIBUTE_5
, TXN_ATTRIBUTE_6 TXN_ATTRIBUTE_6
, TXN_ATTRIBUTE_7 TXN_ATTRIBUTE_7
, TXN_ATTRIBUTE_8 TXN_ATTRIBUTE_8
, TXN_ATTRIBUTE_9 TXN_ATTRIBUTE_9
, TXN_ATTRIBUTE_10 TXN_ATTRIBUTE_10
FROM "HR"."AME_TXN_APPROVERS"