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: WMS.WMS_ELS_EXP_RESOURCE#

Source

View Text - Preformatted


select ELS_EXP_RESOURCE_ID ELS_EXP_RESOURCE_ID, ORGANIZATION_ID ORGANIZATION_ID, ACTIVITY_ID ACTIVITY_ID, ACTIVITY_DETAIL_ID ACTIVITY_DETAIL_ID, OPERATION_ID OPERATION_ID, DOCUMENT_TYPE DOCUMENT_TYPE, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, SOURCE_LOCATOR_ID SOURCE_LOCATOR_ID, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, DESTINATION_LOCATOR_ID DESTINATION_LOCATOR_ID, SOURCE_ZONE_ID SOURCE_ZONE_ID, DESTINATION_ZONE_ID DESTINATION_ZONE_ID, TRANSACTION_UOM TRANSACTION_UOM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QUANTITY QUANTITY, ITEM_CATEGORY_ID ITEM_CATEGORY_ID, OPERATION_PLAN_ID OPERATION_PLAN_ID, SOURCE_HEADER_ID SOURCE_HEADER_ID, SOURCE_LINE_ID SOURCE_LINE_ID, GROUP_ID GROUP_ID, UNATTRIBUTED_FLAG UNATTRIBUTED_FLAG, ELS_DATA_ID ELS_DATA_ID, ESTIMATED_TIME_REQUIRED ESTIMATED_TIME_REQUIRED, ESTIMATED_RESOURCE_REQUIRED ESTIMATED_RESOURCE_REQUIRED, WORK_SCHEDULED_DATE WORK_SCHEDULED_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "WMS"."WMS_ELS_EXP_RESOURCE"

View Text - HTML Formatted

SELECT ELS_EXP_RESOURCE_ID ELS_EXP_RESOURCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ACTIVITY_ID ACTIVITY_ID
, ACTIVITY_DETAIL_ID ACTIVITY_DETAIL_ID
, OPERATION_ID OPERATION_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, SOURCE_LOCATOR_ID SOURCE_LOCATOR_ID
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, DESTINATION_LOCATOR_ID DESTINATION_LOCATOR_ID
, SOURCE_ZONE_ID SOURCE_ZONE_ID
, DESTINATION_ZONE_ID DESTINATION_ZONE_ID
, TRANSACTION_UOM TRANSACTION_UOM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUANTITY QUANTITY
, ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, OPERATION_PLAN_ID OPERATION_PLAN_ID
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, GROUP_ID GROUP_ID
, UNATTRIBUTED_FLAG UNATTRIBUTED_FLAG
, ELS_DATA_ID ELS_DATA_ID
, ESTIMATED_TIME_REQUIRED ESTIMATED_TIME_REQUIRED
, ESTIMATED_RESOURCE_REQUIRED ESTIMATED_RESOURCE_REQUIRED
, WORK_SCHEDULED_DATE WORK_SCHEDULED_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "WMS"."WMS_ELS_EXP_RESOURCE"