PL_PO_PLAN2_VW(SQL View) |
Index Back |
---|---|
Planned Orders from Red PepperUsed 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 |