BCT_ITM_SUB_LVW

(SQL View)
 Index Back

Inv Item Prompt Language View

Prompt view used by bar code picking process

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.SUB_ITM_ID , E.LANGUAGE_CD , C.DESCR FROM PS_BU_ITEM_SUB A , PS_BU_ITEMS_INV B , PS_MASTER_ITEM_TBL C , PS_SET_CNTRL_REC D , PS_MASTER_ITM_LANG E WHERE B.ITM_STATUS_CURRENT IN ('1', '3') AND B.INVENTORY_ITEM = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.INV_ITEM_ID = A.SUB_ITM_ID AND A.EFFDT_FROM <= %CurrentDateIn AND A.EFFDT_TO >= %CurrentDateIn AND A.USE_FOR_SHIP_FLAG = 'Y' AND A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'MASTER_ITEM_TBL' AND C.SETID = D.SETID AND A.SUB_ITM_ID = C.INV_ITEM_ID AND E.SETID = C.SETID AND E.INV_ITEM_ID = E.INV_ITEM_ID

  • Related Language Record for BCT_ITM_SUB_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description