[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJI_PRD_PLN_BY_RSRC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PJI.PJI_PRD_PLN_BY_RSRC_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This new PSI view is to provide PSI functionality using new summarization model.Full Description :PJI_PRD_PLN_BY_RSRC_V is a view that displays budget costand revenue totals for PA, and GL periods by task, and resources. The view is mainly used by external project management systems that import actuals fromOracle Projects.
| 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_ELEMENT_ID | NUMBER | (15) | Yes | Identifier for the RBS (New column added to replace Resource List Member Id) |
| RBS_VERSION_ID | NUMBER | (15) | Identifier for the RBS version (New column added to replace Resource List Id) | |
| PLAN_TYPE_ID | NUMBER | (15) | Yes | Identifier of the Plan Type |
| PLAN_VERSION_ID | NUMBER | (15) | Yes | Identifier of the Plan Version Id |
| 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 (Existing column now pointing to Labor hour for backward compatibility) | ||
| BILLABLE_QUANTITY | NUMBER | Billable Labor Hours | ||
| 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 (Existing column now pointing to Labor hour for backward compatibility) | ||
| 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 (Existing column now pointing to the sum of all the commitment costs in fact table for backward compatibility) | ||
| ACT_LABOR_HRS | NUMBER | Actual Labor Hours | ||
| ACT_EQUIP_HRS | NUMBER | Actual Equipment Hours | ||
| ACT_LABOR_BRDN_COST | NUMBER | Actual Labor Burdened Cost | ||
| ACT_EQUIP_BRDN_COST | NUMBER | Actual Equipment Burdened Cost | ||
| ACT_BRDN_COST | NUMBER | Actual Burdened Cost | ||
| ACT_RAW_COST | NUMBER | Actual Raw Cost | ||
| ACT_REVENUE | NUMBER | Actual Revenue | ||
| ETC_LABOR_HRS | NUMBER | ETC Labor Hours | ||
| ETC_EQUIP_HRS | NUMBER | ETC Equipment Hours | ||
| ETC_LABOR_BRDN_COST | NUMBER | ETC Labor Burdened Cost | ||
| ETC_EQUIP_BRDN_COST | NUMBER | ETC Equipment Burdened Cost | ||
| ETC_BRDN_COST | NUMBER | ETC Burdened Cost | ||
| ETC_RAW_COST | NUMBER | ETC Raw Cost | ||
| ACT_LABOR_RAW_COST | NUMBER | Actual Labor Raw Cost | ||
| ACT_EQUIP_RAW_COST | NUMBER | Actual Equipment Raw Cost | ||
| ETC_LABOR_RAW_COST | NUMBER | ETC Labor Raw Cost | ||
| ETC_EQUIP_RAW_COST | NUMBER | ETC Equipment Raw Cost |
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_ELEMENT_ID
, RBS_VERSION_ID
, PLAN_TYPE_ID
, PLAN_VERSION_ID
, 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
, ACT_LABOR_HRS
, ACT_EQUIP_HRS
, ACT_LABOR_BRDN_COST
, ACT_EQUIP_BRDN_COST
, ACT_BRDN_COST
, ACT_RAW_COST
, ACT_REVENUE
, ETC_LABOR_HRS
, ETC_EQUIP_HRS
, ETC_LABOR_BRDN_COST
, ETC_EQUIP_BRDN_COST
, ETC_BRDN_COST
, ETC_RAW_COST
, ACT_LABOR_RAW_COST
, ACT_EQUIP_RAW_COST
, ETC_LABOR_RAW_COST
, ETC_EQUIP_RAW_COST
FROM APPS.PJI_PRD_PLN_BY_RSRC_V;
APPS
PA_PROJECTS_ALL
PJI_FP_XBS_ACCUM_F
PJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_PLN_BY_RSRC_V is not referenced by any database object
|
|
|
|