EX_AWESTGVW_LNG

(SQL View)
 Index Back

Approval Stage Language View

Language Table for EX_AWE_STAGE_VW used in Tranaction Definition Page.

SELECT A.SETID , A.EOAWPRCS_ID , A.EFFDT , A.STAGE_ID , B.LANGUAGE_CD , B.DESCR FROM PS_EX_AWE_STAGE_VW A , PS_EX_STGTMPLNG_VW B WHERE A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.STAGE_ID = B.SEQ_NBR AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EX_AWE_STAGE_VW A1 WHERE A.EOAWPRCS_ID = A1.EOAWPRCS_ID AND A.STAGE_ID = A1.STAGE_ID AND A1.EFFDT <= %CurrentDateIn) AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_EX_STGTMPLNG_VW B1 WHERE B.EOAWPRCS_ID = B1.EOAWPRCS_ID AND B.SEQ_NBR = B1.SEQ_NBR AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record for EX_AWE_STAGE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 STAGE_ID Number(15,0) DECIMAL(15) NOT NULL Unique stage identifier
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description