REFUNDTLEXVWLNG

(SQL View)
 Index Back

Refund Detail Extra View

REFUNDTLEXVWLNG is the related language recordfor the record REFUND_DTLEX_VW

SELECT a.business_unit , a.refund_nbr , a.line_seq_nbr ,g.language_cd , g.descr FROM ps_refund_dtl a , ps_refund_hdr b , PS_ITEM_TYPE_TBL c ,ps_item_type_lng g , ps_bus_unit_tbl_sf d WHERE c.setid = g.setid AND c.item_type=g.item_type AND c.effdt=g.effdt AND a.business_unit = b.business_unit AND a.refund_nbr = b.refund_nbr AND a.business_unit = d.business_unit AND a.item_nbr = '000000000000000' 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 g WHERE c.setid = g.setid AND c.item_type=g.item_type AND c.effdt=g.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_DTLEX_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