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

VIEW: PA.PA_ORG_FORECAST_LINES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_LINE_ID NUMBER (15) Yes
FORECAST_ELEMENT_ID NUMBER (15) Yes
RECORD_VERSION_NUMBER NUMBER
Yes
BUDGET_VERSION_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (30) Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
QUANTITY NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

TP_COST_IN NUMBER

TP_COST_OUT NUMBER

LENT_RESOURCE_COST NUMBER

UNASSIGNED_TIME_COST NUMBER

REVENUE NUMBER

TP_REVENUE_IN NUMBER

TP_REVENUE_OUT NUMBER

BORROWED_REVENUE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT FORECAST_LINE_ID
,      FORECAST_ELEMENT_ID
,      RECORD_VERSION_NUMBER
,      BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      QUANTITY
,      RAW_COST
,      BURDENED_COST
,      TP_COST_IN
,      TP_COST_OUT
,      LENT_RESOURCE_COST
,      UNASSIGNED_TIME_COST
,      REVENUE
,      TP_REVENUE_IN
,      TP_REVENUE_OUT
,      BORROWED_REVENUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_ORG_FORECAST_LINES#;

Dependencies

[top of page]

PA.PA_ORG_FORECAST_LINES# references the following:

SchemaPA
TablePA_ORG_FORECAST_LINES
PA.PA_ORG_FORECAST_LINES# is referenced by following:

SchemaAPPS
SynonymPA_ORG_FORECAST_LINES