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.

VIEW: FA.FA_DELETED_MASS_ADDITIONS#

Source

View Text - Preformatted


select INVOICE_ID INVOICE_ID, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER, CREATE_BATCH_ID CREATE_BATCH_ID, POST_BATCH_ID POST_BATCH_ID, STATUS STATUS, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID, FEEDER_SYSTEM_NAME FEEDER_SYSTEM_NAME, CREATE_BATCH_DATE CREATE_BATCH_DATE, INVOICE_DATE INVOICE_DATE, PAYABLES_COST PAYABLES_COST, PAYABLES_UNITS PAYABLES_UNITS, REVIEWER_COMMENTS REVIEWER_COMMENTS, BOOK_TYPE_CODE BOOK_TYPE_CODE, DESCRIPTION DESCRIPTION, MASS_ADDITION_ID MASS_ADDITION_ID, PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER from "FA"."FA_DELETED_MASS_ADDITIONS"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER
, CREATE_BATCH_ID CREATE_BATCH_ID
, POST_BATCH_ID POST_BATCH_ID
, STATUS STATUS
, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID
, FEEDER_SYSTEM_NAME FEEDER_SYSTEM_NAME
, CREATE_BATCH_DATE CREATE_BATCH_DATE
, INVOICE_DATE INVOICE_DATE
, PAYABLES_COST PAYABLES_COST
, PAYABLES_UNITS PAYABLES_UNITS
, REVIEWER_COMMENTS REVIEWER_COMMENTS
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DESCRIPTION DESCRIPTION
, MASS_ADDITION_ID MASS_ADDITION_ID
, PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
FROM "FA"."FA_DELETED_MASS_ADDITIONS"