[Home] [Help] [Dependency Information]
Object Name: | PJI_XTD_PLN_BY_TASK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJI.PJI_XTD_PLN_BY_TASK_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PJI_XTD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task. 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 |
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 | |
PLAN_TYPE_ID | NUMBER | (15) | Yes | Identifier of the Plan Type |
PLAN_VERSION_ID | NUMBER | (15) | Yes | Identifier of the Plan Version |
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 |
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
, 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_TASK_V;
APPS.PJI_XTD_PLN_BY_TASK_V is not referenced by any database object
|
|
|