RFND_ORGHDR_VW2

(SQL View)
 Index Back

Refund approval view

Select refund_hdr rows of data that require a refund approval

SELECT a.business_unit , a.refund_nbr , a.ext_org_id , b.descr , a.refund_amt , a.ref_appr_opr_1 , a.ref_appr_opr_2 , a.ref_appr_opr_3 , a.ref_appr_sw_1 , a.ref_appr_sw_2 , a.ref_appr_sw_3 FROM ps_refund_hdr a , PS_EXT_ORG_TBL 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_TBL c WHERE b.ext_org_id = c.ext_org_id AND b.effdt <= %CurrentDateIn)

  • Related Language Record: RFNORGHDRVW2LNG

    • # 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 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 REFUND_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Refund Amount
    6 REF_APPR_OPR_1 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 1
    7 REF_APPR_OPR_2 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 2
    8 REF_APPR_OPR_3 Character(30) VARCHAR2(30) NOT NULL Approval OPRID 3
    9 REF_APPR_SW_1 Character(1) VARCHAR2(1) NOT NULL Approval Switch 1
    A=Refund Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval
    10 REF_APPR_SW_2 Character(1) VARCHAR2(1) NOT NULL Approval Switch 2
    A=Refund Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval
    11 REF_APPR_SW_3 Character(1) VARCHAR2(1) NOT NULL Approval Switch 3
    A=Approved
    D=Refund Denied
    N=No Approval Required
    P=Pending Approval