PV_REQLINEVW_RL

(SQL View)
 Index Back

Requisition Line Related Lang

Requisition Line Related Language Table

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , B.LANGUAGE_CD , B.DESCR254_MIXED FROM PS_REQ_LINE A , PS_PURCH_ITEM_LANG B WHERE A.ITM_SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID

  • Related Language Record for PV_REQ_LINE_VW PV_REQ_LINE_VW0 PV_REQ_LINE_VW2 PV_REQ_TMPLNVW2 PV_REQ_TMPL_VW PV_REQ_TMPL_VW2 PV_REQ_VNTM_VW2 PV_REQ_VTMP_VW PV_REQ_VTMP_VW2

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

    Default Value: NEXT

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description