ITEMORGXREFVWLN

(SQL View)
 Index Back

RELLNG-Item XREF Charge View

ITEMORGXREFVWLN is the related language view for the record ITEM_ORGXREF_VW

SELECT a.business_unit ,a.common_id ,a.item_nbr ,F.LANGUAGE_CD ,f.descr ,d.descrshort FROM ps_item_sf a ,ps_item_xref b ,ps_term_val_tbl d ,ps_bus_unit_tbl_sf e ,PS_ITEM_TYPE_LNG f WHERE 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_term=d.strm AND a.business_unit=e.business_unit AND a.item_type=f.item_type AND a.sa_id_type = 'O' 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.setid=( SELECT h.setid FROM ps_set_cntrl_rec h WHERE h.setcntrlvalue=e.institution AND h.recname='ITEM_TYPE_TBL') AND b.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ITEM_XREF B1 WHERE b.BUSINESS_UNIT = B1.BUSINESS_UNIT AND b.COMMON_ID = B1.COMMON_ID AND B.SA_ID_TYPE = B1.SA_ID_TYPE AND b.ITEM_NBR_CHARGE = B1.ITEM_NBR_CHARGE AND b.ITEM_NBR_PAYMENT = B1.ITEM_NBR_PAYMENT AND B1.EFFDT <= %CurrentDateIn) AND b.EFF_STATUS = 'A'

  • Related Language Record for ITEM_ORGXREF_VW

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