salix/db/routines/vn2008/views/V_edi_item_track.sql

20 lines
679 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`V_edi_item_track`
AS SELECT `edi`.`item_track`.`item_id` AS `item_id`,
`edi`.`item_track`.`s1` AS `s1`,
`edi`.`item_track`.`s2` AS `s2`,
`edi`.`item_track`.`s3` AS `s3`,
`edi`.`item_track`.`s4` AS `s4`,
`edi`.`item_track`.`s5` AS `s5`,
`edi`.`item_track`.`s6` AS `s6`,
`edi`.`item_track`.`kop` AS `kop`,
`edi`.`item_track`.`pac` AS `pac`,
`edi`.`item_track`.`cat` AS `cat`,
`edi`.`item_track`.`ori` AS `ori`,
`edi`.`item_track`.`pro` AS `pro`,
`edi`.`item_track`.`sub` AS `sub`,
`edi`.`item_track`.`package` AS `package`,
`edi`.`item_track`.`item` AS `item`
FROM `edi`.`item_track`