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_ORG_REPORTING_SESSIONS

Object Details

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

PA_ORG_REPORTING_SESSIONS is used with
PA_ORG_REPORTING_VIEW to easily report all organizations
below a given start organization.
.
.
You insert a value into PA_ORG_REPORTING_SESSIONS for the
start organization parameter. You can then report all
organizations below that start organization as defined
in the organization hierarchy used by Oracle Projects
by selecting from PA_ORG_REPORTING_VIEW.
.
.
This table and view are used in several Oracle Projects
standard reports that use a start organization parameter.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_ORG_REPORTING_SESSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SESSION_ID START_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER	(15)	Yes	The identifier of the session that the user is logged in on determined from userenv('SESSIONID')
START_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization for which you want to report all organizations below it in a report

Query Text

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


SELECT SESSION_ID
,      START_ORGANIZATION_ID
FROM PA.PA_ORG_REPORTING_SESSIONS;

Dependencies

[top of page]

PA.PA_ORG_REPORTING_SESSIONS does not reference any database object

PA.PA_ORG_REPORTING_SESSIONS is referenced by following:

PA: PA_ORG_REPORTING_SESSIONS#