ATP2_RECVQTY_VW (SQL View)	Index Back
ATP Receipt Quantity View View used to gather receipt quantity for purchase orders.

ATP2_RECVQTY_VW

(SQL View)

ATP Receipt Quantity View

View used to gather receipt quantity for purchase orders.

SELECT business_unit_po , po_id , line_nbr , sched_nbr , SUM(qty_ds_accpt_suom) FROM PS_RECV_LN_DISTRIB WHERE dst_acct_type = 'DST' AND recv_ds_status <> 'X' GROUP BY business_unit_po, po_id, line_nbr, sched_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 QTY_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Quantity

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