SET QUOTED_IDENTIFIER OFF
GO

        CREATE VIEW [dbo].[al_purchase] AS
        SELECT DISTINCT    al_po.purchase_order_id AS purchase_id,
                        al_po.purchase_order_number AS po_number,                
                        al_po.ship_to_contact_uuid ship_to_contact_uuid,
                        al_po.billing_location_uuid AS ship_to_location_uuid,
                        al_po.reseller_uuid AS reseller_uuid,
                        al_po.version_number AS po_version_number,
                        al_inv.invoice_id AS invoice_id,
                        al_inv.invoice_date AS invoice_date,
                        al_inv.invoice_number AS invoice_number,
                        al_inv.version_number AS inv_version_number,
                        al_po_item.item_quantity AS purchase_quantity,
                        al_po_item.part_number AS part_number,
                        al_po_item.sku_number AS sku_number,
                        al_po_item.version_number AS version_number,
                        al_po_item.purchase_order_item_id AS purchase_order_item_id,
                        al_po_item.item_description AS purchase_description,
                        al_lnk_poitm_rsrc.owned_resource_uuid AS owned_resource_uuid,
                        al_lnk_poitm_rsrc.version_number AS lkpoitmrsc_version_number,
                        al_lic.license_id AS license_id,
                        al_po_flgs.from_uapm
         FROM al_purchase_order al_po
         INNER JOIN al_purchase_order_item al_po_item ON al_po_item.purchase_order_id = al_po.purchase_order_id
         INNER JOIN al_link_po_item_ownd_rsrc al_lnk_poitm_rsrc ON al_lnk_poitm_rsrc.purchase_order_item_id = al_po_item.purchase_order_item_id
         INNER JOIN ca_owned_resource ca_ownd_rsrc ON ca_ownd_rsrc.own_resource_uuid = al_lnk_poitm_rsrc.owned_resource_uuid
         INNER JOIN al_license al_lic ON al_lic.license_id = ca_ownd_rsrc.license_id
         INNER JOIN al_purchase_order_flags al_po_flgs ON al_po_flgs.purchase_order_id = al_po.purchase_order_id
         LEFT OUTER JOIN al_invoice al_inv ON al_inv.purchase_order_item_id = al_po_item.purchase_order_item_id
    
GO