[Home] [Help] [Dependency Information]
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.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_ORG_REPORTING_SESSIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SESSION_ID
START_ORGANIZATION_ID |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, START_ORGANIZATION_ID
FROM PA.PA_ORG_REPORTING_SESSIONS;
PA.PA_ORG_REPORTING_SESSIONS does not reference any database object
PA.PA_ORG_REPORTING_SESSIONS is referenced by following:
|
|
|