REFNDSRCH4VWLNG

(SQL View)
 Index Back

People Search View

REFNDSRCH4VWLNG is the related language recordfor the record REFUND_SRCH4_VW

SELECT A.BUSINESS_UNIT , A.REFUND_EXT_ORG_ID ,B.LANGUAGE_CD , B.DESCR FROM PS_ITEM_SF A , PS_EXT_ORG_VW2_LNG B WHERE A.REFUND_EXT_ORG_ID = B.EXT_ORG_ID AND A.REFUND_EXT_ORG_ID <> ' ' AND A.SA_ID_TYPE = 'P' AND A.ITEM_BALANCE < 0 GROUP BY A.BUSINESS_UNIT, A.REFUND_EXT_ORG_ID,B.LANGUAGE_CD, B.DESCR

  • Related Language Record for REFUND_SRCH4_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SSF_RFND_ORG_SPON Character(11) VARCHAR2(11) NOT NULL Sponsor Org ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description