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

VIEW: APPS.PJI_PRD_ACT_CMT_BY_RSRC_V

Object Details
Object Name: PJI_PRD_ACT_CMT_BY_RSRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_PRD_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_PRD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PA, and GL periods by task, and resources. 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_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)
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 hours for backward compatibility)
BILLABLE_QUANTITY NUMBER

Billable Quantity (existing column 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

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 hours 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)
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_ELEMENT_ID
,      RBS_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
FROM APPS.PJI_PRD_ACT_CMT_BY_RSRC_V;

Dependencies

[top of page]

APPS.PJI_PRD_ACT_CMT_BY_RSRC_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPJI_FP_XBS_ACCUM_F
ViewPJI_TIME_CAL_PERIOD_V
APPS.PJI_PRD_ACT_CMT_BY_RSRC_V is referenced by following:

SchemaAPPS
ViewPJI_ACT_CMT_BY_PERIOD_V