PO_FLX_BSGRP_VW

(SQL View)
Index Back

flex by group

cel. 5/06/2002 Used on Schedule WB -- to bring up flex details by capacity group. This will bring up baseline for the schedule (status = 30) -- last approved schedule. (Used in new mode, since last schedule is actually still the one in approved mode until next one is built)

SELECT a.oprid , a.vendor_setid , a.vendor_id , a.vndr_loc , a.itm_setid , a.inv_item_id , a.sched_group_cd , a.business_unit_in , a.start_dt , B.DUE_DT , a.end_date , a.po_buy_flex_type , 'BS' , %subrec(PO_FLEX_SBR,A) , %subrec(PO_CAP_FLEX_SBR,A) , 0 , 0 , SUM(B.CONFIRM_QTY) , SUM(B.CONFIRM_QTY_VND) FROM PS_PO_FLEX_SUM_VW A ,PS_PO_COLL_SCH_DET B WHERE A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ITM_SETID = B.ITM_SETID AND A.VNDR_LOC = B.VNDR_LOC AND A.SCHED_GROUP_CD = B.SCHED_GROUP_CD AND B.DUE_DT >= A.START_DT AND B.DUE_DT <= A.END_DATE AND B.COLLAB_SCH_STATUS = '30' GROUP BY A.OPRID, A.VENDOR_SETID,A.VENDOR_ID, A.VNDR_LOC, A.ITM_SETID, A.INV_ITEM_ID, A.SCHED_GROUP_CD, A.BUSINESS_UNIT_IN, A.START_DT, B.DUE_DT, A.END_DATE, A.PO_BUY_FLEX_TYPE, %subrec(PO_FLEX_SBR,A) , %subrec(PO_CAP_FLEX_SBR,A)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
5 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
9 START_DT Date(10) DATE Start Date
10 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.
11 END_DATE Date(10) DATE End Date
12 PO_BUY_FLEX_TYPE Character(2) VARCHAR2(2) NOT NULL Flex Period
FM=Firmed
FX=Fixed
13 ROW_TYPE Character(2) VARCHAR2(2) NOT NULL 01/23/01 SCC CN#WV802-1.0: New Field
14 UPSIDE_FLG Character(1) VARCHAR2(1) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
15 UPSIDE_PCT Number(6,2) DECIMAL(5,2) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
16 DOWNSIDE_FLG Character(1) VARCHAR2(1) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
17 DOWNSIDE_PCT Number(6,2) DECIMAL(5,2) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
18 CHECK_BY Character(1) VARCHAR2(1) NOT NULL Period Defined by
D=Day
R=Entire Range
19 COLLAB_SCH_STATUS Character(2) VARCHAR2(2) NOT NULL 02/2001 cel WV-802-1.0 - Status of the supplier schedule
01=New
10=Current
20=Dispatched
30=Supplier Approved
40=Previous
50=History
20 DATETIME_COLLAB DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
21 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
22 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
23 SCHEDULE_START_DT Date(10) DATE 02/2001 cel WV-802-1.0
24 SCHEDULE_END_DT Date(10) DATE 02/2001 cel WV-802-1.0
25 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
26 DATETIME_APPLY DateTime(26) TIMESTAMP 08/27/01 SCC CN#WV840-1.0: Supplier Collaboration - New Field
27 INCLUDE_PO Character(1) VARCHAR2(1) NOT NULL Include PO Data
N=No
Y=Yes
28 DAYOFTHEWEEK Character(2) VARCHAR2(2) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
29 BUYER_ID_SEL Character(30) VARCHAR2(30) NOT NULL Buyer
30 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
31 CURRENT_QTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in vendor's default uom
32 QTY_BASELINE Number(16,4) DECIMAL(15,4) NOT NULL Baseline Qty
33 QTY_BASELINE_VND Number(16,4) DECIMAL(15,4) NOT NULL Baseline Qty