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: PJI.PJI_ORG_EXTR_INFO

Object Details

Object Name:	PJI_ORG_EXTR_INFO
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_ORG_EXTR_INFO
Subobject Name:
Status:	VALID

This table stores information for organizations that have been extracted to project performance-reporting model.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_ORG_EXTR_INFO_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID

Columns

Name	Datatype	Length	Comments
ORG_ID	NUMBER	(15)	Identifier of the operating unit.
PF_CURRENCY_CODE	VARCHAR2	(30)	Project functional currency code
EN_CALENDAR_MIN_DATE	NUMBER		Earliest date defined for the enterprise calendar.
EN_CALENDAR_MAX_DATE	NUMBER		Latest date defined for the enterprise calendar.
GL_CALENDAR_ID	NUMBER	(15)	Identifier of the GL calendar.
GL_CALENDAR_MIN_DATE	NUMBER		Earliest date defined for the GL calendar.
GL_CALENDAR_MAX_DATE	NUMBER		Latest date defined for the GL calendar.
PA_CALENDAR_ID	NUMBER	(15)	Identifier of the PA calendar.
PA_CALENDAR_MIN_DATE	NUMBER		Earliest date defined for the PA calendar.
PA_CALENDAR_MAX_DATE	NUMBER		Latest date defined for the PA calendar.
PROJFUNC_CURRENCY_MAU	NUMBER		Project functional currency minimum accounting unit.
PA_FIRST_PERIOD_ID	NUMBER		Identifier of the first period in the PA calendar.
PA_FIRST_PERIOD_NAME	VARCHAR2	(100)	Name of the first period in the PA calendar.
PA_FIRST_START_DATE	NUMBER		Start date of the first period in the PA calendar.
PA_FIRST_END_DATE	NUMBER		End date of the first period in the PA calendar.
GL_FIRST_PERIOD_ID	NUMBER		Identifier of the first period in the GL calendar.
GL_FIRST_PERIOD_NAME	VARCHAR2	(100)	Name of the first period in the GL calendar.
GL_FIRST_START_DATE	NUMBER		Start date of the first period in the GL calendar.
GL_FIRST_END_DATE	NUMBER		End date of the first period in the GL calendar.
PA_CURR_REP_PERIOD	VARCHAR2	(15)	Current PA reporting period
GL_CURR_REP_PERIOD	VARCHAR2	(15)	Current GL reporting period

Query Text

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


SELECT ORG_ID
,      PF_CURRENCY_CODE
,      EN_CALENDAR_MIN_DATE
,      EN_CALENDAR_MAX_DATE
,      GL_CALENDAR_ID
,      GL_CALENDAR_MIN_DATE
,      GL_CALENDAR_MAX_DATE
,      PA_CALENDAR_ID
,      PA_CALENDAR_MIN_DATE
,      PA_CALENDAR_MAX_DATE
,      PROJFUNC_CURRENCY_MAU
,      PA_FIRST_PERIOD_ID
,      PA_FIRST_PERIOD_NAME
,      PA_FIRST_START_DATE
,      PA_FIRST_END_DATE
,      GL_FIRST_PERIOD_ID
,      GL_FIRST_PERIOD_NAME
,      GL_FIRST_START_DATE
,      GL_FIRST_END_DATE
,      PA_CURR_REP_PERIOD
,      GL_CURR_REP_PERIOD
FROM PJI.PJI_ORG_EXTR_INFO;

Dependencies

[top of page]

PJI.PJI_ORG_EXTR_INFO does not reference any database object

PJI.PJI_ORG_EXTR_INFO is referenced by following:

APPS: PJI_ORG_EXTR_INFO; PJI_TIME_DAY_MV; PJI_TIME_MV