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

VIEW: APPS.PJI_PRD_ACT_CMT_BY_TASK_V

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

View Type

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


PJI_PRD_ACT_CMT_BY_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task. 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
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)
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
,      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_TASK_V;

Dependencies

[top of page]

APPS.PJI_PRD_ACT_CMT_BY_TASK_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPJI_FP_XBS_ACCUM_F
ViewPJI_TIME_CAL_PERIOD_V

APPS.PJI_PRD_ACT_CMT_BY_TASK_V is not referenced by any database object