PL_FCST_ITM_VW

(SQL View)
 Index Back

Forecast Item View

03/06/98 SCC CN#PL750-EP95022-BL9TR: Prompt table for item forecast. Does not allow configured items. 03/11/98 Lee: added related lang rec PL_FCST_ITM_LVW 05/28/99 RT : Modified for Item Attribute Modifications 12/30/99 EGS: Convert view to use business unit. 05/29/00 EGS: Remove Business Unit from Set Control Field.

SELECT a.business_unit , a.inv_item_id , b.descr60 , b.inventory_item , a.non_own_flag FROM PS_MASTER_ITEM_TBL b , ps_bu_items_inv a , ps_set_cntrl_rec c WHERE b.cfg_code_opt <> 'Y' AND a.business_unit = c.setcntrlvalue AND c.recname = 'MASTER_ITEM_TBL' AND b.setid = c.setid AND b.inv_item_id = a.inv_item_id AND a.source_code IN ('1', '2', '6') AND b.itm_status_current IN ('1','2','3') AND a.phantom_item_flag = 'N'

  • Related Language Record: PL_FCST_ITM_LVW

    • # 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
    N=No
    Y=Yes
    5 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
    N=No
    Y=Yes