VIEW: PSP.PSP_EFF_REPORTS#

Source

View Text - Preformatted

select EFFORT_REPORT_ID EFFORT_REPORT_ID, PERSON_ID PERSON_ID, FULL_NAME FULL_NAME, START_DATE START_DATE, END_DATE END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATUS_CODE STATUS_CODE, TEMPLATE_ID TEMPLATE_ID, REQUEST_ID REQUEST_ID, CURRENCY_CODE CURRENCY_CODE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SUPERCEDING_SUMMARY_LINE_ID SUPERCEDING_SUMMARY_LINE_ID, SUPERCEDING_REQUEST_ID SUPERCEDING_REQUEST_ID, PERSON_XML PERSON_XML, MAILSTOP MAILSTOP, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, EMP_PRIMARY_ORG_NAME EMP_PRIMARY_ORG_NAME, EMP_PRIMARY_ORG_ID EMP_PRIMARY_ORG_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, SUPERCEDING_PROGRAM_NAME SUPERCEDING_PROGRAM_NAME from "PSP"."PSP_EFF_REPORTS"

View Text - HTML Formatted

SELECT EFFORT_REPORT_ID EFFORT_REPORT_ID
, PERSON_ID PERSON_ID
, FULL_NAME FULL_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATUS_CODE STATUS_CODE
, TEMPLATE_ID TEMPLATE_ID
, REQUEST_ID REQUEST_ID
, CURRENCY_CODE CURRENCY_CODE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SUPERCEDING_SUMMARY_LINE_ID SUPERCEDING_SUMMARY_LINE_ID
, SUPERCEDING_REQUEST_ID SUPERCEDING_REQUEST_ID
, PERSON_XML PERSON_XML
, MAILSTOP MAILSTOP
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, EMP_PRIMARY_ORG_NAME EMP_PRIMARY_ORG_NAME
, EMP_PRIMARY_ORG_ID EMP_PRIMARY_ORG_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, SUPERCEDING_PROGRAM_NAME SUPERCEDING_PROGRAM_NAME
FROM "PSP"."PSP_EFF_REPORTS"