VIEW: AP.AP_APINV_APPROVERS#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, INVOICE_ITERATION INVOICE_ITERATION, INVOICE_KEY INVOICE_KEY, LINE_NUMBER LINE_NUMBER, NOTIFICATION_ITERATION NOTIFICATION_ITERATION, NOTIFICATION_KEY NOTIFICATION_KEY, NOTIFICATION_STATUS NOTIFICATION_STATUS, ROLE_NAME ROLE_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, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, EXTERNAL_ROLE_NAME EXTERNAL_ROLE_NAME, ACCESS_CONTROL_FLAG ACCESS_CONTROL_FLAG, CHILD_PROCESS_ITEM_TYPE CHILD_PROCESS_ITEM_TYPE, CHILD_PROCESS_ITEM_KEY CHILD_PROCESS_ITEM_KEY, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY from "AP"."AP_APINV_APPROVERS"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, INVOICE_ITERATION INVOICE_ITERATION
, INVOICE_KEY INVOICE_KEY
, LINE_NUMBER LINE_NUMBER
, NOTIFICATION_ITERATION NOTIFICATION_ITERATION
, NOTIFICATION_KEY NOTIFICATION_KEY
, NOTIFICATION_STATUS NOTIFICATION_STATUS
, ROLE_NAME ROLE_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
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, EXTERNAL_ROLE_NAME EXTERNAL_ROLE_NAME
, ACCESS_CONTROL_FLAG ACCESS_CONTROL_FLAG
, CHILD_PROCESS_ITEM_TYPE CHILD_PROCESS_ITEM_TYPE
, CHILD_PROCESS_ITEM_KEY CHILD_PROCESS_ITEM_KEY
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
FROM "AP"."AP_APINV_APPROVERS"