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: CLN.M4R_WSM_DWIP_HDR_STAGING#

Source

View Text - Preformatted


select MSG_ID MSG_ID, HDR_ID HDR_ID, GROUP_ID GROUP_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_TYPE TRANSACTION_TYPE, MANUFACTURED_LOC_CODE MANUFACTURED_LOC_CODE, ADDITIONAL_TEXT ADDITIONAL_TEXT, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, PREV_OPERATION_SEQ_NUM PREV_OPERATION_SEQ_NUM, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, STATUS_CHANGE_CODE STATUS_CHANGE_CODE, REASON_CODE REASON_CODE, LOT_NUMBER LOT_NUMBER, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE, SCHEDULED_START_DATE SCHEDULED_START_DATE, PREV_LOT_NUMBER PREV_LOT_NUMBER, PREV_LOT_CLASSIFICATION_CODE PREV_LOT_CLASSIFICATION_CODE, PREV_LOT_UOM PREV_LOT_UOM, PREV_LOT_QTY PREV_LOT_QTY, PRIMARY_ITEM_CODE PRIMARY_ITEM_CODE, PRIMARY_ITEM_REVISION PRIMARY_ITEM_REVISION, STARTING_LOT_ITEM_CODE STARTING_LOT_ITEM_CODE, TRANSFER_TO_LOC_CODE TRANSFER_TO_LOC_CODE, ALT_ROUTING_DESIGNATOR ALT_ROUTING_DESIGNATOR, FROM_SUB_INVENTORY FROM_SUB_INVENTORY, TO_SUB_INVENTORY TO_SUB_INVENTORY, LOT_CODE LOT_CODE, TRANSFER_FROM_ORG TRANSFER_FROM_ORG, TRANSFER_TO_ORG TRANSFER_TO_ORG, STATUS_FLAG STATUS_FLAG, ERROR_MESSAGE ERROR_MESSAGE, CUSTOM_VALID_STATUS CUSTOM_VALID_STATUS, STARTING_LOT_ITEM_REVISION STARTING_LOT_ITEM_REVISION, START_LOT_ALT_ROUT_DESIGNATOR START_LOT_ALT_ROUT_DESIGNATOR, ROUTING_PATH ROUTING_PATH from "CLN"."M4R_WSM_DWIP_HDR_STAGING"

View Text - HTML Formatted

SELECT MSG_ID MSG_ID
, HDR_ID HDR_ID
, GROUP_ID GROUP_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_TYPE TRANSACTION_TYPE
, MANUFACTURED_LOC_CODE MANUFACTURED_LOC_CODE
, ADDITIONAL_TEXT ADDITIONAL_TEXT
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, PREV_OPERATION_SEQ_NUM PREV_OPERATION_SEQ_NUM
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, STATUS_CHANGE_CODE STATUS_CHANGE_CODE
, REASON_CODE REASON_CODE
, LOT_NUMBER LOT_NUMBER
, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, PREV_LOT_NUMBER PREV_LOT_NUMBER
, PREV_LOT_CLASSIFICATION_CODE PREV_LOT_CLASSIFICATION_CODE
, PREV_LOT_UOM PREV_LOT_UOM
, PREV_LOT_QTY PREV_LOT_QTY
, PRIMARY_ITEM_CODE PRIMARY_ITEM_CODE
, PRIMARY_ITEM_REVISION PRIMARY_ITEM_REVISION
, STARTING_LOT_ITEM_CODE STARTING_LOT_ITEM_CODE
, TRANSFER_TO_LOC_CODE TRANSFER_TO_LOC_CODE
, ALT_ROUTING_DESIGNATOR ALT_ROUTING_DESIGNATOR
, FROM_SUB_INVENTORY FROM_SUB_INVENTORY
, TO_SUB_INVENTORY TO_SUB_INVENTORY
, LOT_CODE LOT_CODE
, TRANSFER_FROM_ORG TRANSFER_FROM_ORG
, TRANSFER_TO_ORG TRANSFER_TO_ORG
, STATUS_FLAG STATUS_FLAG
, ERROR_MESSAGE ERROR_MESSAGE
, CUSTOM_VALID_STATUS CUSTOM_VALID_STATUS
, STARTING_LOT_ITEM_REVISION STARTING_LOT_ITEM_REVISION
, START_LOT_ALT_ROUT_DESIGNATOR START_LOT_ALT_ROUT_DESIGNATOR
, ROUTING_PATH ROUTING_PATH
FROM "CLN"."M4R_WSM_DWIP_HDR_STAGING"