CREATE VIEW "PMX_WMS_INSPECT_CHANGE_QS" ( 
	 "U_DocNum",
	 "ItemCode",
	 "Quantity",
	 "QuantityUom2",
	 "ItemTransactionalInfoKey",
	 "BatchNumber",
	 "LogUnitIdentKey",
	 "SSCC",
	 "QualityStatusCode",
	 "StorLocCode",
	 "ResoCode",
	 "ReportCode",
	 "PrinterCode",
	 "NbCopies" ) 
AS SELECT
	 INSPECT."U_DocNum",
	 PMX_INVT."ItemCode",
	 PMX_INVT."Quantity",
	 PMX_INVT."QuantityUom2",
	 PMX_INVT."ItemTransactionalInfoKey",
	 PMX_ITRI."BatchNumber",
	 PMX_INVT."LogUnitIdentKey",
	 PMX_INVT."SSCC",
	 PMX_INVT."QualityStatusCode" ,
	 PMX_INVT."StorLocCode",
	 INSPECT."Code" AS "ResoCode",
	 PMX_RPRT."InternalKey" AS "ReportCode",
	 PMX_OSPR."Code" AS "PrinterCode",
	 TO_INT('1') AS "NbCopies" 
FROM PMX_RPRT,
	PMX_OSPR,
	"@BOY_CLOUD_INSP_RESO" INSPECT
	INNER JOIN OBTN ON INSPECT."U_ItemCode" = OBTN."ItemCode" AND INSPECT."U_Batch" = OBTN."DistNumber" AND INSPECT."U_Batch" = OBTN."DistNumber" 
	INNER JOIN PMX_ITRI ON PMX_ITRI."ItemCode" = OBTN."ItemCode" AND PMX_ITRI."BatchNumber" = OBTN."DistNumber" 
	INNER JOIN PMX_INVD ON PMX_INVD."TransType" = INSPECT."U_ErpDocType" AND PMX_INVD."DocEntry" = INSPECT."U_ErpDocEntry" AND PMX_INVD."DocLineNum" = INSPECT."U_ErpDocLine" 
	AND PMX_INVD."ItemCode" = INSPECT."U_ItemCode" AND PMX_INVD."ItemTransactionalInfoKey" = PMX_ITRI."InternalKey"
	INNER JOIN PMX_INVT ON PMX_INVT."LogUnitIdentKey" = PMX_INVD."LogUnitIdentKey" 
WHERE 1=1 
AND INSPECT."U_Result" = '30' --Only when Inspection Order Result = PASSED
AND PMX_INVD."TransType" in ('20', '59') --Only for Goods Receipt PO and Receipt From Production
AND PMX_INVT."QualityStatusCode" = 'QUARANTI' --Only when actual Quality Status = QUARANTINE
AND PMX_RPRT."Path" = 'DefaultInspectionCertificate.rpt' --Define condition to select the right report
AND PMX_OSPR."WindowsPrinterName" = 'Bullzip PDF Printer' WITH READ ONLY