PO_BUY_PLAN3_VW(SQL View) |
Index Back |
|---|---|
Plan'd Orders/Buyers WB/Apply02/04/02 SCC CN#WV840-1.0: Supplier Collaboration - View used for applying post collab data. This view is similar to po_buy_plan_vw except it excludes canceled planned purchase orders with 0 quantities. |
| SELECT A.BUSINESS_UNIT_IN , A.SEQ_NBR , A.PROBINST , A.PL_SEQ_NBR , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.SETID , A.INV_ITEM_ID , A.CONFIG_CODE , B.SCHED_GROUP_CD , A.DUE_DT , A.DUE_TIME , A.QTY_PO , A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , 1 , A.APPROVED_FLG , A.PROCESSED_FLG , A.TOLERANCE_FLG , A.SCHED_CHNG_FLG , A.CANCEL_CHNG_FLG , A.PLAN_FROZEN_FLG , A.CHANGE_FLAG , A.PL_STATUS_CD , A.PL_PLAN_STATUS , A.PL_PO_TYPE , A.OVERRIDE_SUGG_VNDR , A.BUYER_ID , A.PLANNER_CD , A.PL_PO_LEAD_TIME , G.CATEGORY_CD , G.SRC_METHOD , G.PRIMARY_BUYER , F.UNIT_MEASURE_STD , B.SCHED_FLAG FROM PS_PL_PO_PLAN_ORD A , PS_ITM_VND_BU_ATTR B , PS_MASTER_ITEM_TBL F , PS_ITM_CAT_SET_VW G , PS_INSTALLATION_PO H WHERE A.PL_PO_TYPE = 'N' AND A.PROCESSED_FLG = 'N' AND A.PL_PLAN_STATUS < '90' AND A.QTY_PO > 0 AND F.SETID = A.SETID AND F.INV_ITEM_ID=A.INV_ITEM_ID AND G.SETID = F.SETID AND G.CATEGORY_TYPE=H.CATEGORY_TYPE AND G.CATEGORY_ID=F.CATEGORY_ID AND A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VENDOR_SETID = B.VENDOR_SETID AND A.VNDR_LOC = B.VNDR_LOC AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT_IN |
| # | 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 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 4 | PL_SEQ_NBR | Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 8 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 10 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 11 | SCHED_GROUP_CD | Character(6) | VARCHAR2(6) NOT NULL | 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field |
| 12 | 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. |
| 13 | DUE_TIME | Time(15) | TIMESTAMP | Due Time |
| 14 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 16 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 17 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 18 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 19 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 20 | APPROVED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied N=Not Approved Y=Approved Y/N Table Edit |
| 21 | PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete E=Errors N=Initialize P=In Process |
| 22 | 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
Y/N Table Edit |
| 23 | SCHED_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Planning Schedule Change
Y/N Table Edit |
| 24 | CANCEL_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Planning Canceled
Y/N Table Edit |
| 25 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes |
| 26 | CHANGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Yes/No indicator |
| 27 | 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 |
| 28 | PL_PLAN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
05=Planned 15=Firmed 90=Canceled |
| 29 | PL_PO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Type
E=Existing Orders N=Planned Order |
| 30 | OVERRIDE_SUGG_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
Override Suggested Vendor
Y/N Table Edit Default Value: N |
| 31 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 32 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 33 | PL_PO_LEAD_TIME | Number(10,0) | DECIMAL(10) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 34 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 35 | SRC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Sourcing Method
B=Basic F=Flexible H=Cumulative Split S=Sched Split |
| 36 | PRIMARY_BUYER | Character(30) | VARCHAR2(30) NOT NULL | Primary Buyer |
| 37 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 38 | SCHED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Schedule Flag |