BU_ITM_INV_LVW5

(SQL View)
 Index Back

Item Business Unit Prompt View

BU item related language promt view that will bring back all non-soft reservation Items

SELECT MIT.SETID , DI.BUSINESS_UNIT , MIT.INV_ITEM_ID , E.language_cd , E.DESCR FROM PS_MASTER_ITEM_TBL MIT , PS_BU_ITM_INV_VW5 DI , ps_master_itm_lang e WHERE e.setid = MIT.setid AND MIT.inv_item_id = e.inv_item_id AND DI.INV_ITEM_ID = MIT.INV_ITEM_ID

  • Related Language Record for BU_ITM_INV_VW5

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUIN_NONVW

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

    Prompt Table: BU_ITM_INV_VW2

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description