VIEW: JA.JAI_FA_MASS_ADDITIONS#

Source

View Text - Preformatted

select MASS_ADDITION_ID MASS_ADDITION_ID, INVOICE_ID INVOICE_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, PROCESS_FLAG PROCESS_FLAG, PROCESS_MESSAGE PROCESS_MESSAGE, BOOK_TYPE_CODE BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, CREATE_BATCH_DATE CREATE_BATCH_DATE, INVOICE_NUMBER INVOICE_NUMBER, INVOICE_DATE INVOICE_DATE, VENDOR_NUMBER VENDOR_NUMBER, PO_NUMBER PO_NUMBER, ASSET_TYPE ASSET_TYPE, ACCOUNTING_DATE ACCOUNTING_DATE, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATE_BATCH_ID CREATE_BATCH_ID, DEPRECIATE_STATUS DEPRECIATE_STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER from "JA"."JAI_FA_MASS_ADDITIONS"

View Text - HTML Formatted

SELECT MASS_ADDITION_ID MASS_ADDITION_ID
, INVOICE_ID INVOICE_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, PROCESS_FLAG PROCESS_FLAG
, PROCESS_MESSAGE PROCESS_MESSAGE
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, CREATE_BATCH_DATE CREATE_BATCH_DATE
, INVOICE_NUMBER INVOICE_NUMBER
, INVOICE_DATE INVOICE_DATE
, VENDOR_NUMBER VENDOR_NUMBER
, PO_NUMBER PO_NUMBER
, ASSET_TYPE ASSET_TYPE
, ACCOUNTING_DATE ACCOUNTING_DATE
, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATE_BATCH_ID CREATE_BATCH_ID
, DEPRECIATE_STATUS DEPRECIATE_STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
FROM "JA"."JAI_FA_MASS_ADDITIONS"