IN_VMI_SRCBU_VW

(SQL View)
 Index Back

Item/Non VMI IN BU Prompt Tbl

Created as prompt table for IN BU's for the specific item id - will return only non-vmi bu's

SELECT A.INV_ITEM_ID , A.BUSINESS_UNIT , B.DESCR FROM PS_ALLBU_ITEM_VW A , PS_SP_BUNVM_NONVW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

  • Related Language Record: IN_VMI_SRCBULVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description