REFUNDDTLVWLNG

(SQL View)
 Index Back

Refund Detail View

REFUNDDTLVWLNG is the related language recordfor the record REFUND_DTL_VW

SELECT a.business_unit , a.refund_nbr , a.line_seq_nbr ,i.language_cd , i.descr FROM ps_refund_dtl a , ps_item_sf b , PS_ITEM_TYPE_TBL c , ps_bus_unit_tbl_sf d , ps_refund_hdr g ,ps_item_type_lng i WHERE c.setid = i.setid AND c.item_type=i.item_type AND c.effdt=i.effdt AND a.business_unit = b.business_unit AND a.item_nbr = b.item_nbr AND a.emplid = b.common_id AND b.sa_id_type = 'P' AND a.business_unit = d.business_unit AND a.business_unit = g.business_unit AND a.refund_nbr = g.refund_nbr AND b.item_type = c.item_type AND c.setid = ( SELECT e.setid FROM ps_set_cntrl_rec e WHERE e.recname = 'ITEM_TYPE_TBL' AND e.setcntrlvalue = d.institution) AND c.effdt = ( SELECT MAX(f.effdt) FROM PS_ITEM_TYPE_TBL f , ps_item_type_lng i WHERE c.setid = i.setid AND c.item_type=i.item_type AND c.effdt=i.effdt AND c.setid = f.setid AND c.item_type = f.item_type AND f.effdt <= %CurrentDateIn AND f.eff_status = 'A')

  • Related Language Record for REFUND_DTL_VW

  • Parent record: REFUND_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    3 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description