FORM_APPR_VW2_L

(SQL View)
 Index Back

Form Approval View

Form Approval View

SELECT A.OPRID , B.SEQ_NBR , L.LANGUAGE_CD , D.PORTAL_LABEL , L.FORM_SUBJECT FROM PS_EOAW_STEP_VW A , PS_FORM_AW B , PS_FORM C , PS_FORM_LG L , PS_FORM_TYPE_LG D WHERE A.EOAWPRCS_ID = 'FormApproval' AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.SEQ_NBR = C.SEQ_NBR AND C.FORM_TYPE = D.FORM_TYPE AND C.SEQ_NBR = L.SEQ_NBR AND ((A.EOAWSTEP_STATUS = 'P' OR A.EOAWSTEP_STATUS = 'A' OR A.EOAWSTEP_STATUS = 'D' OR A.EOAWSTEP_STATUS = 'H') OR A.EOAWUSER_TYPE = 'R') AND A.EOAWTHREAD_ID = ( SELECT MAX(AA.EOAWTHREAD_ID) FROM PS_EOAW_STEP_VW AA WHERE AA.EOAWPRCS_ID = 'FormApproval' AND AA.EOAWTHREAD_ID = B.EOAWTHREAD_ID )

  • Related Language Record for FORM_APPR_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    5 FORM_SUBJECT Character(100) VARCHAR2(100) NOT NULL Subject