RFQ_RP_ER_VW3LN

(SQL View)
 Index Back

RFQ Response Error Supplier Vi


SELECT DISTINCT a.business_unit , a.vendor_id , b.language_cd , b.name1 FROM ps_rfq_resp_hdr_ec a , PS_VENDOR_LANG b , ps_set_cntrl_rec c WHERE a.po_edi_status = 'E' AND a.business_unit = c.setcntrlvalue AND c.recname = 'VENDOR'and c.setid = b.setid AND a.vendor_id = b.vendor_id

  • Related Language Record for RFQ_RESP_ER_VW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1