PL_USEUP_VW

(SQL View)
 Index Back

Planning Useup View

11/03/02 JC (CN#PL880-1): Added CONFIG_CODE, PROBINST

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , B.DESCR , B.SETID , A.PL_PROJ_USE_DT , A.PL_PROJ_USE_QOH , A.PROBINST , A.PLANNING_TIMESTAMP , D.PL_PROJ_USE_DT , E.QTY_AVAILABLE , B.UNIT_MEASURE_STD FROM PS_PL_USEUP_ITEMS A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_PL_ITEM_ATTRIB D , PS_BU_ITEMS_INV E WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.INV_ITEM_ID = A.INV_ITEM_ID AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.INV_ITEM_ID = A.INV_ITEM_ID

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

Prompt Table: PL_USE_BU_IN_VW

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

Prompt Table: PL_USE_BUITM_VW

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

Prompt Table: PL_US_BITMCG_VW

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 PL_PROJ_USE_DT Date(10) DATE 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
7 PL_PROJ_USE_QOH Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/03/02 JC (CN#PL880-1): Added QOH_USEUP label 12/18/02 EGS (CN#PL880-1): Changed to 11.4.
8 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
9 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP Planning Date/Time
10 PHASE_OUT_DT Date(10) DATE 11/03/02 JC (CN#PL880-1): Added
11 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
12 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure