DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_OBJECT_PAGE_LAYOUTS#

Object Details
Object Name: PA_OBJECT_PAGE_LAYOUTS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (15) Yes
OBJECT_TYPE VARCHAR2 (30) Yes
PAGE_TYPE_CODE VARCHAR2 (30) Yes
PAGE_ID NUMBER (15) Yes
APPROVAL_REQUIRED VARCHAR2 (1)
REPORTING_CYCLE_ID NUMBER (15)
REPORT_OFFSET_DAYS NUMBER

NEXT_REPORTING_DATE DATE

REMINDER_DAYS NUMBER

REMINDER_DAYS_TYPE VARCHAR2 (30)
RECORD_VERSION_NUMBER NUMBER

INITIAL_PROGRESS_STATUS VARCHAR2 (30)
FINAL_PROGRESS_STATUS VARCHAR2 (30)
ROLLUP_PROGRESS_STATUS VARCHAR2 (1)
LAST_UPDATED_BY NUMBER
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

OBJECT_PAGE_LAYOUT_ID NUMBER (15) Yes
REPORT_TYPE_ID NUMBER (15)
EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

APPROVER_SOURCE_ID NUMBER (15)
APPROVER_SOURCE_TYPE NUMBER (15)
PERS_FUNCTION_NAME VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PA.PA_OBJECT_PAGE_LAYOUTS# references the following:

SchemaPA
TablePA_OBJECT_PAGE_LAYOUTS
PA.PA_OBJECT_PAGE_LAYOUTS# is referenced by following:

SchemaAPPS
SynonymPA_OBJECT_PAGE_LAYOUTS