PL_BW_SCHPO_VW

(SQL View)
 Index Back

Sched PO - Buyer WB

Scheduled PO for Buyer WB

SELECT P.PROBINST , M.BUSINESS_UNIT_IN , M.INV_ITEM_ID , M.CONFIG_CODE , P.VENDOR_SETID , P.VENDOR_ID , P.VNDR_LOC , %Dttm(%DatePart(M.PLAN_DUE_DTTM) , %TimeIn('00.00.00.000000')) , SUM(M.QTY_PO_STD) FROM PS_PL_PO_HDR P , PS_PL_PO_DISTRIB M WHERE P.PROBINST = M.PROBINST AND P.PO_ID = M.PO_ID AND P.BUSINESS_UNIT = M.BUSINESS_UNIT AND P.PO_STATUS <> 'X' GROUP BY P.PROBINST , M.BUSINESS_UNIT_IN , M.INV_ITEM_ID , M.CONFIG_CODE , P.VENDOR_SETID , P.VENDOR_ID , P.VNDR_LOC , M.PLAN_DUE_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE2

4 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: %EDITTABLE5

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 DUE_DTTM DateTime(26) TIMESTAMP Due Datetime
9 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity