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]

VIEW: APPS.PJI_PRD_ACT_CMT_PG_TASK_V

Object Details

Object Name:	PJI_PRD_ACT_CMT_PG_TASK_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_PRD_ACT_CMT_PG_TASK_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PJI_PRD_ACT_CMT_PG_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task at Program Level. The view is mainly used by external project management systems that import actuals from Oracle Projects.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project
TASK_ID	NUMBER	(15)	Yes	Identifier of the Task
CALENDAR_TYPE	VARCHAR2	(1)	Yes	Specifies the calendar type (PA, GL)
CALENDAR_ID	NUMBER		Yes	Identifier of calendar
PERIOD_NAME	VARCHAR2	(100)	Yes	Period Name
PERIOD_START_DATE	DATE		Yes	Period Start date
PERIOD_END_DATE	DATE		Yes	Period End date
REVENUE	NUMBER			Revenue
RAW_COST	NUMBER			Raw Cost
CAPITAL_RAW_COST	NUMBER			Capital Raw Cost
BURDENED_COST	NUMBER			Burdened Cost
CAPITAL_BURDENED_COST	NUMBER			Capital Burdened Cost
QUANTITY	NUMBER			Quantity
BILLABLE_QUANTITY	NUMBER			Billable Quantity
LABOR_HRS	NUMBER			Labor Hours
BILL_LABOR_HRS	NUMBER			Billable Labor Hours
BILL_LABOR_RAW_COST	NUMBER			Billable Labor Raw Cost
BILL_LABOR_BRDN_COST	NUMBER			Bllable Labor Burdened Cost
EQUIPMENT_RAW_COST	NUMBER			Equipment Raw Cost
EQUIPMENT_BRDN_COST	NUMBER			Equipment Burdened Cost
LABOR_RAW_COST	NUMBER			Labor Raw Cost
LABOR_BRDN_COST	NUMBER			Labor Burdened Cost
LABOR_REVENUE	NUMBER			Labor Revenue
EQUIPMENT_HOURS	NUMBER			Equipment Hours
BILLABLE_EQUIPMENT_HOURS	NUMBER			Billable Equipment Hours
CMT_QUANTITY	NUMBER			Commitment Quantity
SUP_INV_COMMITTED_COST	NUMBER			Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST	NUMBER			Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST	NUMBER			Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST	NUMBER			Commitments other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST	NUMBER			Commitment Burdened Cost

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      CALENDAR_TYPE
,      CALENDAR_ID
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      REVENUE
,      RAW_COST
,      CAPITAL_RAW_COST
,      BURDENED_COST
,      CAPITAL_BURDENED_COST
,      QUANTITY
,      BILLABLE_QUANTITY
,      LABOR_HRS
,      BILL_LABOR_HRS
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BRDN_COST
,      EQUIPMENT_RAW_COST
,      EQUIPMENT_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      BILLABLE_EQUIPMENT_HOURS
,      CMT_QUANTITY
,      SUP_INV_COMMITTED_COST
,      PO_COMMITTED_COST
,      PR_COMMITTED_COST
,      OTH_COMMITTED_COST
,      CMT_BURDENED_COST
FROM APPS.PJI_PRD_ACT_CMT_PG_TASK_V;

Dependencies

[top of page]

APPS.PJI_PRD_ACT_CMT_PG_TASK_V references the following:

APPS: PA_PROJECTS_ALL; PJI_FP_XBS_ACCUM_F; PJI_TIME_CAL_PERIOD_V

APPS.PJI_PRD_ACT_CMT_PG_TASK_V is not referenced by any database object