PO_ITM_CT_LG_VW

(SQL View)
 Index Back

PO Item Contract View

06/25/2008 PKL F-AHAYT-S60K7 Contract Enhancements

SELECT DISTINCT c.setid , b.cntrct_id , b.version_nbr , b.inv_item_id , a.business_unit , a.po_id , b.line_nbr ,d.language_cd ,d.descr60 FROM ps_po_line b , ps_po_hdr a , ps_set_cntrl_rec c , PS_PO_LINE_SHIP S ,PS_MASTER_ITM_LANG d WHERE c.recname = 'CNTRCT_HDR' AND c.setcntrlvalue = a.business_unit AND a.business_unit = b.business_unit AND a.po_id = b.po_id AND a.po_status <> 'X' AND a.po_status <> 'PX' AND a.business_unit = s.business_unit AND a.po_id = s.po_id AND b.line_nbr = S.line_nbr AND c.setid = d.setid AND b.inv_item_id = d.inv_item_id GROUP BY c.setid , b.cntrct_id , b.version_nbr,b.inv_item_id , a.business_unit , a.po_id , a.currency_cd , b.line_nbr , d.descr60,d.language_cd , a.po_status , b.cancel_status, b.cntrct_line_nbr , b.cat_line_nbr , b.category_id

  • Related Language Record for PO_ITM_CNTR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description