VIEW: PSP.PSP_EFF_REPORT_APPROVALS#

Source

View Text - Preformatted

select EFFORT_REPORT_APPROVAL_ID EFFORT_REPORT_APPROVAL_ID, EFFORT_REPORT_DETAIL_ID EFFORT_REPORT_DETAIL_ID, WF_ROLE_NAME WF_ROLE_NAME, WF_ORIG_SYSTEM_ID WF_ORIG_SYSTEM_ID, WF_ORIG_SYSTEM WF_ORIG_SYSTEM, APPROVER_ORDER_NUM APPROVER_ORDER_NUM, APPROVAL_STATUS APPROVAL_STATUS, RESPONSE_DATE RESPONSE_DATE, ACTUAL_COST_SHARE ACTUAL_COST_SHARE, OVERWRITTEN_EFFORT_PERCENT OVERWRITTEN_EFFORT_PERCENT, WF_ITEM_KEY WF_ITEM_KEY, COMMENTS COMMENTS, PERA_INFORMATION_CATEGORY PERA_INFORMATION_CATEGORY, PERA_INFORMATION1 PERA_INFORMATION1, PERA_INFORMATION2 PERA_INFORMATION2, PERA_INFORMATION3 PERA_INFORMATION3, PERA_INFORMATION4 PERA_INFORMATION4, PERA_INFORMATION5 PERA_INFORMATION5, PERA_INFORMATION6 PERA_INFORMATION6, PERA_INFORMATION7 PERA_INFORMATION7, PERA_INFORMATION8 PERA_INFORMATION8, PERA_INFORMATION9 PERA_INFORMATION9, PERA_INFORMATION10 PERA_INFORMATION10, PERA_INFORMATION11 PERA_INFORMATION11, PERA_INFORMATION12 PERA_INFORMATION12, PERA_INFORMATION13 PERA_INFORMATION13, PERA_INFORMATION14 PERA_INFORMATION14, PERA_INFORMATION15 PERA_INFORMATION15, PERA_INFORMATION16 PERA_INFORMATION16, PERA_INFORMATION17 PERA_INFORMATION17, PERA_INFORMATION18 PERA_INFORMATION18, PERA_INFORMATION19 PERA_INFORMATION19, PERA_INFORMATION20 PERA_INFORMATION20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, WF_ROLE_DISPLAY_NAME WF_ROLE_DISPLAY_NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NOTIFICATION_ID NOTIFICATION_ID, EFF_INFORMATION_CATEGORY EFF_INFORMATION_CATEGORY, EFF_INFORMATION1 EFF_INFORMATION1, EFF_INFORMATION2 EFF_INFORMATION2, EFF_INFORMATION3 EFF_INFORMATION3, EFF_INFORMATION4 EFF_INFORMATION4, EFF_INFORMATION5 EFF_INFORMATION5, EFF_INFORMATION6 EFF_INFORMATION6, EFF_INFORMATION7 EFF_INFORMATION7, EFF_INFORMATION8 EFF_INFORMATION8, EFF_INFORMATION9 EFF_INFORMATION9, EFF_INFORMATION10 EFF_INFORMATION10, EFF_INFORMATION11 EFF_INFORMATION11, EFF_INFORMATION12 EFF_INFORMATION12, EFF_INFORMATION13 EFF_INFORMATION13, EFF_INFORMATION14 EFF_INFORMATION14, EFF_INFORMATION15 EFF_INFORMATION15 from "PSP"."PSP_EFF_REPORT_APPROVALS"

View Text - HTML Formatted

SELECT EFFORT_REPORT_APPROVAL_ID EFFORT_REPORT_APPROVAL_ID
, EFFORT_REPORT_DETAIL_ID EFFORT_REPORT_DETAIL_ID
, WF_ROLE_NAME WF_ROLE_NAME
, WF_ORIG_SYSTEM_ID WF_ORIG_SYSTEM_ID
, WF_ORIG_SYSTEM WF_ORIG_SYSTEM
, APPROVER_ORDER_NUM APPROVER_ORDER_NUM
, APPROVAL_STATUS APPROVAL_STATUS
, RESPONSE_DATE RESPONSE_DATE
, ACTUAL_COST_SHARE ACTUAL_COST_SHARE
, OVERWRITTEN_EFFORT_PERCENT OVERWRITTEN_EFFORT_PERCENT
, WF_ITEM_KEY WF_ITEM_KEY
, COMMENTS COMMENTS
, PERA_INFORMATION_CATEGORY PERA_INFORMATION_CATEGORY
, PERA_INFORMATION1 PERA_INFORMATION1
, PERA_INFORMATION2 PERA_INFORMATION2
, PERA_INFORMATION3 PERA_INFORMATION3
, PERA_INFORMATION4 PERA_INFORMATION4
, PERA_INFORMATION5 PERA_INFORMATION5
, PERA_INFORMATION6 PERA_INFORMATION6
, PERA_INFORMATION7 PERA_INFORMATION7
, PERA_INFORMATION8 PERA_INFORMATION8
, PERA_INFORMATION9 PERA_INFORMATION9
, PERA_INFORMATION10 PERA_INFORMATION10
, PERA_INFORMATION11 PERA_INFORMATION11
, PERA_INFORMATION12 PERA_INFORMATION12
, PERA_INFORMATION13 PERA_INFORMATION13
, PERA_INFORMATION14 PERA_INFORMATION14
, PERA_INFORMATION15 PERA_INFORMATION15
, PERA_INFORMATION16 PERA_INFORMATION16
, PERA_INFORMATION17 PERA_INFORMATION17
, PERA_INFORMATION18 PERA_INFORMATION18
, PERA_INFORMATION19 PERA_INFORMATION19
, PERA_INFORMATION20 PERA_INFORMATION20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, WF_ROLE_DISPLAY_NAME WF_ROLE_DISPLAY_NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NOTIFICATION_ID NOTIFICATION_ID
, EFF_INFORMATION_CATEGORY EFF_INFORMATION_CATEGORY
, EFF_INFORMATION1 EFF_INFORMATION1
, EFF_INFORMATION2 EFF_INFORMATION2
, EFF_INFORMATION3 EFF_INFORMATION3
, EFF_INFORMATION4 EFF_INFORMATION4
, EFF_INFORMATION5 EFF_INFORMATION5
, EFF_INFORMATION6 EFF_INFORMATION6
, EFF_INFORMATION7 EFF_INFORMATION7
, EFF_INFORMATION8 EFF_INFORMATION8
, EFF_INFORMATION9 EFF_INFORMATION9
, EFF_INFORMATION10 EFF_INFORMATION10
, EFF_INFORMATION11 EFF_INFORMATION11
, EFF_INFORMATION12 EFF_INFORMATION12
, EFF_INFORMATION13 EFF_INFORMATION13
, EFF_INFORMATION14 EFF_INFORMATION14
, EFF_INFORMATION15 EFF_INFORMATION15
FROM "PSP"."PSP_EFF_REPORT_APPROVALS"