PL_MSG_INV_VW

(SQL View)
 Index Back

Inv Message Item

08/29/02 EGS (CN#PL880-1): Added.

SELECT DISTINCT A.INV_ITEM_ID , C.DESCR FROM PS_DEM_CHG_INF_INV A , PS_MASTER_ITEM_TBL C , PS_SET_CNTRL_REC D WHERE C.SETID = D.SETID AND D.RECNAME = 'MASTER_ITEM_TBL' AND C.INV_ITEM_ID = A.INV_ITEM_ID

  • Related Language Record: PL_MSG_INV_LVW

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