Also required grand total ( material and inspected quantity )in a monthly report

Done


Please change name of the monthly report (QCMR0150) to Monthly packaging material
inspection report (QCMR0150).

Please change name of the monthly report to Monthly packaging material inspection report.

Done 

Kindly check & confirm.

Rights Given..

rights Given..

working...

DROP TABLE QUALITY_ITEM_MASTER;
CREATE TABLE QUALITY_ITEM_MASTER (ITEM_CODE 	VARCHAR2(30)
								 ,STOCK_TYPE	VARCHAR2(10)
								 ,DESCRIPTION 	VARCHAR2(250)
								 ,STATUS		VARCHAR2(1)
								 ,CREATED_BY	VARCHAR2(10)
								 ,CREATED_ON	DATE
								 ,LAST_UPD_BY	VARCHAR2(10)
								 ,LAST_UPD_ON	DATE,
CONSTRAINT QUALITY_PK PRIMARY KEY (ITEM_CODE,STOCK_TYPE));

DROP TABLE QUALITY_INSPECTION_PARAM;
CREATE TABLE QUALITY_INSPECTION_PARAM (ITEM_CODE 			VARCHAR2(20)
									  ,INSPECTION_CODE 		VARCHAR(20)
									  ,VISUAL_DESCRIPTION 	VARCHAR2(250)
									  ,SUPP_DESCRIPTION 	VARCHAR2(250)
									  ,STATUS				VARCHAR2(1)
								 	  ,CREATED_BY			VARCHAR2(10)
								 	  ,CREATED_ON			DATE
								 	  ,LAST_UPD_BY			VARCHAR2(10)
								 	  ,LAST_UPD_ON			DATE,
CONSTRAINT QUALITY_INSP_PARAM_PK PRIMARY KEY (ITEM_CODE,INSPECTION_CODE));

DROP TABLE QUALITY_INSPECTION;
CREATE TABLE QUALITY_INSPECTION(QUALITY_INSP_RECID	NUMBER(16) NOT NULL
								,DOCUMENT_DATE		DATE
								,DOCUMENT_TYPE		VARCHAR2(2)
								,DOCUMENT_SERIES	VARCHAR2(4)
								,DOCUMENT_NUMBER	NUMBER(9)
								,ENTRY_NUMBER		NUMBER(16)
								,ITEM_CODE			VARCHAR2(20)
								,SUPPLIER_CODE		VARCHAR2(20)
								,LOT_SIZE			NUMBER(6)
								,SAMPLE_SIZE		NUMBER(6)
								,BILL_NO			VARCHAR2(50)
								,BILL_DATE			DATE
								,STATUS				VARCHAR2(1)
								,CREATED_BY			VARCHAR2(10)
								,CREATED_ON			DATE
								,LAST_UPD_BY		VARCHAR2(10)
								,LAST_UPD_ON		DATE,
CONSTRAINT QUALITY_INSP_PK PRIMARY KEY (QUALITY_INSP_RECID));

DROP TABLE QUALITY_INSPECTION_TRANSACTION;
CREATE TABLE QUALITY_INSPECTION_TRANSACTION(QUALITY_INP_TRNS_RECID 	NUMBER(16) NOT NULL
											,QUALITY_INSP_RECID		NUMBER(16) NOT NULL
            			                    ,INSPECTION_CODE 		VARCHAR(20)
                        			        ,OBSERVATION			VARCHAR2(255)
                        			        ,REMARKS				VARCHAR2(255),
CONSTRAINT QUALITY_INSP_TRNS_PK PRIMARY KEY (QUALITY_INP_TRNS_RECID,QUALITY_INSP_RECID));

Created attachment 3235 [details]
qc report

sample report attached

Created attachment 3234 [details]
qc report

format of QC report attached for your reference