BU_ITM_INV_LVW

(SQL View)
 Index Back

Item Business Unit Prompt View

BU item related language promt view that will bring back all Items with status of Active, Hold, Discontinue, and Inactive

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , E.language_cd , E.DESCR FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , ps_master_itm_lang e WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND e.setid = b.setid AND e.setid = c.setid AND A.INV_ITEM_ID = B.INV_ITEM_ID AND a.inv_item_id = e.inv_item_id AND A.INVENTORY_ITEM = 'Y' AND A.ITM_STATUS_CURRENT IN ('1','2','3','4')

  • Related Language Record for BU_ITM_INACT_VW BU_ITM_INV_VW BU_ITM_INV_VW11 BU_ITM_INV_VW9 BU_ITM_IN_VW MIN_BU_ITEM_VW MIN_BU_ITM_VW MIN_ITM_INV_VW

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUIN_NONVW

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

    Prompt Table: BU_ITM_INV_VW

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