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_CMN_MATCH_RECEIPTS#

Source

View Text - Preformatted


select RECEIPT_ID RECEIPT_ID, REF_LINE_ID REF_LINE_ID, SUBINVENTORY SUBINVENTORY, QUANTITY_APPLIED QUANTITY_APPLIED, ISSUE_UOM ISSUE_UOM, ORDER_INVOICE ORDER_INVOICE, SHIP_STATUS SHIP_STATUS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, RECEIPT_QUANTITY_APPLIED RECEIPT_QUANTITY_APPLIED, RECEIPT_QUANTITY_UOM RECEIPT_QUANTITY_UOM, REF_LINE_NO REF_LINE_NO, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_CMN_MATCH_RECEIPTS"

View Text - HTML Formatted

SELECT RECEIPT_ID RECEIPT_ID
, REF_LINE_ID REF_LINE_ID
, SUBINVENTORY SUBINVENTORY
, QUANTITY_APPLIED QUANTITY_APPLIED
, ISSUE_UOM ISSUE_UOM
, ORDER_INVOICE ORDER_INVOICE
, SHIP_STATUS SHIP_STATUS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, RECEIPT_QUANTITY_APPLIED RECEIPT_QUANTITY_APPLIED
, RECEIPT_QUANTITY_UOM RECEIPT_QUANTITY_UOM
, REF_LINE_NO REF_LINE_NO
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_CMN_MATCH_RECEIPTS"