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

VIEW: APPS.PA_PLAN_ACTUALS_FACT_V

Object Details
Object Name: PA_PLAN_ACTUALS_FACT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ORG_ID NUMBER (15) Yes Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID NUMBER (15) Yes Identifier of the Project Organization
PROJECT_ELEMENT_ID NUMBER (15) Yes This is the WBS element id and consists of projects and tasks.
TIME_ID NUMBER (15) Yes Numeric identifier for time
PERIOD_TYPE_ID NUMBER (15) Yes Numeric identifier for the period type (period, quarter, year, weeks)
CALENDAR_TYPE VARCHAR2 (1) Yes Specifies the calendar type (PA, GL, Enterprise)
RBS_AGGR_LEVEL VARCHAR2 (1) Yes Indicates, for the current task, the type of RBS aggregation. L = Lowest (data extracted from the transaction system) R = Rollup (date rollup up by RBS)T = Top (Common amount that is the sum total of a given RBS structure for the current task.)
WBS_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not.N = No (Task self amounts.) Y = Yes (Task amounts rolled up by WBS. Rolled up amounts do not include self amounts.)
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates whether the amounts are rolled up by Project Hierarchy or not. N = No (Amounts within a given project.) Y = Yes (Project structure version amounts rolled up by Project Hierarchy. Rolled up amounts do not include self amounts.)
CURR_RECORD_TYPE_ID NUMBER (15) Yes Identifier for the Currency record type
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
RBS_ELEMENT_ID NUMBER (15) Yes Identifier for the RBS
RBS_VERSION_ID NUMBER (15)
Identifier for the RBS version
PLAN_VERSION_ID NUMBER (15) Yes Same as Budget version identifier. >0 = version id, -1 = Actuals, -2 = Progress Actuals, -3 = Current Baselined, -4 = Current Original Baselined
PLAN_TYPE_ID NUMBER (15) Yes Identifier of the Plan Type
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
RAW_COST NUMBER

Transaction Raw Cost
BRDN_COST NUMBER

Transaction Burdened Cost
REVENUE NUMBER

Transaction Revenue
BILL_RAW_COST NUMBER

Billable Raw Cost
BILL_BRDN_COST NUMBER

Billable Burdened Cost
BILL_LABOR_RAW_COST NUMBER

Billable Labor Raw Cost
BILL_LABOR_BRDN_COST NUMBER

Billable Labor Burdened Cost
BILL_LABOR_HRS NUMBER

Billable Labor Hours
EQUIPMENT_RAW_COST NUMBER

Equipment Raw Cost
EQUIPMENT_BRDN_COST NUMBER

Equipment Burdened Cost
CAPITALIZABLE_RAW_COST NUMBER

Capitalizable Raw Cost
CAPITALIZABLE_BRDN_COST NUMBER

Capitalizable Burdened Cost
LABOR_RAW_COST NUMBER

Labor Raw Cost
LABOR_BRDN_COST NUMBER

Labor Burdened Cost
LABOR_HRS NUMBER

Labor Hours
LABOR_REVENUE NUMBER

Labor Revenue
EQUIPMENT_HOURS NUMBER

Equipment Hours
BILLABLE_EQUIPMENT_HOURS NUMBER

Billable Equipment Hours
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
PLAN_TYPE_CODE VARCHAR2 (1)
Identifier of the Plan Type Code. C = Cost, R = REVENUE, A = ALL
CUSTOM1 NUMBER

Custom measure1
CUSTOM2 NUMBER

Custom measure2
CUSTOM3 NUMBER

Custom measure3
CUSTOM4 NUMBER

Custom measure4
CUSTOM5 NUMBER

Custom measure5
CUSTOM6 NUMBER

Custom measure6
CUSTOM7 NUMBER

Custom measure7
CUSTOM8 NUMBER

Custom measure8
CUSTOM9 NUMBER

Custom measure9
CUSTOM10 NUMBER

Custom measure10
CUSTOM11 NUMBER

Custom measure11
CUSTOM12 NUMBER

Custom measure12
CUSTOM13 NUMBER

Custom measure13
CUSTOM14 NUMBER

Custom measure14
CUSTOM15 NUMBER

Custom measure15
CUSTOM16 NUMBER

CUSTOM17 NUMBER

CUSTOM18 NUMBER

CUSTOM19 NUMBER

CUSTOM20 NUMBER

CUSTOM21 NUMBER

CUSTOM22 NUMBER

CUSTOM23 NUMBER

CUSTOM24 NUMBER

CUSTOM25 NUMBER

CUSTOM26 NUMBER

CUSTOM27 NUMBER

CUSTOM28 NUMBER

CUSTOM29 NUMBER

CUSTOM30 NUMBER

CBS_ELEMENT_ID NUMBER

CBS_VERSION_ID NUMBER

Query Text

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


SELECT PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      RBS_AGGR_LEVEL
,      WBS_ROLLUP_FLAG
,      PRG_ROLLUP_FLAG
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      PLAN_VERSION_ID
,      PLAN_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RAW_COST
,      BRDN_COST
,      REVENUE
,      BILL_RAW_COST
,      BILL_BRDN_COST
,      BILL_LABOR_RAW_COST
,      BILL_LABOR_BRDN_COST
,      BILL_LABOR_HRS
,      EQUIPMENT_RAW_COST
,      EQUIPMENT_BRDN_COST
,      CAPITALIZABLE_RAW_COST
,      CAPITALIZABLE_BRDN_COST
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_HRS
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      BILLABLE_EQUIPMENT_HOURS
,      SUP_INV_COMMITTED_COST
,      PO_COMMITTED_COST
,      PR_COMMITTED_COST
,      OTH_COMMITTED_COST
,      PLAN_TYPE_CODE
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
,      CUSTOM16
,      CUSTOM17
,      CUSTOM18
,      CUSTOM19
,      CUSTOM20
,      CUSTOM21
,      CUSTOM22
,      CUSTOM23
,      CUSTOM24
,      CUSTOM25
,      CUSTOM26
,      CUSTOM27
,      CUSTOM28
,      CUSTOM29
,      CUSTOM30
,      CBS_ELEMENT_ID
,      CBS_VERSION_ID
FROM APPS.PA_PLAN_ACTUALS_FACT_V;

Dependencies

[top of page]

APPS.PA_PLAN_ACTUALS_FACT_V references the following:

SchemaAPPS
SynonymPJI_FP_XBS_ACCUM_F

APPS.PA_PLAN_ACTUALS_FACT_V is not referenced by any database object