VIEW: PA.PA_OBJECT_PAGE_LAYOUTS#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, PAGE_TYPE_CODE PAGE_TYPE_CODE, PAGE_ID PAGE_ID, APPROVAL_REQUIRED APPROVAL_REQUIRED, REPORTING_CYCLE_ID REPORTING_CYCLE_ID, REPORT_OFFSET_DAYS REPORT_OFFSET_DAYS, NEXT_REPORTING_DATE NEXT_REPORTING_DATE, REMINDER_DAYS REMINDER_DAYS, REMINDER_DAYS_TYPE REMINDER_DAYS_TYPE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, INITIAL_PROGRESS_STATUS INITIAL_PROGRESS_STATUS, FINAL_PROGRESS_STATUS FINAL_PROGRESS_STATUS, ROLLUP_PROGRESS_STATUS ROLLUP_PROGRESS_STATUS, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_PAGE_LAYOUT_ID OBJECT_PAGE_LAYOUT_ID, REPORT_TYPE_ID REPORT_TYPE_ID, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, APPROVER_SOURCE_ID APPROVER_SOURCE_ID, APPROVER_SOURCE_TYPE APPROVER_SOURCE_TYPE, PERS_FUNCTION_NAME PERS_FUNCTION_NAME from "PA"."PA_OBJECT_PAGE_LAYOUTS"

View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, PAGE_TYPE_CODE PAGE_TYPE_CODE
, PAGE_ID PAGE_ID
, APPROVAL_REQUIRED APPROVAL_REQUIRED
, REPORTING_CYCLE_ID REPORTING_CYCLE_ID
, REPORT_OFFSET_DAYS REPORT_OFFSET_DAYS
, NEXT_REPORTING_DATE NEXT_REPORTING_DATE
, REMINDER_DAYS REMINDER_DAYS
, REMINDER_DAYS_TYPE REMINDER_DAYS_TYPE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, INITIAL_PROGRESS_STATUS INITIAL_PROGRESS_STATUS
, FINAL_PROGRESS_STATUS FINAL_PROGRESS_STATUS
, ROLLUP_PROGRESS_STATUS ROLLUP_PROGRESS_STATUS
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_PAGE_LAYOUT_ID OBJECT_PAGE_LAYOUT_ID
, REPORT_TYPE_ID REPORT_TYPE_ID
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, APPROVER_SOURCE_ID APPROVER_SOURCE_ID
, APPROVER_SOURCE_TYPE APPROVER_SOURCE_TYPE
, PERS_FUNCTION_NAME PERS_FUNCTION_NAME
FROM "PA"."PA_OBJECT_PAGE_LAYOUTS"