VIEW: JA.JAI_CMN_MTAX_HDRS_ALL#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, ORG_ID ORG_ID, DOCUMENT_TYPE DOCUMENT_TYPE, FROM_DATE FROM_DATE, TO_DATE TO_DATE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, OLD_TAX_CATEGORY OLD_TAX_CATEGORY, NEW_TAX_CATEGORY NEW_TAX_CATEGORY, PROCESS_PARTIAL PROCESS_PARTIAL, DOCUMENT_NO DOCUMENT_NO, RELEASE_NO RELEASE_NO, DOCUMENT_LINE_NO DOCUMENT_LINE_NO, SHIPMENT_NO SHIPMENT_NO, COMMIT_INTERVAL COMMIT_INTERVAL, OVERRIDE_MANUAL_TAXES OVERRIDE_MANUAL_TAXES, ERROR_MESSAGE ERROR_MESSAGE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_CMN_MTAX_HDRS_ALL"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, ORG_ID ORG_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, OLD_TAX_CATEGORY OLD_TAX_CATEGORY
, NEW_TAX_CATEGORY NEW_TAX_CATEGORY
, PROCESS_PARTIAL PROCESS_PARTIAL
, DOCUMENT_NO DOCUMENT_NO
, RELEASE_NO RELEASE_NO
, DOCUMENT_LINE_NO DOCUMENT_LINE_NO
, SHIPMENT_NO SHIPMENT_NO
, COMMIT_INTERVAL COMMIT_INTERVAL
, OVERRIDE_MANUAL_TAXES OVERRIDE_MANUAL_TAXES
, ERROR_MESSAGE ERROR_MESSAGE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_CMN_MTAX_HDRS_ALL"