Bug 4301

Summary:	New Report develop
Product:	[01.IMIS] IMIS PRODUCTION	Reporter:	Mahender <mahender.singh>
Component:	IMIS PRODUCTION FORMS AND REPORTS	Assignee:	anushree.pandey
Status:	RESOLVED USER TO VERIFY
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	All
Database:		Module ID:

Comment 3 Mahender 2020-09-08 21:27:38 IST

PKG_PC.MATERIAL_REQUIRED(:CO)

Comment 2 anushree.pandey 2020-08-31 14:51:49 IST

New Report Developed.

Report No PPCR5207 - Material against pending Sale order

Comment 1 Mahender 2020-08-27 17:55:32 IST

USE PROCEDURE FOR DATA CREATION

PROCEDURE MATERIAL_REQUIRED 
	(P_COMPANY VARCHAR2)

Description Mahender 2020-08-27 17:48:10 IST

Please make new report as per below query column

SELECT COMPANY,ITEM_CODE,STOCK_TYPE,ITEM_QTY,STOCK_QTY,ITEM_STOCK_TYPE_NAME,(ITEM_QTY-NVL(STOCK_QTY,0) REQUIRED_QTY FROM TT$MATERIAL_REQURIED