Bug 4301 - New Report develop
Summary: New Report develop
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS PRODUCTION
Classification: 01.IMIS
Component: IMIS PRODUCTION FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: All All
: Normal normal
Assignee: anushree.pandey
URL:
Depends on:
Blocks:
 
Reported: 2020-08-27 17:48 IST by Mahender
Modified: 2020-09-08 21:27 IST (History)
0 users

See Also:
Database:
Module ID:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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