Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 11/6/2020 19:09:02 |
| Last Modified | 11/6/2020 19:09:02 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_production_in_detail_id | ||
| doc_from | ||
| receive_no | ||
| receive_date | ||
| doc_no | ||
| doc_date | ||
| quantity | ||
| quantity_sisa | ||
| uom | ||
| ms_item_id | ||
| is_sumber |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_part_list_supply_available
AS
SELECT
ms_production_in_detail_id
,ms_type_prosses_name AS doc_from
,doc_no AS receive_no
,doc_date AS receive_date
,doc_no
,doc_date
,quantity
,quantity_sisa
,uom
,ms_item_id
,0 AS is_sumber
from vw_ms_production_in_detail
where quantity_sisa>0 and status_id = 1
union all
select
ms_production_in_detail_id
,doc_from
,receive_no
,receive_date
,doc_no
,doc_date
,quantity
,quantity_sisa
,uom
,ms_item_id
,is_sumber
from vw_ms_production_in_detail_recycle
where quantity_sisa>0
GO
GO
CREATE VIEW dbo.vw_part_list_supply_available
AS
SELECT
ms_production_in_detail_id
,ms_type_prosses_name AS doc_from
,doc_no AS receive_no
,doc_date AS receive_date
,doc_no
,doc_date
,quantity
,quantity_sisa
,uom
,ms_item_id
,0 AS is_sumber
from vw_ms_production_in_detail
where quantity_sisa>0 and status_id = 1
union all
select
ms_production_in_detail_id
,doc_from
,receive_no
,receive_date
,doc_no
,doc_date
,quantity
,quantity_sisa
,uom
,ms_item_id
,is_sumber
from vw_ms_production_in_detail_recycle
where quantity_sisa>0
GO