PO_EXDT_POIT_VW (SQL View)	Index Back
Sum of PO/by item cel 05/01/2002 Sum of purchase orders by item .. ...by DATE, that are within a capacity range .. used to be able to find the specific date that capacity exceeded. (used to populate po_cap_excd_tmp and then looped through).

PO_EXDT_POIT_VW

(SQL View)

Sum of PO/by item

cel 05/01/2002 Sum of purchase orders by item .. ...by DATE, that are within a capacity range .. used to be able to find the specific date that capacity exceeded. (used to populate po_cap_excd_tmp and then looped through).

SELECT DISTINCT I.VENDOR_SETID , I.VENDOR_ID , I.VNDR_LOC , I.ITM_SETID , I.INV_ITEM_ID , I.BUSINESS_UNIT_IN , I.DUE_DT , SUM(I.QTY_PO) FROM PS_PO_BUY_POALL_VW I GROUP BY I.VENDOR_SETID , I.VENDOR_ID , I.VNDR_LOC , I.ITM_SETID , I.INV_ITEM_ID , I.BUSINESS_UNIT_IN , I.DUE_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

7 DUE_DATE Date(10) DATE Delivery Due Date from PO

8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
7	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
8	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity