eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PJI_AC_PLN_BY_RSRC_V

Object Details

Object Name:	PJI_AC_PLN_BY_RSRC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_AC_PLN_BY_RSRC_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
RBS_ELEMENT_ID	NUMBER	(15)	Yes	Identifier for the RBS
RBS_VERSION_ID	NUMBER	(15)		Identifier for the RBS version
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
BILLABLE_QUANTITY	NUMBER			Billable Quantity
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
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
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      TASK_ID
,      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_AC_PLN_BY_RSRC_V;

Dependencies

[top of page]

APPS.PJI_AC_PLN_BY_RSRC_V references the following:

APPS: PA_PROJECTS_ALL; PJI_FP_XBS_ACCUM_F

APPS.PJI_AC_PLN_BY_RSRC_V is not referenced by any database object