SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW 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
LEFT OUTER JOIN al_invoice al_inv ON al_inv.purchase_order_id = al_po.purchase_order_id
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

GO