EX_MAP_AW_VW2

(SQL View)
 Index Back

MAP Urgency for Expense

View used to determine Urgency for MAP for Expense Reports

SELECT DISTINCT H.SHEET_ID , H.CREATION_DT , H.SUBMISSION_DATE , U.OPRID FROM PS_EX_SHEET_HDR H , PS_EX_SHEET_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE H.SHEET_ID = X.SHEET_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.EOAWTHREAD_ID = ( CASE WHEN EXISTS ( SELECT EOAWTHREAD_STATUS FROM PS_EX_SHEET_AW C1 WHERE H.SHEET_ID = C1.SHEET_ID AND C1.RECNAME = 'EX_ER_HDR_AW_VW' AND C1.EOAWTHREAD_STATUS = 'P') THEN ( SELECT MIN(X1.EOAWTHREAD_ID) FROM PS_EX_SHEET_AW X1 WHERE X1.SHEET_ID = X.SHEET_ID) WHEN EXISTS ( SELECT EOAWTHREAD_STATUS FROM PS_EX_SHEET_AW C1 WHERE H.SHEET_ID = C1.SHEET_ID AND C1.RECNAME = 'EX_ER_LN_AW_VW' AND C1.EOAWTHREAD_STATUS = 'P') THEN ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_EX_SHEET_AW X1 WHERE X1.SHEET_ID = X.SHEET_ID) END )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 SUBMISSION_DATE Date(10) DATE Submission Date
3 CREATION_DT Date(10) DATE Creation Date
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).