RFNDORGHDRVWLNG

(SQL View)
 Index Back

Refund approval view

RFNDORGHDRVWLNGis the related language recordfor the record RFND_ORGHDR_VW

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 = 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' )

  • Related Language Record for RFND_ORGHDR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    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