PO_BUY_ITMPO_VW

(SQL View)
 Index Back

Purchased Items View

01/30/01 SCC CN#WV802-1.0: Supplier Collaboration - New View. Similar to ITM_PURCH_VW but item has to exist in ITM_VND_BU_ATTR

SELECT DISTINCT A.SETID ,A.INV_ITEM_ID ,A.DESCR ,A.DESCRSHORT ,A.DESCR254_MIXED FROM PS_ITM_PURCH_VW A , PS_ITM_VND_BU_ATTR B WHERE A.SETID=B.SETID AND A.INV_ITEM_ID=B.INV_ITEM_ID AND B.SCHED_FLAG = 'Y' AND B.SCHED_GROUP_CD = ' '

  • Related Language Record: PURCH_ITEM_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: MST_ITM_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description