PL_FCSTFILL_VW

(SQL View)
Index Back

View for the search on fcst

View for the search on forecast fulfillment information

SELECT DISTINCT A.PROBINST , B.INV_ITEM_ID , C.BU_GROUP , B.BUSINESS_UNIT , B.PLANNER_CD , B.INV_PROD_FAM_CD , B.CATEGORY_ID , B.PLANNED_BY , B.UNIT_MEASURE_STD , B.UTILIZ_CD , B.INV_ITEM_GROUP , B.BUYER_ID , B.SOURCE_CODE FROM PS_PL_FCST_CNS A , PS_PL_BU_ITEMS B , PS_PL_PROBINST C WHERE A.PROBINST = B.PROBINST AND A.PROBINST = C.PROBINST AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.INVENTORY_ITEM = 'Y'

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

Prompt Table: SP_PRBINS_NONVW

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

Prompt Table: %EDITTABLE2

3 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added

Prompt Table: PL_GROUP_IN_VW

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE

5 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PLANNER_TBL

6 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

Prompt Table: %EDITTABLE4

7 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
8 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: PL_PI_UTILIZ_VW

11 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: PL_PI_ITMGRP_VW

12 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer
13 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning