/* Formatted on 2012/07/16 17:42 (Formatter Plus v4.8.8) */
SELECT 'Staging', inventory_org,COUNT (item), serial_number, --to_subinventory,
from_subinventory, transaction_quantity, transaction_type,
transaction_date, to_loc_segment1, to_loc_segment2,
to_loc_segment3, to_loc_segment4, from_loc_segment1,
from_loc_segment2, from_loc_segment3, from_loc_segment4,
to_crew_number, from_crew_number
FROM xxmtz_inv_scan_trans_stg
GROUP BY inventory_org,
serial_number,
to_subinventory,
from_subinventory,
transaction_quantity,
transaction_type,
transaction_date,
to_loc_segment1,
to_loc_segment2,
to_loc_segment3,
to_loc_segment4,
from_loc_segment1,
from_loc_segment2,
from_loc_segment3,
from_loc_segment4,
to_crew_number,
from_crew_number
HAVING COUNT (item) >= 2
No comments:
Post a Comment