CP_PRDITMVW_LNG

(SQL View)
 Index Back

CP Ref Items for Mfg Config RL

View of BU_ITEMS_INV, MASTER_ITM_LANG

SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , L.LANGUAGE_CD , L.DESCR60 FROM PS_BU_ITEMS_INV B , PS_MASTER_ITM_LANG L WHERE B.INV_ITEM_ID = L.INV_ITEM_ID AND L.SETID = ( SELECT SC.SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = B.BUSINESS_UNIT AND SC.RECNAME = 'MASTER_ITEM_TBL')

  • Related Language Record for CP_PRDNITEM_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 REF_BOM_ITEM Character(18) VARCHAR2(18) NOT NULL Reference BOM Item
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description