IN_PPOV_ATP_VW

(SQL View)
 Index Back

Planned Purchases w/ Suppliers

02/01/04 EGS: Created

SELECT A.BUSINESS_UNIT_IN , A.INV_ITEM_ID , 'PPO' , 'S' , 'PL' , A.DUE_DT , A.QTY_PO , B.VENDOR_NAME_SHORT , A.APPROVED_FLG , A.PL_PLAN_STATUS , A.PLAN_FROZEN_FLG FROM PS_PL_PO_PLAN_ORD A , PS_VENDOR B WHERE A.PL_PO_TYPE = 'N' AND A.PL_PLAN_STATUS <> '90' AND A.PROCESSED_FLG <> 'C' AND A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 ATP_SOURCE Character(6) VARCHAR2(6) NOT NULL This field is used in the ATP and Availability calculation to determine where the particular source or demand was fetched from. It will store the up-to-6 character mnemonic used in the associated view that fetched the data. For example, if ATP_S_PO_VW was used to fetch purchase order information, this field will contain "PO". If view ATP_D_PROMIS_VW was used to fetch promised demand information, this field will contain "PROMIS".
4 AVAIL_TYPE Character(1) VARCHAR2(1) NOT NULL Availability Type
D=Demand
S=Supply
5 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
6 SCHED_DATE Date(10) DATE Schedule Date
7 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
8 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
9 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
10 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled
11 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes