dbo.vw_ms_manual_invoice_file

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_manual_invoice_file
---XencX---with encryption
as 

SELECT        dt_ms_file.ms_file_id, dt_ms_file.file_type_id, dt_ms_file.file_name, dt_ms_file.file_url, dt_ms_file.create_date, user_create.username AS create_by, dt_ms_file_h_status.status_file_id, enum_ms_status_file.status_file_name, 
                         dt_ms_file_h_status.create_date AS status_date, user_status.username AS status_by
FROM            users AS user_create INNER JOIN
                         dt_ms_file ON user_create.id = dt_ms_file.create_by LEFT OUTER JOIN
                         enum_ms_status_file INNER JOIN
                         dt_ms_file_h_status ON enum_ms_status_file.status_file_id = dt_ms_file_h_status.status_file_id ON dt_ms_file.ms_file_h_status_id = dt_ms_file_h_status.ms_file_h_status_id LEFT OUTER JOIN
                         users AS user_status ON dt_ms_file_h_status.create_by = user_status.id
where not(dt_ms_file.file_type_id =1)
GO