VIEW: PSP.PSP_REPORT_TEMPLATES_H#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_NAME TEMPLATE_NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, REPORT_TYPE REPORT_TYPE, PERIOD_FREQUENCY_ID PERIOD_FREQUENCY_ID, REPORT_TEMPLATE_CODE REPORT_TEMPLATE_CODE, DISPLAY_ALL_EMP_DISTRIB_FLAG DISPLAY_ALL_EMP_DISTRIB_FLAG, MANUAL_ENTRY_OVERRIDE_FLAG MANUAL_ENTRY_OVERRIDE_FLAG, APPROVAL_TYPE APPROVAL_TYPE, CUSTOM_APPROVAL_CODE CUSTOM_APPROVAL_CODE, SUP_LEVELS SUP_LEVELS, PREVIEW_EFFORT_REPORT_FLAG PREVIEW_EFFORT_REPORT_FLAG, NOTIFICATION_REMINDER_IN_DAYS NOTIFICATION_REMINDER_IN_DAYS, PARAMETER_NAME_1 PARAMETER_NAME_1, PARAMETER_NAME_2 PARAMETER_NAME_2, PARAMETER_NAME_3 PARAMETER_NAME_3, PARAMETER_NAME_4 PARAMETER_NAME_4, PARAMETER_NAME_5 PARAMETER_NAME_5, PARAMETER_NAME_6 PARAMETER_NAME_6, PARAMETER_NAME_7 PARAMETER_NAME_7, PARAMETER_NAME_8 PARAMETER_NAME_8, PARAMETER_NAME_9 PARAMETER_NAME_9, PARAMETER_NAME_10 PARAMETER_NAME_10, PARAMETER_NAME_11 PARAMETER_NAME_11, PARAMETER_NAME_12 PARAMETER_NAME_12, PARAMETER_NAME_13 PARAMETER_NAME_13, PARAMETER_NAME_14 PARAMETER_NAME_14, PARAMETER_NAME_15 PARAMETER_NAME_15, PARAMETER_NAME_16 PARAMETER_NAME_16, PARAMETER_NAME_17 PARAMETER_NAME_17, PARAMETER_NAME_18 PARAMETER_NAME_18, PARAMETER_NAME_19 PARAMETER_NAME_19, PARAMETER_NAME_20 PARAMETER_NAME_20, PARAMETER_VALUE_1 PARAMETER_VALUE_1, PARAMETER_VALUE_2 PARAMETER_VALUE_2, PARAMETER_VALUE_3 PARAMETER_VALUE_3, PARAMETER_VALUE_4 PARAMETER_VALUE_4, PARAMETER_VALUE_5 PARAMETER_VALUE_5, PARAMETER_VALUE_6 PARAMETER_VALUE_6, PARAMETER_VALUE_7 PARAMETER_VALUE_7, PARAMETER_VALUE_8 PARAMETER_VALUE_8, PARAMETER_VALUE_9 PARAMETER_VALUE_9, PARAMETER_VALUE_10 PARAMETER_VALUE_10, PARAMETER_VALUE_11 PARAMETER_VALUE_11, PARAMETER_VALUE_12 PARAMETER_VALUE_12, PARAMETER_VALUE_13 PARAMETER_VALUE_13, PARAMETER_VALUE_14 PARAMETER_VALUE_14, PARAMETER_VALUE_15 PARAMETER_VALUE_15, PARAMETER_VALUE_16 PARAMETER_VALUE_16, PARAMETER_VALUE_17 PARAMETER_VALUE_17, PARAMETER_VALUE_18 PARAMETER_VALUE_18, PARAMETER_VALUE_19 PARAMETER_VALUE_19, PARAMETER_VALUE_20 PARAMETER_VALUE_20, SUBMISSION_DATE SUBMISSION_DATE, INITIATOR_PERSON_ID INITIATOR_PERSON_ID, INITIATOR_FILE_ID INITIATOR_FILE_ID, INITIATOR_ACCEPT_FLAG INITIATOR_ACCEPT_FLAG, FINAL_RECIPIENTS_FILE_ID FINAL_RECIPIENTS_FILE_ID, SPRCD_TOLERANCE_AMT SPRCD_TOLERANCE_AMT, SPRCD_TOLERANCE_PERCENT SPRCD_TOLERANCE_PERCENT, DESCRIPTION DESCRIPTION, LEGISLATION_CODE LEGISLATION_CODE, 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, PAYROLL_ACTION_ID PAYROLL_ACTION_ID, FINAL_RECIP_NOTIFIED_FLAG FINAL_RECIP_NOTIFIED_FLAG, HUNDRED_PCENT_EFF_AT_PER_ASG HUNDRED_PCENT_EFF_AT_PER_ASG, INITIATOR_WF_ITEM_KEY INITIATOR_WF_ITEM_KEY, SELECTION_MATCH_LEVEL SELECTION_MATCH_LEVEL from "PSP"."PSP_REPORT_TEMPLATES_H"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_NAME TEMPLATE_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, REPORT_TYPE REPORT_TYPE
, PERIOD_FREQUENCY_ID PERIOD_FREQUENCY_ID
, REPORT_TEMPLATE_CODE REPORT_TEMPLATE_CODE
, DISPLAY_ALL_EMP_DISTRIB_FLAG DISPLAY_ALL_EMP_DISTRIB_FLAG
, MANUAL_ENTRY_OVERRIDE_FLAG MANUAL_ENTRY_OVERRIDE_FLAG
, APPROVAL_TYPE APPROVAL_TYPE
, CUSTOM_APPROVAL_CODE CUSTOM_APPROVAL_CODE
, SUP_LEVELS SUP_LEVELS
, PREVIEW_EFFORT_REPORT_FLAG PREVIEW_EFFORT_REPORT_FLAG
, NOTIFICATION_REMINDER_IN_DAYS NOTIFICATION_REMINDER_IN_DAYS
, PARAMETER_NAME_1 PARAMETER_NAME_1
, PARAMETER_NAME_2 PARAMETER_NAME_2
, PARAMETER_NAME_3 PARAMETER_NAME_3
, PARAMETER_NAME_4 PARAMETER_NAME_4
, PARAMETER_NAME_5 PARAMETER_NAME_5
, PARAMETER_NAME_6 PARAMETER_NAME_6
, PARAMETER_NAME_7 PARAMETER_NAME_7
, PARAMETER_NAME_8 PARAMETER_NAME_8
, PARAMETER_NAME_9 PARAMETER_NAME_9
, PARAMETER_NAME_10 PARAMETER_NAME_10
, PARAMETER_NAME_11 PARAMETER_NAME_11
, PARAMETER_NAME_12 PARAMETER_NAME_12
, PARAMETER_NAME_13 PARAMETER_NAME_13
, PARAMETER_NAME_14 PARAMETER_NAME_14
, PARAMETER_NAME_15 PARAMETER_NAME_15
, PARAMETER_NAME_16 PARAMETER_NAME_16
, PARAMETER_NAME_17 PARAMETER_NAME_17
, PARAMETER_NAME_18 PARAMETER_NAME_18
, PARAMETER_NAME_19 PARAMETER_NAME_19
, PARAMETER_NAME_20 PARAMETER_NAME_20
, PARAMETER_VALUE_1 PARAMETER_VALUE_1
, PARAMETER_VALUE_2 PARAMETER_VALUE_2
, PARAMETER_VALUE_3 PARAMETER_VALUE_3
, PARAMETER_VALUE_4 PARAMETER_VALUE_4
, PARAMETER_VALUE_5 PARAMETER_VALUE_5
, PARAMETER_VALUE_6 PARAMETER_VALUE_6
, PARAMETER_VALUE_7 PARAMETER_VALUE_7
, PARAMETER_VALUE_8 PARAMETER_VALUE_8
, PARAMETER_VALUE_9 PARAMETER_VALUE_9
, PARAMETER_VALUE_10 PARAMETER_VALUE_10
, PARAMETER_VALUE_11 PARAMETER_VALUE_11
, PARAMETER_VALUE_12 PARAMETER_VALUE_12
, PARAMETER_VALUE_13 PARAMETER_VALUE_13
, PARAMETER_VALUE_14 PARAMETER_VALUE_14
, PARAMETER_VALUE_15 PARAMETER_VALUE_15
, PARAMETER_VALUE_16 PARAMETER_VALUE_16
, PARAMETER_VALUE_17 PARAMETER_VALUE_17
, PARAMETER_VALUE_18 PARAMETER_VALUE_18
, PARAMETER_VALUE_19 PARAMETER_VALUE_19
, PARAMETER_VALUE_20 PARAMETER_VALUE_20
, SUBMISSION_DATE SUBMISSION_DATE
, INITIATOR_PERSON_ID INITIATOR_PERSON_ID
, INITIATOR_FILE_ID INITIATOR_FILE_ID
, INITIATOR_ACCEPT_FLAG INITIATOR_ACCEPT_FLAG
, FINAL_RECIPIENTS_FILE_ID FINAL_RECIPIENTS_FILE_ID
, SPRCD_TOLERANCE_AMT SPRCD_TOLERANCE_AMT
, SPRCD_TOLERANCE_PERCENT SPRCD_TOLERANCE_PERCENT
, DESCRIPTION DESCRIPTION
, LEGISLATION_CODE LEGISLATION_CODE
, 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
, PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, FINAL_RECIP_NOTIFIED_FLAG FINAL_RECIP_NOTIFIED_FLAG
, HUNDRED_PCENT_EFF_AT_PER_ASG HUNDRED_PCENT_EFF_AT_PER_ASG
, INITIATOR_WF_ITEM_KEY INITIATOR_WF_ITEM_KEY
, SELECTION_MATCH_LEVEL SELECTION_MATCH_LEVEL
FROM "PSP"."PSP_REPORT_TEMPLATES_H"