SPF_BID_HST_LVW

(SQL View)
 Index Back

Bid History language view


SELECT A.BUSINESS_UNIT , A.BID_ID , E.LANGUAGE_CD , E.NAME1 FROM PS_SPF_BID_HDR A , PS_SPB_PERSON_TBL C , PS_VENDOR_LANG E WHERE E.VENDOR_ID = A.VENDOR_ID AND E.SETID = A.VENDOR_SETID AND (C.PERSON_ID = A.SRVC_PROVIDER_ID OR (C.PERSON_ID = A.PROVIDER_CONTACT AND A.SRVC_PROVIDER_ID = ' '))

  • Related Language Record for SPF_BID_HST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_SP_NONVW

    2 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1