PO_COLL_PP_VW

(SQL View)
 Index Back

Live and Collab data match

02/04/02 SCC CN#WV840-1.0: Supplier Collaboration - View used for applying post collab data.

SELECT A.BUSINESS_UNIT_IN ,A.SEQ_NBR_PARENT ,B.QTY_PO ,B.DUE_DT ,B.DUE_TIME ,B.APPROVED_FLG ,B.PLAN_FROZEN_FLG ,B.PL_PLAN_STATUS ,B.PL_PO_LEAD_TIME ,G.SRC_METHOD ,G.PRIMARY_BUYER ,B.CHANGE_FLAG ,A.DATETIME_CREATE ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.ITM_SETID ,A.INV_ITEM_ID ,A.CONFIG_CODE ,A.COLLAB_SCH_STATUS ,A.DUE_DT ,A.DUE_TIME ,A.DST_ACCT_TYPE ,A.ORIG_SCHED_DATE ,A.ORIG_SCHED_TIME ,A.ORDER_SOURCE ,A.BUYER_ID ,A.REVISION ,A.FROZEN_FLG ,A.PO_STATUS ,A.SCHEDULE_START_DT ,A.SCHEDULE_END_DT ,A.DATETIME_DISPATCH ,A.DATETIME_COLLAB ,A.DATETIME_MODIFIED ,A.OPRID ,A.YES_INDICATOR ,A.CATEGORY_CD ,A.EXIST_PO ,A.EXIST_PP ,A.UNIT_MEASURE_STD ,A.CURRENT_QTY ,A.COLLAB_TEMPQTY ,A.CONFIRM_QTY ,A.UNIT_MEASURE_ORD ,A.CURRENT_QTY_ORD ,A.COLLAB_TEMPQTY_ORD ,A.CONFIRM_QTY_ORD ,A.UNIT_MEASURE_VNDR ,A.CURRENT_QTY_VND ,A.COLLAB_TEMPQTY_VND ,A.CONFIRM_QTY_VND ,A.SCHED_GROUP_CD ,B.BUSINESS_UNIT ,B.PO_ID ,B.LINE_NBR ,B.SCHED_NBR FROM PS_PO_COLL_SCH_DET A , PS_PL_PO_PLAN_ORD B , PS_MASTER_ITEM_TBL F , PS_ITM_CAT_SET_VW G , PS_INSTALLATION_PO H WHERE A.BUSINESS_UNIT_IN=B.BUSINESS_UNIT_IN AND A.SEQ_NBR_PARENT=B.SEQ_NBR AND A.ITM_SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.COLLAB_SCH_STATUS='30' AND A.EXIST_PP=1 AND B.PL_PO_TYPE = 'N' AND (B.PROCESSED_FLG = 'N' OR (B.PL_PLAN_STATUS = '90' AND B.QTY_PO = 0)) AND F.SETID = A.ITM_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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

2 SEQ_NBR_PARENT Number(15,0) DECIMAL(15) NOT NULL Sequence Number - Parent Item
3 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
4 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.
5 DUE_TIME Time(15) TIMESTAMP Due Time
6 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
7 FROZEN_CD Character(1) VARCHAR2(1) NOT NULL Frozen code
1=Change from unfrozen to frozen
2=Change from frozen to unfrozen
3=No Change
8 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
9 PL_PO_LEAD_TIME Number(10,0) DECIMAL(10) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
10 SRC_METHOD Character(1) VARCHAR2(1) NOT NULL Sourcing Method
B=Basic
F=Flexible
H=Cumulative Split
S=Sched Split
11 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer
12 CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No indicator
13 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
14 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
19 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW2

20 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
21 DUE_DATE Date(10) DATE Delivery Due Date from PO
22 DUE_DATE_TIME Time(15) TIMESTAMP Due Date Time
23 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
24 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
25 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
26 ORDER_SOURCE Character(2) VARCHAR2(2) NOT NULL 02/2001 cel WV-802-1.0
10=Existing Purchase Order
20=Planned Purchase Order
27 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
28 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
29 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

30 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
31 SCHEDULE_START_DT Date(10) DATE 02/2001 cel WV-802-1.0
32 SCHEDULE_END_DT Date(10) DATE 02/2001 cel WV-802-1.0
33 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
34 DATETIME_COLLAB DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
35 DATETIME_MODIFIED DateTime(26) TIMESTAMP Datetime Modified
36 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
37 YES_INDICATOR Number(1,0) SMALLINT NOT NULL Yes Indicator for PO Lookup
38 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
39 EXIST_PO Number(1,0) SMALLINT NOT NULL 02/20/01 SCC CN#WV802-1.0: New Field
40 EXIST_PP Number(1,0) SMALLINT NOT NULL 02/20/01 SCC CN#WV802-1.0: New Field
41 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
42 CURRENT_QTY 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 std uom)
43 COLLAB_TEMPQTY Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in std uom)
44 CONFIRM_QTY Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in std uom)
45 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
46 CURRENT_QTY_ORD 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 ordering uom)
47 COLLAB_TEMPQTY_ORD Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in the ordering uom)
48 CONFIRM_QTY_ORD Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in ordering uom)
49 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
50 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
51 COLLAB_TEMPQTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in vendor's default uom)
52 CONFIRM_QTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in vendor's default uom)
53 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
54 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
55 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
56 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
57 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number