ITM_NOBU_GRP_VW

(SQL View)
 Index Back

Select Item prompt for filter

08/21/02 SCC CN#WV880-1.0: Supplier Collaboration

SELECT DISTINCT A.SETID , A.SCHED_GROUP_CD , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.INV_ITEM_ID , B.DESCR FROM PS_ITM_VND_BU_ATTR A , PS_MASTER_ITEM_TBL B WHERE A.SCHED_GROUP_CD > ' ' AND A.SETID=B.SETID AND A.INV_ITEM_ID=B.INV_ITEM_ID

  • Related Language Record: ITM_NOBU_GRPLVW

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

    Prompt Table: SP_SETID_NONVW

    2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
    3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_VNDSET_VW

    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_VW1

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

    Prompt Table: VENDOR_ITM_VW

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description