PL_AGG_DMD_ILVW

(SQL View)
Index Back

Demand Family Item View

03/23/97 SCC CN#EPNT083-FQ9NK: Add %substring to support all platofrms. 12/05/97 CN# PL750-DI-GPENN-64 New view for 7.5 to enter aggregate demand items and aggregate demand component items for forecast consumption in planning. 5/28/99 RT: Modified for Item Attribute Modifications

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , D.LANGUAGE_CD , D.DESCR FROM PS_SET_CNTRL_REC C , PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_MASTER_ITM_LANG D WHERE C.RECNAME = 'MASTER_ITEM_TBL' AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND B.SETID = C.SETID AND D.SETID = C.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID AND D.INV_ITEM_ID = A.INV_ITEM_ID AND( ( A.INVENTORY_ITEM = 'Y' OR (A.INVENTORY_ITEM = 'N' AND A.SOURCE_CODE = '6')) AND EXISTS ( SELECT 'X' FROM PS_BU_ITEMS_INV B , PS_PL_ITEM_ATTRIB D WHERE B.BUSINESS_UNIT = C.SETCNTRLVALUE AND B.INV_ITEM_ID = A.INV_ITEM_ID AND D.INV_ITEM_ID = A.INV_ITEM_ID AND D.BUSINESS_UNIT = C.SETCNTRLVALUE AND (B.SOURCE_CODE = '1' OR B.SOURCE_CODE = '2' OR B.SOURCE_CODE = '6' ) AND D.PLANNED_BY <> '4') OR ((A.INVENTORY_ITEM = 'N' AND A.NON_OWN_FLAG = 'N' AND A.CONSIGNED_FLAG <> 'Y') OR A.SOURCE_CODE = '6'))

  • Related Language Record for PL_AGG_DMD_ITVW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description