SRM_DB_ODPO_ITS

(SQL View)
 Index Back

Item Id Search

ODPS

SELECT DISTINCT BUYER_ID , A.INV_ITEM_ID , B.DESCR60 FROM PS_SRM_DB_ODPO_VW2 A , PS_MASTER_ITEM_TBL B WHERE A.ITM_SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID

  • Parent record: SRM_DB_ODPO_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description