PL_PODISTQTY_VW

(SQL View)
Index Back

SELECT PROBINST , BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , SUM(QTY_PO) FROM PS_PL_PO_DISTRIB GROUP BY PROBINST , BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity