DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PJI_XTD_ACT_CMT_BY_RSRC_V

Object Details
Object Name: PJI_XTD_ACT_CMT_BY_RSRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_XTD_ACT_CMT_BY_RSRC_V
Subobject Name:
Status: VALID

View Type

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


PJI_XTD_ACT_CMT_BY_RSRC_V is a view that displays actual cost, revenue totals, and commitments for PTD, QTD, YTD, and ITD by task, and resource. 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: 'C' = Common (shared between ENT and GL), 'P' = PA calendar, 'G' = GL calendar, 'E' = Enterprise calendar
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
RBS_VERSION_ID NUMBER (15)
Identifier for the RBS version (New column added to replace Resource List Id)
RBS_ELEMENT_ID NUMBER (15) Yes Identifier for the RBS (New column added to replace Resource List Member Id)
REVENUE_PTD NUMBER

Revenue PTD
RAW_COST_PTD NUMBER

Raw Cost PTD
BURDENED_COST_PTD NUMBER

Burdened Cost PTD
BILLABLE_RAW_COST_PTD NUMBER

Billable Raw Cost PTD
BILLABLE_BURDENED_COST_PTD NUMBER

Billable Burdened Raw Cost PTD
BILL_LABOR_RAW_COST_PTD NUMBER

Billable Labor Raw Cost PTD
BILL_LABOR_BRDN_COST_PTD NUMBER

Billable Labor Burdened Cost PTD
BILL_LABOR_HRS_PTD NUMBER

Billable Labor Hours PTD
EQUIPMENT_RAW_COST_PTD NUMBER

Equipment Raw Cost PTD
EQUIPMENT_BRDN_COST_PTD NUMBER

Equipment Burdened PTD
CAPITAL_RAW_COST_PTD NUMBER

Capital Raw Cost PTD
CAPITAL_BURDENED_COST_PTD NUMBER

Capital Burdened Cost PTD
LABOR_RAW_COST_PTD NUMBER

Labor Raw Cost PTD
LABOR_BRDN_COST_PTD NUMBER

Labor Burdened Cost PTD
LABOR_HOURS_PTD NUMBER

Labor Hours PTD
LABOR_REVENUE_PTD NUMBER

Labor Revenue PTD
EQUIPMENT_HOURS_PTD NUMBER

Equipment Hours PTD
BILLABLE_EQUIPMENT_HOURS_PTD NUMBER

Billable Equipment Hours PTD
SUP_INV_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_PTD NUMBER

Commitments PTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_PTD NUMBER

Commitment Burdened Cost PTD
BILLABLE_QUANTITY_PTD NUMBER

Billable Quantity PTD
BILLABLE_LABOR_HOURS_PTD NUMBER

Billable Labor Hours PTD
CMT_QUANTITY_PTD NUMBER

Commitment Quantity PTD
LABOR_HRS_PTD NUMBER

Labor Hours PTD
QUANTITY_PTD NUMBER

Quantity PTD
REVENUE_QTD NUMBER

Revenue QTD
RAW_COST_QTD NUMBER

Raw Cost QTD
BURDENED_COST_QTD NUMBER

Burdened Cost QTD
BILLABLE_RAW_COST_QTD NUMBER

Billable Raw Cost QTD
BILLABLE_BURDENED_COST_QTD NUMBER

Billable Burdened Raw Cost QTD
BILL_LABOR_RAW_COST_QTD NUMBER

Billable Labor Raw Cost QTD
BILL_LABOR_BRDN_COST_QTD NUMBER

Billable Labor Burdened Cost QTD
BILL_LABOR_HRS_QTD NUMBER

Billable Labor Hours QTD
EQUIPMENT_RAW_COST_QTD NUMBER

Equipment Raw Cost QTD
EQUIPMENT_BRDN_COST_QTD NUMBER

Equipment Burdened QTD
CAPITAL_RAW_COST_QTD NUMBER

Capital Raw Cost QTD
CAPITAL_BURDENED_COST_QTD NUMBER

Capital Burdened Cost QTD
LABOR_RAW_COST_QTD NUMBER

Labor Raw Cost QTD
LABOR_BRDN_COST_QTD NUMBER

Labor Burdened Cost QTD
LABOR_HOURS_QTD NUMBER

Labor Hours QTD
LABOR_REVENUE_QTD NUMBER

Labor Revenue QTD
EQUIPMENT_HOURS_QTD NUMBER

Equipment Hours QTD
BILLABLE_EQUIPMENT_HOURS_QTD NUMBER

Billable Equipment Hours QTD
SUP_INV_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_QTD NUMBER

Commitments QTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_QTD NUMBER

Commitment Burdened Cost QTD
BILLABLE_QUANTITY_QTD NUMBER

Billable Quantity QTD
BILLABLE_LABOR_HOURS_QTD NUMBER

Billable Labor Hours QTD
CMT_QUANTITY_QTD NUMBER

Commitment Quantity QTD
LABOR_HRS_QTD NUMBER

Labor Hours QTD
QUANTITY_QTD NUMBER

Quantity QTD
REVENUE_YTD NUMBER

Revenue YTD
RAW_COST_YTD NUMBER

Raw Cost YTD
BURDENED_COST_YTD NUMBER

Burdened Cost YTD
BILLABLE_RAW_COST_YTD NUMBER

Billable Raw Cost YTD
BILLABLE_BURDENED_COST_YTD NUMBER

Billable Burdened Raw Cost YTD
BILL_LABOR_RAW_COST_YTD NUMBER

Billable Labor Raw Cost YTD
BILL_LABOR_BRDN_COST_YTD NUMBER

Billable Labor Burdened Cost YTD
BILL_LABOR_HRS_YTD NUMBER

Billable Labor Hours YTD
EQUIPMENT_RAW_COST_YTD NUMBER

Equipment Raw Cost YTD
EQUIPMENT_BRDN_COST_YTD NUMBER

Equipment Burdened YTD
CAPITAL_RAW_COST_YTD NUMBER

Capital Raw Cost YTD
CAPITAL_BURDENED_COST_YTD NUMBER

Capital Burdened Cost YTD
LABOR_RAW_COST_YTD NUMBER

Labor Raw Cost YTD
LABOR_BRDN_COST_YTD NUMBER

Labor Burdened Cost YTD
LABOR_HOURS_YTD NUMBER

Labor Hours YTD
LABOR_REVENUE_YTD NUMBER

Labor Revenue YTD
EQUIPMENT_HOURS_YTD NUMBER

Equipment Hours YTD
BILLABLE_EQUIPMENT_HOURS_YTD NUMBER

Billable Equipment Hours YTD
SUP_INV_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_YTD NUMBER

Commitments YTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_YTD NUMBER

Commitment Burdened Cost YTD
BILLABLE_QUANTITY_YTD NUMBER

Billable Quantity YTD
BILLABLE_LABOR_HOURS_YTD NUMBER

Billable Labor Hours YTD
CMT_QUANTITY_YTD NUMBER

Commitment Quantity YTD
LABOR_HRS_YTD NUMBER

Labor Hours YTD
QUANTITY_YTD NUMBER

Quantity YTD
REVENUE_ITD NUMBER

Revenue ITD
RAW_COST_ITD NUMBER

Raw Cost ITD
BURDENED_COST_ITD NUMBER

Burdened Cost ITD
BILLABLE_RAW_COST_ITD NUMBER

Billable Raw Cost ITD
BILLABLE_BURDENED_COST_ITD NUMBER

Billable Burdened Raw Cost ITD
BILL_LABOR_RAW_COST_ITD NUMBER

Billable Labor Raw Cost ITD
BILL_LABOR_BRDN_COST_ITD NUMBER

Billable Labor Burdened Cost ITD
BILL_LABOR_HRS_ITD NUMBER

Billable Labor Hours ITD
EQUIPMENT_RAW_COST_ITD NUMBER

Equipment Raw Cost ITD
EQUIPMENT_BRDN_COST_ITD NUMBER

Equipment Burdened ITD
CAPITAL_RAW_COST_ITD NUMBER

Capital Raw Cost ITD
CAPITAL_BURDENED_COST_ITD NUMBER

Capital Burdened Cost ITD
LABOR_RAW_COST_ITD NUMBER

Labor Raw Cost ITD
LABOR_BRDN_COST_ITD NUMBER

Labor Burdened Cost ITD
LABOR_HOURS_ITD NUMBER

Labor Hours ITD
LABOR_REVENUE_ITD NUMBER

Labor Revenue ITD
EQUIPMENT_HOURS_ITD NUMBER

Equipment Hours ITD
BILLABLE_EQUIPMENT_HOURS_ITD NUMBER

Billable Equipment Hours ITD
SUP_INV_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_ITD NUMBER

Commitments ITD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_ITD NUMBER

Commitment Burdened Cost ITD
BILLABLE_QUANTITY_ITD NUMBER

Billable Quantity ITD
BILLABLE_LABOR_HOURS_ITD NUMBER

Billable Labor Hours ITD
CMT_QUANTITY_ITD NUMBER

Commitment Quantity ITD
LABOR_HRS_ITD NUMBER

Labor Hours ITD
QUANTITY_ITD NUMBER

Quantity ITD
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
,      RBS_VERSION_ID
,      RBS_ELEMENT_ID
,      REVENUE_PTD
,      RAW_COST_PTD
,      BURDENED_COST_PTD
,      BILLABLE_RAW_COST_PTD
,      BILLABLE_BURDENED_COST_PTD
,      BILL_LABOR_RAW_COST_PTD
,      BILL_LABOR_BRDN_COST_PTD
,      BILL_LABOR_HRS_PTD
,      EQUIPMENT_RAW_COST_PTD
,      EQUIPMENT_BRDN_COST_PTD
,      CAPITAL_RAW_COST_PTD
,      CAPITAL_BURDENED_COST_PTD
,      LABOR_RAW_COST_PTD
,      LABOR_BRDN_COST_PTD
,      LABOR_HOURS_PTD
,      LABOR_REVENUE_PTD
,      EQUIPMENT_HOURS_PTD
,      BILLABLE_EQUIPMENT_HOURS_PTD
,      SUP_INV_COMMITTED_COST_PTD
,      PO_COMMITTED_COST_PTD
,      PR_COMMITTED_COST_PTD
,      OTH_COMMITTED_COST_PTD
,      CMT_BURDENED_COST_PTD
,      BILLABLE_QUANTITY_PTD
,      BILLABLE_LABOR_HOURS_PTD
,      CMT_QUANTITY_PTD
,      LABOR_HRS_PTD
,      QUANTITY_PTD
,      REVENUE_QTD
,      RAW_COST_QTD
,      BURDENED_COST_QTD
,      BILLABLE_RAW_COST_QTD
,      BILLABLE_BURDENED_COST_QTD
,      BILL_LABOR_RAW_COST_QTD
,      BILL_LABOR_BRDN_COST_QTD
,      BILL_LABOR_HRS_QTD
,      EQUIPMENT_RAW_COST_QTD
,      EQUIPMENT_BRDN_COST_QTD
,      CAPITAL_RAW_COST_QTD
,      CAPITAL_BURDENED_COST_QTD
,      LABOR_RAW_COST_QTD
,      LABOR_BRDN_COST_QTD
,      LABOR_HOURS_QTD
,      LABOR_REVENUE_QTD
,      EQUIPMENT_HOURS_QTD
,      BILLABLE_EQUIPMENT_HOURS_QTD
,      SUP_INV_COMMITTED_COST_QTD
,      PO_COMMITTED_COST_QTD
,      PR_COMMITTED_COST_QTD
,      OTH_COMMITTED_COST_QTD
,      CMT_BURDENED_COST_QTD
,      BILLABLE_QUANTITY_QTD
,      BILLABLE_LABOR_HOURS_QTD
,      CMT_QUANTITY_QTD
,      LABOR_HRS_QTD
,      QUANTITY_QTD
,      REVENUE_YTD
,      RAW_COST_YTD
,      BURDENED_COST_YTD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_BURDENED_COST_YTD
,      BILL_LABOR_RAW_COST_YTD
,      BILL_LABOR_BRDN_COST_YTD
,      BILL_LABOR_HRS_YTD
,      EQUIPMENT_RAW_COST_YTD
,      EQUIPMENT_BRDN_COST_YTD
,      CAPITAL_RAW_COST_YTD
,      CAPITAL_BURDENED_COST_YTD
,      LABOR_RAW_COST_YTD
,      LABOR_BRDN_COST_YTD
,      LABOR_HOURS_YTD
,      LABOR_REVENUE_YTD
,      EQUIPMENT_HOURS_YTD
,      BILLABLE_EQUIPMENT_HOURS_YTD
,      SUP_INV_COMMITTED_COST_YTD
,      PO_COMMITTED_COST_YTD
,      PR_COMMITTED_COST_YTD
,      OTH_COMMITTED_COST_YTD
,      CMT_BURDENED_COST_YTD
,      BILLABLE_QUANTITY_YTD
,      BILLABLE_LABOR_HOURS_YTD
,      CMT_QUANTITY_YTD
,      LABOR_HRS_YTD
,      QUANTITY_YTD
,      REVENUE_ITD
,      RAW_COST_ITD
,      BURDENED_COST_ITD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_BURDENED_COST_ITD
,      BILL_LABOR_RAW_COST_ITD
,      BILL_LABOR_BRDN_COST_ITD
,      BILL_LABOR_HRS_ITD
,      EQUIPMENT_RAW_COST_ITD
,      EQUIPMENT_BRDN_COST_ITD
,      CAPITAL_RAW_COST_ITD
,      CAPITAL_BURDENED_COST_ITD
,      LABOR_RAW_COST_ITD
,      LABOR_BRDN_COST_ITD
,      LABOR_HOURS_ITD
,      LABOR_REVENUE_ITD
,      EQUIPMENT_HOURS_ITD
,      BILLABLE_EQUIPMENT_HOURS_ITD
,      SUP_INV_COMMITTED_COST_ITD
,      PO_COMMITTED_COST_ITD
,      PR_COMMITTED_COST_ITD
,      OTH_COMMITTED_COST_ITD
,      CMT_BURDENED_COST_ITD
,      BILLABLE_QUANTITY_ITD
,      BILLABLE_LABOR_HOURS_ITD
,      CMT_QUANTITY_ITD
,      LABOR_HRS_ITD
,      QUANTITY_ITD
FROM APPS.PJI_XTD_ACT_CMT_BY_RSRC_V;

Dependencies

[top of page]

APPS.PJI_XTD_ACT_CMT_BY_RSRC_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPJI_FP_XBS_ACCUM_F
SynonymPJI_ORG_EXTR_INFO
ViewPJI_TIME_CAL_PERIOD_V
ViewPJI_TIME_CAL_RPT_STRUCT_V

APPS.PJI_XTD_ACT_CMT_BY_RSRC_V is not referenced by any database object