ITEMRFNDDOVWLNG

(SQL View)
 Index Back

RellngRef Update Org Item View

ITEMRFNDDOVWLNG is the related language recordfor the record ITEM_RFNDD_O_VW

SELECT A.BUSINESS_UNIT , A.EXT_ORG_ID ,E.LANGUAGE_CD ,E.DESCR FROM PS_REFUND_HDR A , PS_ITEM_SF B , PS_ITEM_TYPE_TBL C , PS_BUS_UNIT_TBL_SF D , PS_ITEM_TYPE_LNG E WHERE C.SETID=E.SETID AND C.ITEM_TYPE= E.ITEM_TYPE AND C.EFFDT=E.EFFDT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.COMMON_ID = A.EXT_ORG_ID AND B.ITEM_TYPE = A.ITEM_TYPE AND B.REFUND_NBR = A.REFUND_NBR AND B.ITEM_TYPE = C.ITEM_TYPE AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.SA_ID_TYPE = 'O' 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(EFFDT) FROM PS_ITEM_TYPE_TBL Y WHERE Y.SETID=C.SETID AND Y.ITEM_TYPE=C.ITEM_TYPE AND Y.EFFDT <= %CurrentDateIn AND Y.EFF_STATUS = 'A' ) GROUP BY A.BUSINESS_UNIT , A.EXT_ORG_ID , E.LANGUAGE_CD , E.DESCR

  • Related Language Record for ITEM_RFNDD_O_VW

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