RECV_PO_SRCH_LN

(SQL View)
 Index Back

Receive Update Search


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , D.LANGUAGE_CD , D.NAME1 FROM PS_RECV_HDR A , PS_VENDOR B , PS_VENDOR_LANG D WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.SETID = D.SETID AND B.VENDOR_ID = D.VENDOR_ID

  • Related Language Record for RECV_AM_PO_SRCH RECV_DEL_UP_SCH RECV_INQ_SRCH RECV_PO_SRCH RECV_UPD_SRCH

    • # 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_PM.BUSINESS_UNIT_RECV

    Prompt Table: SP_BU_PM_NONVW

    2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Default Value: NEXT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1