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

VIEW: APPS.PJI_ACT_CMT_BY_PERIOD_V

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

View Type

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


PJI_ACT_CMT_BY_PERIOD_V is a view that displays actual cost, revenue totals, and commitment for lowest level tasks and resources by PA, and GL periods. 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
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
RBS_ELEMENT_ID NUMBER (15) Yes Identifier for the RBS (New column has been added to replace Resource List Member Id in PSI model)
RBS_VERSION_ID NUMBER (15)
Identifier for the RBS version (New column has been added to replace Resource List Id in PSI model)
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
QUANTITY NUMBER

Quantity (This column is now pointing to Labor Hours for backward compatibility)
BILLABLE_QUANTITY NUMBER

Billable Quantity (this column is now pointing to Bill_Labor_Hrs for backward compatibility)
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

Billable 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 (This column is now pointing to the Labor Hours for backward compatibility)
SUP_INV_COMMITTED_COST NUMBER

Derived from cost based on commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST NUMBER

Derived from cost based on commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST NUMBER

Derived from the cost based on commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST NUMBER

Cost based on commitments other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST NUMBER

Total Commitment Burdened Cost (This column is now pointing to the sum of all the commitment costs in fact table for backward compatibility)
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      REVENUE
,      RAW_COST
,      CAPITAL_RAW_COST
,      BURDENED_COST
,      CAPITAL_BURDENED_COST
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      CALENDAR_TYPE
,      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_ACT_CMT_BY_PERIOD_V;

Dependencies

[top of page]

APPS.PJI_ACT_CMT_BY_PERIOD_V references the following:

SchemaAPPS
ViewPJI_PRD_ACT_CMT_BY_RSRC_V

APPS.PJI_ACT_CMT_BY_PERIOD_V is not referenced by any database object