RFNORGHDRVW2LNG

(SQL View)
 Index Back

Refund approval view

RFNORGHDRVW2LNG is the related language recordfor the record RFND_ORGHDR_VW2

SELECT a.business_unit , a.refund_nbr ,b.language_cd , b.descr FROM PS_REFUND_HDR a , ps_ext_org_lang b WHERE a.ext_org_id <> ' ' AND a.ext_org_id = b.ext_org_id AND a.ref_appr_active_sw = 'Y' AND (a.ref_appr_sw_1 = 'P' OR a.ref_appr_sw_2 = 'P' OR a.ref_appr_sw_3 = 'P') AND a.refund_status IN ('P' , 'C') AND b.effdt = ( SELECT MAX(c.effdt) FROM ps_ext_org_lang c WHERE b.ext_org_id = c.ext_org_id AND b.effdt <= %CurrentDateIn)

  • Related Language Record for RFND_ORGHDR_VW2

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description