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

14 lines
436 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`awb_component`
AS SELECT `ac`.`id` AS `id`,
`ac`.`awbFk` AS `awb_id`,
`ac`.`supplierFk` AS `Id_Proveedor`,
`ac`.`typeFk` AS `awb_component_type_id`,
`ac`.`awbRoleFk` AS `awb_role_id`,
`ac`.`awbUnitFk` AS `awb_unit_id`,
`ac`.`value` AS `value`,
`ac`.`currencyFk` AS `Id_Moneda`,
`ac`.`invoiceInFk` AS `recibida_id`
FROM
`vn`.`awbComponent` `ac`;