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: ISCBV_BOOKINGS_BASE_FCV

Product:	ISC - Supply Chain Intelligence (Obsolete)
Description:	This view is used by the Bookings fact base view to retrieve the latest pick release date of a sales order line
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TXN_SOURCE_LINE_ID LINE_ID
, MAX(PICK_SLIP_DATE) DATE_LATEST_PICK
FROM MTL_TXN_REQUEST_LINES
WHERE (TRANSACTION_TYPE_ID = 52 OR TRANSACTION_TYPE_ID = 53)
AND (TRANSACTION_SOURCE_TYPE_ID = 2 OR TRANSACTION_SOURCE_TYPE_ID = 8) GROUP BY TXN_SOURCE_LINE_ID

Columns

Name
LINE_ID
DATE_LATEST_PICK