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_FP_PROJ_F

Object Details

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

This table stores summarized cost and revenue measures at the project level for Project Intelligence

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_FP_PROJ_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID
PJI_FP_PROJ_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_ID TIME_ID CALENDAR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ORG_ID	NUMBER	(15)	Yes	Projects operating unit identifier for multi-organization installations.
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Yes	Identifier of the organization that is responsible for the project work.
TIME_ID	NUMBER	(15)	Yes	Identifier of the time.
PROJECT_ID	NUMBER	(15)	Yes	Number that uniquely identifies the project.
PERIOD_TYPE_ID	NUMBER	(15)	Yes	Period type
CALENDAR_TYPE	VARCHAR2	(30)	Yes	Calendar type
CURRENCY_TYPE	VARCHAR2	(30)
REVENUE	NUMBER			Revenue amount
LABOR_REVENUE	NUMBER			Labor revenue amount
RAW_COST	NUMBER			Raw cost
BURDENED_COST	NUMBER			Burdened cost
BILL_RAW_COST	NUMBER			Billable raw cost
BILL_BURDENED_COST	NUMBER			Billable burdened cost
LABOR_RAW_COST	NUMBER			Labor portion of raw cost
LABOR_BURDENED_COST	NUMBER			Labor portion of burdened cost
BILL_LABOR_RAW_COST	NUMBER			Billable labor portion of raw cost
BILL_LABOR_BURDENED_COST	NUMBER			Billable labor portion of burdened cost
REVENUE_WRITEOFF	NUMBER			Revenue write-off amount
CURR_BGT_REVENUE	NUMBER			Current budget version's revenue amount
CURR_BGT_RAW_COST	NUMBER			Current budget version's raw cost
CURR_BGT_BURDENED_COST	NUMBER			Current budget version's burdened cost
CURR_BGT_LABOR_HRS	NUMBER			Current budget versions labor hours
ORIG_BGT_REVENUE	NUMBER			Original budget version's revenue amount
ORIG_BGT_RAW_COST	NUMBER			Original budget version's raw cost
ORIG_BGT_BURDENED_COST	NUMBER			Original budget version's burdened cost
ORIG_BGT_LABOR_HRS	NUMBER			Original budget versions labor hours
FORECAST_REVENUE	NUMBER			Forecast budget version's revenue amount
FORECAST_RAW_COST	NUMBER			Forecast budget version's raw cost
FORECAST_BURDENED_COST	NUMBER			Forecast budget version's burdened cost
FORECAST_LABOR_HRS	NUMBER			Forecast budget versions labor hours
LABOR_HRS	NUMBER			Total labor hours
BILL_LABOR_HRS	NUMBER			Billable labor hours
LAST_UPDATE_DATE	DATE		Yes	Standard who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who has created this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROJECT_TYPE_CLASS	VARCHAR2	(1)		Identifier of the project type class.
CAPITALIZABLE_RAW_COST	NUMBER			Capitalizable raw cost
CAPITALIZABLE_BRDN_COST	NUMBER			Capitalizable burdened cost
CURR_RECORD_TYPE_ID	NUMBER	(15)		Bitmask Identifier for the Currency record type.1- Global Secondary, 2 - Global Primary, 4 - Project,8 - Project Functional, 16 - Transaction
CURRENCY_CODE	VARCHAR2	(30)		Currency Code of the transaction

Query Text

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


SELECT PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      TIME_ID
,      PROJECT_ID
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      CURRENCY_TYPE
,      REVENUE
,      LABOR_REVENUE
,      RAW_COST
,      BURDENED_COST
,      BILL_RAW_COST
,      BILL_BURDENED_COST
,      LABOR_RAW_COST
,      LABOR_BURDENED_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BURDENED_COST
,      REVENUE_WRITEOFF
,      CURR_BGT_REVENUE
,      CURR_BGT_RAW_COST
,      CURR_BGT_BURDENED_COST
,      CURR_BGT_LABOR_HRS
,      ORIG_BGT_REVENUE
,      ORIG_BGT_RAW_COST
,      ORIG_BGT_BURDENED_COST
,      ORIG_BGT_LABOR_HRS
,      FORECAST_REVENUE
,      FORECAST_RAW_COST
,      FORECAST_BURDENED_COST
,      FORECAST_LABOR_HRS
,      LABOR_HRS
,      BILL_LABOR_HRS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_TYPE_CLASS
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
FROM PJI.PJI_FP_PROJ_F;

Dependencies

[top of page]

PJI.PJI_FP_PROJ_F does not reference any database object

PJI.PJI_FP_PROJ_F is referenced by following:

APPS: PJI_FP_CLS_F_MV; PJI_FP_ORG_F_MV; PJI_FP_PROJ_F