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

VIEW: PA.PA_PROJECT_ACCUM_ACTUALS_EFC#

Object Details
Object Name: PA_PROJECT_ACCUM_ACTUALS_EFC#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ACCUM_ID NUMBER (15) Yes
RAW_COST_ITD NUMBER

RAW_COST_YTD NUMBER

RAW_COST_PP NUMBER

RAW_COST_PTD NUMBER

BILLABLE_RAW_COST_ITD NUMBER

BILLABLE_RAW_COST_YTD NUMBER

BILLABLE_RAW_COST_PP NUMBER

BILLABLE_RAW_COST_PTD NUMBER

BURDENED_COST_ITD NUMBER

BURDENED_COST_YTD NUMBER

BURDENED_COST_PP NUMBER

BURDENED_COST_PTD NUMBER

BILLABLE_BURDENED_COST_ITD NUMBER

BILLABLE_BURDENED_COST_YTD NUMBER

BILLABLE_BURDENED_COST_PP NUMBER

BILLABLE_BURDENED_COST_PTD NUMBER

REVENUE_ITD NUMBER

REVENUE_YTD NUMBER

REVENUE_PP NUMBER

REVENUE_PTD NUMBER

SET_OF_BOOKS_ID NUMBER

CREATION_DATE DATE
Yes
Query Text

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


SELECT PROJECT_ACCUM_ID
,      RAW_COST_ITD
,      RAW_COST_YTD
,      RAW_COST_PP
,      RAW_COST_PTD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_RAW_COST_PP
,      BILLABLE_RAW_COST_PTD
,      BURDENED_COST_ITD
,      BURDENED_COST_YTD
,      BURDENED_COST_PP
,      BURDENED_COST_PTD
,      BILLABLE_BURDENED_COST_ITD
,      BILLABLE_BURDENED_COST_YTD
,      BILLABLE_BURDENED_COST_PP
,      BILLABLE_BURDENED_COST_PTD
,      REVENUE_ITD
,      REVENUE_YTD
,      REVENUE_PP
,      REVENUE_PTD
,      SET_OF_BOOKS_ID
,      CREATION_DATE
FROM PA.PA_PROJECT_ACCUM_ACTUALS_EFC#;

Dependencies

[top of page]

PA.PA_PROJECT_ACCUM_ACTUALS_EFC# references the following:

SchemaPA
TablePA_PROJECT_ACCUM_ACTUALS_EFC
PA.PA_PROJECT_ACCUM_ACTUALS_EFC# is referenced by following:

SchemaAPPS
SynonymPA_PROJECT_ACCUM_ACTUALS_EFC