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.

[Home] [Help]

VIEW: JA.JAI_RETRO_LINE_CHANGES#

Source

View Text - Preformatted


select LINE_CHANGE_ID LINE_CHANGE_ID, DOC_TYPE DOC_TYPE, DOC_HEADER_ID DOC_HEADER_ID, DOC_LINE_ID DOC_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, FROM_HEADER_ID FROM_HEADER_ID, FROM_LINE_ID FROM_LINE_ID, DOC_VERSION_NUMBER DOC_VERSION_NUMBER, SOURCE_LINE_CHANGE_ID SOURCE_LINE_CHANGE_ID, PRICE_CHANGE_DATE PRICE_CHANGE_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, ORIGINAL_UNIT_PRICE ORIGINAL_UNIT_PRICE, MODIFIED_UNIT_PRICE MODIFIED_UNIT_PRICE, RECEIPT_PROCESSED_FLAG RECEIPT_PROCESSED_FLAG, EXCISE_ACTION EXCISE_ACTION, VAT_ACTION VAT_ACTION, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INVOICE_DATE VAT_INVOICE_DATE, RETRO_REQUEST_ID RETRO_REQUEST_ID, DOC_NUMBER DOC_NUMBER, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_RETRO_LINE_CHANGES"

View Text - HTML Formatted

SELECT LINE_CHANGE_ID LINE_CHANGE_ID
, DOC_TYPE DOC_TYPE
, DOC_HEADER_ID DOC_HEADER_ID
, DOC_LINE_ID DOC_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_LINE_ID FROM_LINE_ID
, DOC_VERSION_NUMBER DOC_VERSION_NUMBER
, SOURCE_LINE_CHANGE_ID SOURCE_LINE_CHANGE_ID
, PRICE_CHANGE_DATE PRICE_CHANGE_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ORIGINAL_UNIT_PRICE ORIGINAL_UNIT_PRICE
, MODIFIED_UNIT_PRICE MODIFIED_UNIT_PRICE
, RECEIPT_PROCESSED_FLAG RECEIPT_PROCESSED_FLAG
, EXCISE_ACTION EXCISE_ACTION
, VAT_ACTION VAT_ACTION
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INVOICE_DATE VAT_INVOICE_DATE
, RETRO_REQUEST_ID RETRO_REQUEST_ID
, DOC_NUMBER DOC_NUMBER
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_RETRO_LINE_CHANGES"