ITEMXREFCHVWLNG

(SQL View)
 Index Back

Item XREF Charge View

ITEMXREFCHVWLNG is the related language recordfor the record ITEM_XREF_CH_VW

SELECT a.business_unit ,b.item_nbr_charge ,i.language_cd ,i.descr ,d.descrshort FROM ps_item_sf a ,ps_item_xref b ,PS_TERM_VAL_LANG d ,ps_bus_unit_tbl_sf e ,PS_ITEM_TYPE_TBL f ,ps_item_type_lng i WHERE f.setid=i.setid AND f.item_type=i.item_type AND f.effdt=i.effdt AND a.business_unit=b.business_unit AND A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND a.item_nbr=b.item_nbr_charge AND a.item_term=d.strm AND a.business_unit=e.business_unit AND a.item_type=f.item_type AND f.effdt=( SELECT MAX(g.effdt) FROM PS_ITEM_TYPE_TBL g WHERE f.setid=g.setid AND f.item_type=g.item_type AND f.effdt <= %CurrentDateIn AND f.eff_status='A' ) AND f.setid=( SELECT h.setid FROM ps_set_cntrl_rec h WHERE h.setcntrlvalue=e.institution AND h.recname='ITEM_TYPE_TBL')

  • Related Language Record for ITEM_XREF_CH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description