RFNDORGDTLVWLNG

(SQL View)
 Index Back

Refund Detail View

RFNDORGDTLVWLNG is the related language recordfor the record RFND_ORG_DTL_VW

SELECT a.business_unit , b.common_id , a.refund_nbr , a.line_seq_nbr ,Z.LANGUAGE_CD , Z.descr FROM ps_refund_dtl a , ps_item_sf b , PS_ITEM_TYPE_TBL c , ps_bus_unit_tbl_sf d ,PS_ITEM_TYPE_LANG Z WHERE C.SETID=Z.SETID AND C.ITEM_TYPE=Z.ITEM_TYPE AND a.business_unit = b.business_unit AND a.item_nbr = b.item_nbr AND a.ext_org_id = b.common_id AND b.sa_id_type = 'O' AND a.business_unit = d.business_unit 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_LANG Z WHERE F.SETID=Z.SETID AND F.ITEM_TYPE=Z.ITEM_TYPE AND c.setid = f.setid AND c.item_type = f.item_type AND f.effdt <= %CurrentDateIn) AND c.eff_status = 'A'

  • Related Language Record for RFND_ORG_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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    3 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description