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

ATP_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 , po_dist_line_num , recv_ds_status , 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, po_dist_line_num, recv_ds_status

# 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 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number

6 RECV_DS_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Closed
H=Hold
M=Moved
O=Open
R=Received
X=Cancelled

7 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	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
6	RECV_DS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Closed H=Hold M=Moved O=Open R=Received X=Cancelled
7	QTY_DS_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Distributed Quantity