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: INV.MTL_3PL_LOCATOR_OCCUPANCY#

Source

View Text - Preformatted


select LOCATOR_ID LOCATOR_ID, ORGANIZATION_ID ORGANIZATION_ID, CLIENT_CODE CLIENT_CODE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, CURRENT_ONHAND CURRENT_ONHAND, LAST_RECEIPT_DATE LAST_RECEIPT_DATE, NUMBER_OF_DAYS NUMBER_OF_DAYS, LAST_INVOICED_DATE LAST_INVOICED_DATE, UPGRADE_DATE UPGRADE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "INV"."MTL_3PL_LOCATOR_OCCUPANCY"

View Text - HTML Formatted

SELECT LOCATOR_ID LOCATOR_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CLIENT_CODE CLIENT_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, CURRENT_ONHAND CURRENT_ONHAND
, LAST_RECEIPT_DATE LAST_RECEIPT_DATE
, NUMBER_OF_DAYS NUMBER_OF_DAYS
, LAST_INVOICED_DATE LAST_INVOICED_DATE
, UPGRADE_DATE UPGRADE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "INV"."MTL_3PL_LOCATOR_OCCUPANCY"