VIEW: AP.AP_LINE_APRVL_HIST_ALL#

Source

View Text - Preformatted

select LINE_APRVL_HISTORY_ID LINE_APRVL_HISTORY_ID, LINE_NUMBER LINE_NUMBER, INVOICE_ID INVOICE_ID, ITEM_CLASS ITEM_CLASS, ITEM_ID ITEM_ID, NOTIFICATION_KEY NOTIFICATION_KEY, ITERATION ITERATION, NOTIFICATION_ORDER NOTIFICATION_ORDER, RESPONSE RESPONSE, APPROVER_ID APPROVER_ID, LINE_AMOUNT_APPROVED LINE_AMOUNT_APPROVED, TAX_AMOUNT_APPROVED TAX_AMOUNT_APPROVED, FREIGHT_AMOUNT_APPROVED FREIGHT_AMOUNT_APPROVED, MISC_AMOUNT_APPROVED MISC_AMOUNT_APPROVED, APPROVER_COMMENTS APPROVER_COMMENTS, ORG_ID ORG_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NEW_LINE_NUMBER NEW_LINE_NUMBER, HISTORY_TYPE HISTORY_TYPE, ACCESS_TYPE_CODE ACCESS_TYPE_CODE, ALTERED_FIELD_CODE ALTERED_FIELD_CODE, ALTERED_FIELD_DATA_TYPE ALTERED_FIELD_DATA_TYPE, ORIGINAL_VALUE ORIGINAL_VALUE, NEW_VALUE NEW_VALUE from "AP"."AP_LINE_APRVL_HIST_ALL"

View Text - HTML Formatted

SELECT LINE_APRVL_HISTORY_ID LINE_APRVL_HISTORY_ID
, LINE_NUMBER LINE_NUMBER
, INVOICE_ID INVOICE_ID
, ITEM_CLASS ITEM_CLASS
, ITEM_ID ITEM_ID
, NOTIFICATION_KEY NOTIFICATION_KEY
, ITERATION ITERATION
, NOTIFICATION_ORDER NOTIFICATION_ORDER
, RESPONSE RESPONSE
, APPROVER_ID APPROVER_ID
, LINE_AMOUNT_APPROVED LINE_AMOUNT_APPROVED
, TAX_AMOUNT_APPROVED TAX_AMOUNT_APPROVED
, FREIGHT_AMOUNT_APPROVED FREIGHT_AMOUNT_APPROVED
, MISC_AMOUNT_APPROVED MISC_AMOUNT_APPROVED
, APPROVER_COMMENTS APPROVER_COMMENTS
, ORG_ID ORG_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NEW_LINE_NUMBER NEW_LINE_NUMBER
, HISTORY_TYPE HISTORY_TYPE
, ACCESS_TYPE_CODE ACCESS_TYPE_CODE
, ALTERED_FIELD_CODE ALTERED_FIELD_CODE
, ALTERED_FIELD_DATA_TYPE ALTERED_FIELD_DATA_TYPE
, ORIGINAL_VALUE ORIGINAL_VALUE
, NEW_VALUE NEW_VALUE
FROM "AP"."AP_LINE_APRVL_HIST_ALL"