[Home] [Help] [Dependency Information]
Object Name: | PJI_ACT_CMT_BY_PERIOD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJI.PJI_ACT_CMT_BY_PERIOD_V |
Subobject Name: | |
Status: | VALID |
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
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) |
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;
APPS.PJI_ACT_CMT_BY_PERIOD_V is not referenced by any database object
|
|
|