PL_RSCH_PUR_VW

(SQL View)
 Index Back

Rescheduled Purchases

11/18/02 JC (CN#PL880-1):Added 04/11/03 JC (ICE582988000): Removed Cancelled orders

SELECT A.PROBINST , A.BUSINESS_UNIT , A.INV_ITEM_ID , B.CFG_CODE_OPT , A.CONFIG_CODE , A.REMAINING_QTY , B.UNIT_MEASURE_STD , 0 , 0 , ' ' , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.CANCEL_STATUS , A.BUSINESS_UNIT_IN , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , A.PLAN_RELEASE_DTTM , A.DUE_DTTM , A.PLAN_DUE_DTTM , A.PEG_STATUS FROM PS_PL_PO_DISTRIB A , PS_PL_BU_ITEMS B , PS_PL_PO_HDR C WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INCL_QTY_FLG = 'Y' AND A.CANCEL_STATUS = 'A' AND A.DUE_DTTM <> A.PLAN_DUE_DTTM AND A.PROBINST = C.PROBINST AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE2

4 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes
5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
6 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
8 RESCHED_DAYS_IN Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
9 RESCHED_DAYS_OUT Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
10 DETAIL_BTN Character(1) VARCHAR2(1) NOT NULL Details
11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
12 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
13 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
14 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
15 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
16 PL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
17 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: PL_PI_VNDID_VW

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

Prompt Table: PL_PI_VNDLOC_VW

20 PLAN_RELEASE_DTTM DateTime(26) TIMESTAMP Plan Release Date Time
21 DUE_DTTM DateTime(26) TIMESTAMP Due Datetime
22 PLAN_DUE_DTTM DateTime(26) TIMESTAMP Planning Due Date/Time
23 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged