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: APPS.WMS_SUGGESTIONS_TRACE_V

Source

View Text - Preformatted


SELECT mtt.rowid row_id, 'MTT' Rec_type, 0 type_code, mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID, mtt.INVENTORY_ITEM_ID, mtt.PRIMARY_QUANTITY quantity, mtt.REVISION , mtt.LOT_NUMBER , mtt.LOT_EXPIRATION_DATE , '' LOT_ATTRIBUTE_CATEGORY , mtt.SERIAL_NUMBER, '' SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID, mtt.pick_strategy_id, mtt.pick_rule_id, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID, mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID, decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE, mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID, mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID, mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID, mtt.put_away_strategy_id putaway_strategy_id, mtt.put_away_rule_id putaway_rule_id, mtt.allocated_lpn_id lpn_id, mtt.secondary_transaction_quantity secondary_quantity, '' grade_code FROM WMS_MATERIAL_TXN_TRACE mtt WHERE mtt.move_order_line_id is not null and ( mtt.transaction_temp_id not in ( select mtlt.transaction_temp_id from wms_transaction_lots_trace mtlt ) ) and (mtt.transaction_temp_id not in (select msnt.transaction_temp_id from wms_serial_numbers_trace msnt ) ) union SELECT mtt.rowid row_id , 'MTT' Rec_type , 0 type_code , mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID , mtt.INVENTORY_ITEM_ID , mtlt.PRIMARY_QUANTITY quantity , mtt.REVISION , mtlt.LOT_NUMBER , mtlt.LOT_EXPIRATION_DATE , mtlt.LOT_ATTRIBUTE_CATEGORY , mtt.SERIAL_NUMBER , '' SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID , mtt.pick_strategy_id , mtt.pick_rule_id , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID , mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE , mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID , mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 ,mtt.COST_GROUP_ID , mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID , mtt.put_away_strategy_id putaway_strategy_id , mtt.put_away_rule_id putaway_rule_id , mtt.allocated_lpn_id lpn_id , mtlt.secondary_quantity secondary_quantity , mtlt.grade_code grade_code FROM WMS_MATERIAL_TXN_TRACE mtt , WMS_transaction_lots_trace mtlt where mtt.move_order_line_id is not null and mtt.transaction_temp_id = mtlt.transaction_temp_id and mtlt.serial_transaction_temp_id is null union SELECT mtt.rowid row_id , 'MTT' Rec_type , 0 type_code , mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID , mtt.INVENTORY_ITEM_ID , 1 quantity , mtt.REVISION , mtt.LOT_NUMBER , mtt.LOT_EXPIRATION_DATE , '' LOT_ATTRIBUTE_CATEGORY , msnt.FM_SERIAL_NUMBER SERIAL_NUMBER , msnt.SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID , mtt.pick_strategy_id , mtt.pick_rule_id , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID , mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE , mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID , mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID , mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID , mtt.put_away_strategy_id putaway_strategy_id , mtt.put_away_rule_id putaway_rule_id , mtt.allocated_lpn_id lpn_id , null secondary_quantity , '' grade_code FROM WMS_MATERIAL_TXN_TRACE mtt , wms_serial_numbers_trace msnt WHERE mtt.move_order_line_id is not null AND mtt.transaction_temp_id = msnt.transaction_temp_id union SELECT mtt.rowid row_id , 'MTT' Rec_type , 0 type_code , mtt.MOVE_ORDER_LINE_ID move_order_line_id , mtt.TRANSACTION_TEMP_ID , mtt.ORGANIZATION_ID , mtt.INVENTORY_ITEM_ID , 1 quantity , mtt.REVISION , mtlt.LOT_NUMBER , mtlt.LOT_EXPIRATION_DATE , mtlt.LOT_ATTRIBUTE_CATEGORY , msnt.fm_SERIAL_NUMBER SERIAL_NUMBER , msnt.SERIAL_ATTRIBUTE_CATEGORY , mtt.ORGANIZATION_ID FROM_ORGANIZATION_ID , mtt.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE , mtt.LOCATOR_ID FROM_LOCATOR_ID , mtt.COST_GROUP_ID FROM_COST_GROUP_ID , mtt.pick_strategy_id , mtt.pick_rule_id , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.ORGANIZATION_ID , 12, mtt.ORGANIZATION_ID , mtt.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.SUBINVENTORY_CODE , 12, mtt.SUBINVENTORY_CODE , mtt.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.LOCATOR_ID , 12, mtt.LOCATOR_ID , mtt.TRANSFER_TO_LOCATION) TO_LOCATOR_ID , decode(mtt.TRANSACTION_ACTION_ID, 27, mtt.COST_GROUP_ID , 12 , mtt.COST_GROUP_ID , mtt.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID , mtt.put_away_strategy_id putaway_strategy_id , mtt.put_away_rule_id putaway_rule_id , mtt.allocated_lpn_id lpn_id , null secondary_quantity , '' grade_code FROM WMS_MATERIAL_TXN_TRACE mtt , wms_transaction_lots_trace mtlt , wms_serial_numbers_trace msnt WHERE mtt.move_order_line_id is not null and mtt.transaction_temp_id = mtlt.transaction_temp_id and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id

View Text - HTML Formatted

SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTT.PRIMARY_QUANTITY QUANTITY
, MTT.REVISION
, MTT.LOT_NUMBER
, MTT.LOT_EXPIRATION_DATE
, '' LOT_ATTRIBUTE_CATEGORY
, MTT.SERIAL_NUMBER
, '' SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTT.SECONDARY_TRANSACTION_QUANTITY SECONDARY_QUANTITY
, '' GRADE_CODE
FROM WMS_MATERIAL_TXN_TRACE MTT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND ( MTT.TRANSACTION_TEMP_ID NOT IN ( SELECT MTLT.TRANSACTION_TEMP_ID
FROM WMS_TRANSACTION_LOTS_TRACE MTLT ) )
AND (MTT.TRANSACTION_TEMP_ID NOT IN (SELECT MSNT.TRANSACTION_TEMP_ID
FROM WMS_SERIAL_NUMBERS_TRACE MSNT ) ) UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, MTLT.PRIMARY_QUANTITY QUANTITY
, MTT.REVISION
, MTLT.LOT_NUMBER
, MTLT.LOT_EXPIRATION_DATE
, MTLT.LOT_ATTRIBUTE_CATEGORY
, MTT.SERIAL_NUMBER
, '' SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, MTLT.SECONDARY_QUANTITY SECONDARY_QUANTITY
, MTLT.GRADE_CODE GRADE_CODE
FROM WMS_MATERIAL_TXN_TRACE MTT
, WMS_TRANSACTION_LOTS_TRACE MTLT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID
AND MTLT.SERIAL_TRANSACTION_TEMP_ID IS NULL UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, 1 QUANTITY
, MTT.REVISION
, MTT.LOT_NUMBER
, MTT.LOT_EXPIRATION_DATE
, '' LOT_ATTRIBUTE_CATEGORY
, MSNT.FM_SERIAL_NUMBER SERIAL_NUMBER
, MSNT.SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, NULL SECONDARY_QUANTITY
, '' GRADE_CODE
FROM WMS_MATERIAL_TXN_TRACE MTT
, WMS_SERIAL_NUMBERS_TRACE MSNT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID UNION SELECT MTT.ROWID ROW_ID
, 'MTT' REC_TYPE
, 0 TYPE_CODE
, MTT.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MTT.TRANSACTION_TEMP_ID
, MTT.ORGANIZATION_ID
, MTT.INVENTORY_ITEM_ID
, 1 QUANTITY
, MTT.REVISION
, MTLT.LOT_NUMBER
, MTLT.LOT_EXPIRATION_DATE
, MTLT.LOT_ATTRIBUTE_CATEGORY
, MSNT.FM_SERIAL_NUMBER SERIAL_NUMBER
, MSNT.SERIAL_ATTRIBUTE_CATEGORY
, MTT.ORGANIZATION_ID FROM_ORGANIZATION_ID
, MTT.SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MTT.LOCATOR_ID FROM_LOCATOR_ID
, MTT.COST_GROUP_ID FROM_COST_GROUP_ID
, MTT.PICK_STRATEGY_ID
, MTT.PICK_RULE_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.ORGANIZATION_ID
, 12
, MTT.ORGANIZATION_ID
, MTT.TRANSFER_ORGANIZATION) TO_ORGANIZATION_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.SUBINVENTORY_CODE
, 12
, MTT.SUBINVENTORY_CODE
, MTT.TRANSFER_SUBINVENTORY ) TO_SUBINVENTORY_CODE
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.LOCATOR_ID
, 12
, MTT.LOCATOR_ID
, MTT.TRANSFER_TO_LOCATION) TO_LOCATOR_ID
, DECODE(MTT.TRANSACTION_ACTION_ID
, 27
, MTT.COST_GROUP_ID
, 12
, MTT.COST_GROUP_ID
, MTT.TRANSFER_COST_GROUP_ID) TO_COST_GROUP_ID
, MTT.PUT_AWAY_STRATEGY_ID PUTAWAY_STRATEGY_ID
, MTT.PUT_AWAY_RULE_ID PUTAWAY_RULE_ID
, MTT.ALLOCATED_LPN_ID LPN_ID
, NULL SECONDARY_QUANTITY
, '' GRADE_CODE
FROM WMS_MATERIAL_TXN_TRACE MTT
, WMS_TRANSACTION_LOTS_TRACE MTLT
, WMS_SERIAL_NUMBERS_TRACE MSNT
WHERE MTT.MOVE_ORDER_LINE_ID IS NOT NULL
AND MTT.TRANSACTION_TEMP_ID = MTLT.TRANSACTION_TEMP_ID
AND MTLT.SERIAL_TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID