PL_PO_PLAN2_VW

(SQL View)
Index Back

Planned Orders from Red Pepper

Used on Review Purchasing messages ... excludes any items that are also csm supplier sched items.

SELECT A.BUSINESS_UNIT_IN , A.SEQ_NBR , A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.APPROVED_FLG , A.PROCESSED_FLG , A.PROBINST , A.PL_SEQ_NBR , A.PLANNER_CD , A.PLANNING_TIMESTAMP , A.CANCEL_CHNG_FLG , A.SCHED_CHNG_FLG , A.RELEASE_DATE , A.RELEASE_TIME , A.DUE_DT , A.DUE_TIME , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PL_PO_LEAD_TIME , A.INV_ITEM_ID , A.SETID , A.QTY_PO , A.PROCESS_INSTANCE , A.TOLERANCE_FLG , A.PL_STATUS_CD , A.PLAN_FROZEN_FLG , A.CONFIG_CODE , A.PL_PO_TYPE , A.CHNG_SOURCE , A.OVERRIDE_SUGG_VNDR , A.BUYER_ID , A.PL_PLAN_STATUS , A.CHANGE_FLAG FROM PS_PL_PO_PLAN_ORD A WHERE NOT EXISTS ( SELECT 'X' FROM PS_ITM_VND_BU_ATTR B WHERE B.SCHED_FLAG = 'Y' AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.VENDOR_ID = B.VENDOR_ID AND A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT_IN AND A.SETID = B.SETID AND A.VENDOR_SETID = B.VENDOR_SETID AND A.VNDR_LOC = B.VNDR_LOC)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

Y/N Table Edit

Default Value: N

8 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

Y/N Table Edit

Default Value: N

9 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
10 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
11 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
12 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Planning Date and Time
13 CANCEL_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Canceled
14 SCHED_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Schedule Change
15 RELEASE_DATE Date(10) DATE Release Date
16 RELEASE_TIME Time(15) TIMESTAMP Release Time
17 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
18 DUE_TIME Time(15) TIMESTAMP Due Time
19 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
20 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
21 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
22 PL_PO_LEAD_TIME Number(10,0) DECIMAL(10) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
23 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
24 SETID Character(5) VARCHAR2(5) NOT NULL SetID
25 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
27 TOLERANCE_FLG Character(1) VARCHAR2(1) NOT NULL jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label
28 PL_STATUS_CD Character(2) VARCHAR2(2) NOT NULL 08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
10=Expedite
20=Accepted Horizon
30=After Cutoff Fence
40=No Time Fence Defined
99=Error/Exception
29 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
30 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
31 PL_PO_TYPE Character(1) VARCHAR2(1) NOT NULL Purchase Order Type
E=Existing Orders
N=Planned Order
32 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
33 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

Y/N Table Edit

34 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
35 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
36 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No indicator

Y/N Table Edit

Default Value: Y