RQMAIN2VW_LANG

(SQL View)
 Index Back

Program Req Ignoring Effdt

This view of the Requirement Line table is used to select reqirement Usage ignoring effective date so that the current description displays.

SELECT A.REQUIREMENT , A.LANGUAGE_CD , A.DESCR , B.XLATLONGNAME FROM PS_RQ_MAIN_LANG A , PSXLATITEMLANG B , PS_RQ_MAIN_TBL C WHERE A.REQUIREMENT = C.REQUIREMENT AND A.EFFDT = C.EFFDT AND B.FIELDNAME = 'RQRMNT_USEAGE' AND B.LANGUAGE_CD = A.LANGUAGE_CD AND B.FIELDVALUE = C.RQRMNT_USEAGE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEMLANG B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE AND B1.LANGUAGE_CD = B.LANGUAGE_CD AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record for RQ_MAIN_2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_MAIN_RQ Character(9) VARCHAR2(9) NOT NULL Reference Main Requirement
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr