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

VIEW: APPS.PJI_XTD_PLN_BY_RSRC_V

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

View Type

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


PJI_XTD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task, and resource. 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_VERSION_ID NUMBER (15)
Identifier for the RBS version (New column added to replace Resource List Id)
RBS_ELEMENT_ID NUMBER (15) Yes Identifier for the RBS (New column added to replace Resource List Member 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_PTD NUMBER

Revenue PTD
RAW_COST_PTD NUMBER

Raw Cost PTD
BURDENED_COST_PTD NUMBER

Burdened Cost PTD
BILLABLE_RAW_COST_PTD NUMBER

Billable Raw Cost PTD
BILLABLE_BURDENED_COST_PTD NUMBER

Billable Burdened Raw Cost PTD
BILL_LABOR_RAW_COST_PTD NUMBER

Billable Labor Raw Cost PTD
BILL_LABOR_BRDN_COST_PTD NUMBER

Billable Labor Burdened Cost PTD
BILL_LABOR_HRS_PTD NUMBER

Billable Labor Hours PTD
EQUIPMENT_RAW_COST_PTD NUMBER

Equipment Raw Cost PTD
EQUIPMENT_BRDN_COST_PTD NUMBER

Equipment Burdened PTD
CAPITAL_RAW_COST_PTD NUMBER

Capital Raw Cost PTD
CAPITAL_BURDENED_COST_PTD NUMBER

Capital Burdened Cost PTD
LABOR_RAW_COST_PTD NUMBER

Labor Raw Cost PTD
LABOR_BRDN_COST_PTD NUMBER

Labor Burdened Cost PTD
LABOR_HOURS_PTD NUMBER

Labor Hours PTD
LABOR_REVENUE_PTD NUMBER

Labor Revenue PTD
EQUIPMENT_HOURS_PTD NUMBER

Equipment Hours PTD
BILLABLE_EQUIPMENT_HOURS_PTD NUMBER

Billable Equipment Hours PTD
SUP_INV_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_PTD NUMBER

PTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_PTD NUMBER

Commitments PTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_PTD NUMBER

Commitment Burdened Cost PTD
BILLABLE_QUANTITY_PTD NUMBER

Billable Quantity PTD
BILLABLE_LABOR_HOURS_PTD NUMBER

Billable Labor Hours PTD
CMT_QUANTITY_PTD NUMBER

Commitment Quantity PTD
LABOR_HRS_PTD NUMBER

Labor Hours PTD
QUANTITY_PTD NUMBER

Quantity PTD
ACT_LABOR_HRS_PTD NUMBER

Actual Labor Hours PTD
ACT_EQUIP_HRS_PTD NUMBER

Actual Equipment Hours PTD
ACT_LABOR_BRDN_COST_PTD NUMBER

Actual Labor Burdened Cost PTD
ACT_EQUIP_BRDN_COST_PTD NUMBER

Actual Equipment Burdened Cost PTD
ACT_BRDN_COST_PTD NUMBER

Actual Burdened Cost PTD
ACT_RAW_COST_PTD NUMBER

Actual Raw Cost PTD
ACT_REVENUE_PTD NUMBER

Actual Revenue PTD
ETC_LABOR_HRS_PTD NUMBER

ETC Labor Hours PTD
ETC_EQUIP_HRS_PTD NUMBER

ETC Equipment Hours PTD
ETC_LABOR_BRDN_COST_PTD NUMBER

ETC Labor Burdened Cost PTD
ETC_EQUIP_BRDN_COST_PTD NUMBER

ETC Equipment Burdened Cost PTD
ETC_BRDN_COST_PTD NUMBER

ETC Burdened Cost PTD
ETC_RAW_COST_PTD NUMBER

ETC Raw Cost PTD
ACT_LABOR_RAW_COST_PTD NUMBER

Actual Labor Raw Cost PTD
ACT_EQUIP_RAW_COST_PTD NUMBER

Actual Equipment Raw Cost PTD
ETC_LABOR_RAW_COST_PTD NUMBER

ETC Labor Raw Cost PTD
ETC_EQUIP_RAW_COST_PTD NUMBER

ETC Equipment Raw Cost PTD
REVENUE_QTD NUMBER

Revenue QTD
RAW_COST_QTD NUMBER

Raw Cost QTD
BURDENED_COST_QTD NUMBER

Burdened Cost QTD
BILLABLE_RAW_COST_QTD NUMBER

Billable Raw Cost QTD
BILLABLE_BURDENED_COST_QTD NUMBER

Billable Burdened Raw Cost QTD
BILL_LABOR_RAW_COST_QTD NUMBER

Billable Labor Raw Cost QTD
BILL_LABOR_BRDN_COST_QTD NUMBER

Billable Labor Burdened Cost QTD
BILL_LABOR_HRS_QTD NUMBER

Billable Labor Hours QTD
EQUIPMENT_RAW_COST_QTD NUMBER

Equipment Raw Cost QTD
EQUIPMENT_BRDN_COST_QTD NUMBER

Equipment Burdened QTD
CAPITAL_RAW_COST_QTD NUMBER

Capital Raw Cost QTD
CAPITAL_BURDENED_COST_QTD NUMBER

Capital Burdened Cost QTD
LABOR_RAW_COST_QTD NUMBER

Labor Raw Cost QTD
LABOR_BRDN_COST_QTD NUMBER

Labor Burdened Cost QTD
LABOR_HOURS_QTD NUMBER

Labor Hours QTD
LABOR_REVENUE_QTD NUMBER

Labor Revenue QTD
EQUIPMENT_HOURS_QTD NUMBER

Equipment Hours QTD
BILLABLE_EQUIPMENT_HOURS_QTD NUMBER

Billable Equipment Hours QTD
SUP_INV_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_QTD NUMBER

QTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_QTD NUMBER

Commitments QTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_QTD NUMBER

Commitment Burdened Cost QTD
BILLABLE_QUANTITY_QTD NUMBER

Billable Quantity QTD
BILLABLE_LABOR_HOURS_QTD NUMBER

Billable Labor Hours QTD
CMT_QUANTITY_QTD NUMBER

Commitment Quantity QTD
LABOR_HRS_QTD NUMBER

Labor Hours QTD
QUANTITY_QTD NUMBER

Quantity QTD
ACT_LABOR_HRS_QTD NUMBER

Actual Labor Hours QTD
ACT_EQUIP_HRS_QTD NUMBER

Actual Equipment Hours QTD
ACT_LABOR_BRDN_COST_QTD NUMBER

Actual Labor Burdened Cost QTD
ACT_EQUIP_BRDN_COST_QTD NUMBER

Actual Equipment Burdened Cost QTD
ACT_BRDN_COST_QTD NUMBER

Actual Burdened Cost QTD
ACT_RAW_COST_QTD NUMBER

Actual Raw Cost QTD
ACT_REVENUE_QTD NUMBER

Actual Revenue QTD
ETC_LABOR_HRS_QTD NUMBER

ETC Labor Hours QTD
ETC_EQUIP_HRS_QTD NUMBER

ETC Equipment Hours QTD
ETC_LABOR_BRDN_COST_QTD NUMBER

ETC Labor Burdened Cost QTD
ETC_EQUIP_BRDN_COST_QTD NUMBER

ETC Equipment Burdened Cost QTD
ETC_BRDN_COST_QTD NUMBER

ETC Burdened Cost QTD
ETC_RAW_COST_QTD NUMBER

ETC Raw Cost QTD
ACT_LABOR_RAW_COST_QTD NUMBER

Actual Labor Raw Cost QTD
ACT_EQUIP_RAW_COST_QTD NUMBER

Actual Equipment Raw Cost QTD
ETC_LABOR_RAW_COST_QTD NUMBER

ETC Labor Raw Cost QTD
ETC_EQUIP_RAW_COST_QTD NUMBER

ETC Equipment Raw Cost QTD
REVENUE_YTD NUMBER

Revenue YTD
RAW_COST_YTD NUMBER

Raw Cost YTD
BURDENED_COST_YTD NUMBER

Burdened Cost YTD
BILLABLE_RAW_COST_YTD NUMBER

Billable Raw Cost YTD
BILLABLE_BURDENED_COST_YTD NUMBER

Billable Burdened Raw Cost YTD
BILL_LABOR_RAW_COST_YTD NUMBER

Billable Labor Raw Cost YTD
BILL_LABOR_BRDN_COST_YTD NUMBER

Billable Labor Burdened Cost YTD
BILL_LABOR_HRS_YTD NUMBER

Billable Labor Hours YTD
EQUIPMENT_RAW_COST_YTD NUMBER

Equipment Raw Cost YTD
EQUIPMENT_BRDN_COST_YTD NUMBER

Equipment Burdened YTD
CAPITAL_RAW_COST_YTD NUMBER

Capital Raw Cost YTD
CAPITAL_BURDENED_COST_YTD NUMBER

Capital Burdened Cost YTD
LABOR_RAW_COST_YTD NUMBER

Labor Raw Cost YTD
LABOR_BRDN_COST_YTD NUMBER

Labor Burdened Cost YTD
LABOR_HOURS_YTD NUMBER

Labor Hours YTD
LABOR_REVENUE_YTD NUMBER

Labor Revenue YTD
EQUIPMENT_HOURS_YTD NUMBER

Equipment Hours YTD
BILLABLE_EQUIPMENT_HOURS_YTD NUMBER

Billable Equipment Hours YTD
SUP_INV_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_YTD NUMBER

YTD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_YTD NUMBER

Commitments YTD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_YTD NUMBER

Commitment Burdened Cost YTD
BILLABLE_QUANTITY_YTD NUMBER

Billable Quantity YTD
BILLABLE_LABOR_HOURS_YTD NUMBER

Billable Labor Hours YTD
CMT_QUANTITY_YTD NUMBER

Commitment Quantity YTD
LABOR_HRS_YTD NUMBER

Labor Hours YTD
QUANTITY_YTD NUMBER

Quantity YTD
ACT_LABOR_HRS_YTD NUMBER

Actual Labor Hours YTD
ACT_EQUIP_HRS_YTD NUMBER

Actual Equipment Hours YTD
ACT_LABOR_BRDN_COST_YTD NUMBER

Actual Labor Burdened Cost YTD
ACT_EQUIP_BRDN_COST_YTD NUMBER

Actual Equipment Burdened Cost YTD
ACT_BRDN_COST_YTD NUMBER

Actual Burdened Cost YTD
ACT_RAW_COST_YTD NUMBER

Actual Raw Cost YTD
ACT_REVENUE_YTD NUMBER

Actual Revenue YTD
ETC_LABOR_HRS_YTD NUMBER

ETC Labor Hours YTD
ETC_EQUIP_HRS_YTD NUMBER

ETC Equipment Hours YTD
ETC_LABOR_BRDN_COST_YTD NUMBER

ETC Labor Burdened Cost YTD
ETC_EQUIP_BRDN_COST_YTD NUMBER

ETC Equipment Burdened Cost YTD
ETC_BRDN_COST_YTD NUMBER

ETC Burdened Cost YTD
ETC_RAW_COST_YTD NUMBER

ETC Raw Cost YTD
ACT_LABOR_RAW_COST_YTD NUMBER

Actual Labor Raw Cost YTD
ACT_EQUIP_RAW_COST_YTD NUMBER

Actual Equipment Raw Cost YTD
ETC_LABOR_RAW_COST_YTD NUMBER

ETC Labor Raw Cost YTD
ETC_EQUIP_RAW_COST_YTD NUMBER

ETC Equipment Raw Cost YTD
REVENUE_ITD NUMBER

Revenue ITD
RAW_COST_ITD NUMBER

Raw Cost ITD
BURDENED_COST_ITD NUMBER

Burdened Cost ITD
BILLABLE_RAW_COST_ITD NUMBER

Billable Raw Cost ITD
BILLABLE_BURDENED_COST_ITD NUMBER

Billable Burdened Raw Cost ITD
BILL_LABOR_RAW_COST_ITD NUMBER

Billable Labor Raw Cost ITD
BILL_LABOR_BRDN_COST_ITD NUMBER

Billable Labor Burdened Cost ITD
BILL_LABOR_HRS_ITD NUMBER

Billable Labor Hours ITD
EQUIPMENT_RAW_COST_ITD NUMBER

Equipment Raw Cost ITD
EQUIPMENT_BRDN_COST_ITD NUMBER

Equipment Burdened ITD
CAPITAL_RAW_COST_ITD NUMBER

Capital Raw Cost ITD
CAPITAL_BURDENED_COST_ITD NUMBER

Capital Burdened Cost ITD
LABOR_RAW_COST_ITD NUMBER

Labor Raw Cost ITD
LABOR_BRDN_COST_ITD NUMBER

Labor Burdened Cost ITD
LABOR_HOURS_ITD NUMBER

Labor Hours ITD
LABOR_REVENUE_ITD NUMBER

Labor Revenue ITD
EQUIPMENT_HOURS_ITD NUMBER

Equipment Hours ITD
BILLABLE_EQUIPMENT_HOURS_ITD NUMBER

Billable Equipment Hours ITD
SUP_INV_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Supplier Invoice
PO_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Purchase Order
PR_COMMITTED_COST_ITD NUMBER

ITD Derived based on Commitments with Commitment Type = Purchase Requisition
OTH_COMMITTED_COST_ITD NUMBER

Commitments ITD other than Supplier Invoices, Purchase Orders or Purchase Requisitions
CMT_BURDENED_COST_ITD NUMBER

Commitment Burdened Cost ITD
BILLABLE_QUANTITY_ITD NUMBER

Billable Quantity ITD
BILLABLE_LABOR_HOURS_ITD NUMBER

Billable Labor Hours ITD
CMT_QUANTITY_ITD NUMBER

Commitment Quantity ITD
LABOR_HRS_ITD NUMBER

Labor Hours ITD
QUANTITY_ITD NUMBER

Quantity ITD
ACT_LABOR_HRS_ITD NUMBER

Actual Labor Hours ITD
ACT_EQUIP_HRS_ITD NUMBER

Actual Equipment Hours ITD
ACT_LABOR_BRDN_COST_ITD NUMBER

Actual Labor Burdened Cost ITD
ACT_EQUIP_BRDN_COST_ITD NUMBER

Actual Equipment Burdened Cost ITD
ACT_BRDN_COST_ITD NUMBER

Actual Burdened Cost ITD
ACT_RAW_COST_ITD NUMBER

Actual Raw Cost ITD
ACT_REVENUE_ITD NUMBER

Actual Revenue ITD
ETC_LABOR_HRS_ITD NUMBER

ETC Labor Hours ITD
ETC_EQUIP_HRS_ITD NUMBER

ETC Equipment Hours ITD
ETC_LABOR_BRDN_COST_ITD NUMBER

ETC Labor Burdened Cost ITD
ETC_EQUIP_BRDN_COST_ITD NUMBER

ETC Equipment Burdened Cost ITD
ETC_BRDN_COST_ITD NUMBER

ETC Burdened Cost ITD
ETC_RAW_COST_ITD NUMBER

ETC Raw Cost ITD
ACT_LABOR_RAW_COST_ITD NUMBER

Actual Labor Raw Cost ITD
ACT_EQUIP_RAW_COST_ITD NUMBER

Actual Equipment Raw Cost ITD
ETC_LABOR_RAW_COST_ITD NUMBER

ETC Labor Raw Cost ITD
ETC_EQUIP_RAW_COST_ITD NUMBER

ETC Equipment Raw Cost ITD
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_VERSION_ID
,      RBS_ELEMENT_ID
,      PLAN_TYPE_ID
,      PLAN_VERSION_ID
,      REVENUE_PTD
,      RAW_COST_PTD
,      BURDENED_COST_PTD
,      BILLABLE_RAW_COST_PTD
,      BILLABLE_BURDENED_COST_PTD
,      BILL_LABOR_RAW_COST_PTD
,      BILL_LABOR_BRDN_COST_PTD
,      BILL_LABOR_HRS_PTD
,      EQUIPMENT_RAW_COST_PTD
,      EQUIPMENT_BRDN_COST_PTD
,      CAPITAL_RAW_COST_PTD
,      CAPITAL_BURDENED_COST_PTD
,      LABOR_RAW_COST_PTD
,      LABOR_BRDN_COST_PTD
,      LABOR_HOURS_PTD
,      LABOR_REVENUE_PTD
,      EQUIPMENT_HOURS_PTD
,      BILLABLE_EQUIPMENT_HOURS_PTD
,      SUP_INV_COMMITTED_COST_PTD
,      PO_COMMITTED_COST_PTD
,      PR_COMMITTED_COST_PTD
,      OTH_COMMITTED_COST_PTD
,      CMT_BURDENED_COST_PTD
,      BILLABLE_QUANTITY_PTD
,      BILLABLE_LABOR_HOURS_PTD
,      CMT_QUANTITY_PTD
,      LABOR_HRS_PTD
,      QUANTITY_PTD
,      ACT_LABOR_HRS_PTD
,      ACT_EQUIP_HRS_PTD
,      ACT_LABOR_BRDN_COST_PTD
,      ACT_EQUIP_BRDN_COST_PTD
,      ACT_BRDN_COST_PTD
,      ACT_RAW_COST_PTD
,      ACT_REVENUE_PTD
,      ETC_LABOR_HRS_PTD
,      ETC_EQUIP_HRS_PTD
,      ETC_LABOR_BRDN_COST_PTD
,      ETC_EQUIP_BRDN_COST_PTD
,      ETC_BRDN_COST_PTD
,      ETC_RAW_COST_PTD
,      ACT_LABOR_RAW_COST_PTD
,      ACT_EQUIP_RAW_COST_PTD
,      ETC_LABOR_RAW_COST_PTD
,      ETC_EQUIP_RAW_COST_PTD
,      REVENUE_QTD
,      RAW_COST_QTD
,      BURDENED_COST_QTD
,      BILLABLE_RAW_COST_QTD
,      BILLABLE_BURDENED_COST_QTD
,      BILL_LABOR_RAW_COST_QTD
,      BILL_LABOR_BRDN_COST_QTD
,      BILL_LABOR_HRS_QTD
,      EQUIPMENT_RAW_COST_QTD
,      EQUIPMENT_BRDN_COST_QTD
,      CAPITAL_RAW_COST_QTD
,      CAPITAL_BURDENED_COST_QTD
,      LABOR_RAW_COST_QTD
,      LABOR_BRDN_COST_QTD
,      LABOR_HOURS_QTD
,      LABOR_REVENUE_QTD
,      EQUIPMENT_HOURS_QTD
,      BILLABLE_EQUIPMENT_HOURS_QTD
,      SUP_INV_COMMITTED_COST_QTD
,      PO_COMMITTED_COST_QTD
,      PR_COMMITTED_COST_QTD
,      OTH_COMMITTED_COST_QTD
,      CMT_BURDENED_COST_QTD
,      BILLABLE_QUANTITY_QTD
,      BILLABLE_LABOR_HOURS_QTD
,      CMT_QUANTITY_QTD
,      LABOR_HRS_QTD
,      QUANTITY_QTD
,      ACT_LABOR_HRS_QTD
,      ACT_EQUIP_HRS_QTD
,      ACT_LABOR_BRDN_COST_QTD
,      ACT_EQUIP_BRDN_COST_QTD
,      ACT_BRDN_COST_QTD
,      ACT_RAW_COST_QTD
,      ACT_REVENUE_QTD
,      ETC_LABOR_HRS_QTD
,      ETC_EQUIP_HRS_QTD
,      ETC_LABOR_BRDN_COST_QTD
,      ETC_EQUIP_BRDN_COST_QTD
,      ETC_BRDN_COST_QTD
,      ETC_RAW_COST_QTD
,      ACT_LABOR_RAW_COST_QTD
,      ACT_EQUIP_RAW_COST_QTD
,      ETC_LABOR_RAW_COST_QTD
,      ETC_EQUIP_RAW_COST_QTD
,      REVENUE_YTD
,      RAW_COST_YTD
,      BURDENED_COST_YTD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_BURDENED_COST_YTD
,      BILL_LABOR_RAW_COST_YTD
,      BILL_LABOR_BRDN_COST_YTD
,      BILL_LABOR_HRS_YTD
,      EQUIPMENT_RAW_COST_YTD
,      EQUIPMENT_BRDN_COST_YTD
,      CAPITAL_RAW_COST_YTD
,      CAPITAL_BURDENED_COST_YTD
,      LABOR_RAW_COST_YTD
,      LABOR_BRDN_COST_YTD
,      LABOR_HOURS_YTD
,      LABOR_REVENUE_YTD
,      EQUIPMENT_HOURS_YTD
,      BILLABLE_EQUIPMENT_HOURS_YTD
,      SUP_INV_COMMITTED_COST_YTD
,      PO_COMMITTED_COST_YTD
,      PR_COMMITTED_COST_YTD
,      OTH_COMMITTED_COST_YTD
,      CMT_BURDENED_COST_YTD
,      BILLABLE_QUANTITY_YTD
,      BILLABLE_LABOR_HOURS_YTD
,      CMT_QUANTITY_YTD
,      LABOR_HRS_YTD
,      QUANTITY_YTD
,      ACT_LABOR_HRS_YTD
,      ACT_EQUIP_HRS_YTD
,      ACT_LABOR_BRDN_COST_YTD
,      ACT_EQUIP_BRDN_COST_YTD
,      ACT_BRDN_COST_YTD
,      ACT_RAW_COST_YTD
,      ACT_REVENUE_YTD
,      ETC_LABOR_HRS_YTD
,      ETC_EQUIP_HRS_YTD
,      ETC_LABOR_BRDN_COST_YTD
,      ETC_EQUIP_BRDN_COST_YTD
,      ETC_BRDN_COST_YTD
,      ETC_RAW_COST_YTD
,      ACT_LABOR_RAW_COST_YTD
,      ACT_EQUIP_RAW_COST_YTD
,      ETC_LABOR_RAW_COST_YTD
,      ETC_EQUIP_RAW_COST_YTD
,      REVENUE_ITD
,      RAW_COST_ITD
,      BURDENED_COST_ITD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_BURDENED_COST_ITD
,      BILL_LABOR_RAW_COST_ITD
,      BILL_LABOR_BRDN_COST_ITD
,      BILL_LABOR_HRS_ITD
,      EQUIPMENT_RAW_COST_ITD
,      EQUIPMENT_BRDN_COST_ITD
,      CAPITAL_RAW_COST_ITD
,      CAPITAL_BURDENED_COST_ITD
,      LABOR_RAW_COST_ITD
,      LABOR_BRDN_COST_ITD
,      LABOR_HOURS_ITD
,      LABOR_REVENUE_ITD
,      EQUIPMENT_HOURS_ITD
,      BILLABLE_EQUIPMENT_HOURS_ITD
,      SUP_INV_COMMITTED_COST_ITD
,      PO_COMMITTED_COST_ITD
,      PR_COMMITTED_COST_ITD
,      OTH_COMMITTED_COST_ITD
,      CMT_BURDENED_COST_ITD
,      BILLABLE_QUANTITY_ITD
,      BILLABLE_LABOR_HOURS_ITD
,      CMT_QUANTITY_ITD
,      LABOR_HRS_ITD
,      QUANTITY_ITD
,      ACT_LABOR_HRS_ITD
,      ACT_EQUIP_HRS_ITD
,      ACT_LABOR_BRDN_COST_ITD
,      ACT_EQUIP_BRDN_COST_ITD
,      ACT_BRDN_COST_ITD
,      ACT_RAW_COST_ITD
,      ACT_REVENUE_ITD
,      ETC_LABOR_HRS_ITD
,      ETC_EQUIP_HRS_ITD
,      ETC_LABOR_BRDN_COST_ITD
,      ETC_EQUIP_BRDN_COST_ITD
,      ETC_BRDN_COST_ITD
,      ETC_RAW_COST_ITD
,      ACT_LABOR_RAW_COST_ITD
,      ACT_EQUIP_RAW_COST_ITD
,      ETC_LABOR_RAW_COST_ITD
,      ETC_EQUIP_RAW_COST_ITD
FROM APPS.PJI_XTD_PLN_BY_RSRC_V;

Dependencies

[top of page]

APPS.PJI_XTD_PLN_BY_RSRC_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPJI_FP_XBS_ACCUM_F
SynonymPJI_ORG_EXTR_INFO
ViewPJI_TIME_CAL_PERIOD_V
ViewPJI_TIME_CAL_RPT_STRUCT_V

APPS.PJI_XTD_PLN_BY_RSRC_V is not referenced by any database object