BCT_ITM_SUB_VW

(SQL View)
 Index Back

Inv Item Prompt View

Prompt view used by bar code picking process

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.SUB_ITM_ID , A.SUB_PRIORITY_NBR , A.CONVERSION_RATE , C.DESCR FROM PS_BU_ITEM_SUB A , PS_BU_ITEMS_INV B , PS_MASTER_ITEM_TBL C , PS_SET_CNTRL_REC D 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

  • Related Language Record: BCT_ITM_SUB_LVW

    • # 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 SUB_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.
    5 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description