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

VIEW: APPS.PJI_AC_PLN_BY_TASK_V

Object Details
Object Name: PJI_AC_PLN_BY_TASK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_AC_PLN_BY_TASK_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
PLAN_TYPE_ID NUMBER (15) Yes Identifier of the Plan Type
PLAN_VERSION_ID NUMBER (15) Yes Identifier of the Plan Version
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
,      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_TASK_V;

Dependencies

[top of page]

APPS.PJI_AC_PLN_BY_TASK_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPJI_FP_XBS_ACCUM_F

APPS.PJI_AC_PLN_BY_TASK_V is not referenced by any database object