eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_OBJECT_PAGE_LAYOUTS

Object Details

Object Name:	PA_OBJECT_PAGE_LAYOUTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_OBJECT_PAGE_LAYOUTS
Subobject Name:
Status:	VALID

This table contains association of different page layouts with objects. An object could be a project or a task.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_OBJECT_PAGE_LAYOUTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE PAGE_TYPE_CODE REPORT_TYPE_ID
PA_OBJECT_PAGE_LAYOUTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_PAGE_LAYOUT_ID
PA_OBJECT_PAGE_LAYOUTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAGE_ID
PA_OBJECT_PAGE_LAYOUTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_TYPE_ID
PA_OBJECT_PAGE_LAYOUTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORTING_CYCLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	Identifier of the object. For example, PROJECT_ID is an object that can be associated with the object_type PA_PROJECTS.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Identifier of the object type, such as PA_PROJECTS
PAGE_TYPE_CODE	VARCHAR2	(30)	Yes	Identifier of the page type, such as PPR or PH
PAGE_ID	NUMBER	(15)	Yes	Identifier of the page layout
APPROVAL_REQUIRED	VARCHAR2	(1)		Flag indicating whether Workflow approval is required for the progress report
REPORTING_CYCLE_ID	NUMBER	(15)		Reporting cycle used by the project
REPORT_OFFSET_DAYS	NUMBER			Number of days to offset the reports
NEXT_REPORTING_DATE	DATE			Next reporting date computed according to the reporting cycle
REMINDER_DAYS	NUMBER			Number of days required to send a reminder
REMINDER_DAYS_TYPE	VARCHAR2	(30)		Type of day to use for computing reminder date, such as weekdays or business days
RECORD_VERSION_NUMBER	NUMBER			Number used for record locking in self-service applications
INITIAL_PROGRESS_STATUS	VARCHAR2	(30)		Initial progress status for a project or task
FINAL_PROGRESS_STATUS	VARCHAR2	(30)		Final progress status for a project or task
ROLLUP_PROGRESS_STATUS	VARCHAR2	(1)		Flag indicating whether rollup for Progress Status is required
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
OBJECT_PAGE_LAYOUT_ID	NUMBER	(15)	Yes	A system Generated number that uniquely identifies objects and page lay out association.
REPORT_TYPE_ID	NUMBER	(15)		Identifier of the report type
EFFECTIVE_FROM	DATE			Effective start date of the report type for this object
EFFECTIVE_TO	DATE			Effective end date of the report type for this object
APPROVER_SOURCE_ID	NUMBER	(15)		Identifier of the person who approves the report
APPROVER_SOURCE_TYPE	NUMBER	(15)		Type of the person who approves the report
PERS_FUNCTION_NAME	VARCHAR2	(30)		Stores the name of the function personalization

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 does not reference any database object

PA.PA_OBJECT_PAGE_LAYOUTS is referenced by following:

APPS: PA_OBJECT_PAGE_LAYOUTS