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_ET_WT_F

Object Details

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

This table stores summarized cost and revenue measures at the project, expenditure type and worktype levels for Project Intelligence

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_FP_PROJ_ET_WT_F_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID
PJI_FP_PROJ_ET_WT_F_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	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 installation.
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.
PROJECT_TYPE_CLASS	VARCHAR2	(1)	Yes	The class category by which the project is classified.
PERIOD_TYPE_ID	NUMBER	(15)	Yes	Period type
CALENDAR_TYPE	VARCHAR2	(30)	Yes	Calendar type code
CURRENCY_TYPE	VARCHAR2	(30)
EXP_EVT_TYPE_ID	NUMBER	(15)	Yes	Identifier of the expenditure / event type.
WORK_TYPE_ID	NUMBER	(15)	Yes	Identifier for a work type assigned to the transaction.
RAW_COST	NUMBER			Raw cost
BURDENED_COST	NUMBER			Burdened cost
BILL_RAW_COST	NUMBER			Billable raw cost
BILL_BURDENED_COST	NUMBER			Billable burdened cost
CAPITALIZABLE_RAW_COST	NUMBER			Capitalizable raw cost
CAPITALIZABLE_BRDN_COST	NUMBER			Capitalizable 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.
LABOR_HRS	NUMBER			Total number of labor hours.
BILL_LABOR_HRS	NUMBER			Total number of billable labor hours.
QUANTITY	NUMBER			The number of units of the work performed.
BILL_QUANTITY	NUMBER			The number of billable units of the work performed.
LAST_UPDATE_DATE	DATE		Yes	Standard who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		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		Yes	Standard who column - user who has created this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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
,      PROJECT_TYPE_CLASS
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      CURRENCY_TYPE
,      EXP_EVT_TYPE_ID
,      WORK_TYPE_ID
,      RAW_COST
,      BURDENED_COST
,      BILL_RAW_COST
,      BILL_BURDENED_COST
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BURDENED_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BURDENED_COST
,      LABOR_HRS
,      BILL_LABOR_HRS
,      QUANTITY
,      BILL_QUANTITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
FROM PJI.PJI_FP_PROJ_ET_WT_F;

Dependencies

[top of page]

PJI.PJI_FP_PROJ_ET_WT_F does not reference any database object

PJI.PJI_FP_PROJ_ET_WT_F is referenced by following:

APPS: PJI_FP_CLS_ET_WT_F_MV; PJI_FP_ORG_ET_WT_F_MV; PJI_FP_PROJ_ET_WT_F