Skip to content

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

VIEW: APPS.PA_FCST_PROJECT_SUM_V

Object Details
Object Name: PA_FCST_PROJECT_SUM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FCST_PROJECT_SUM_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
FORECAST_EXISTS_FLAG CHAR (1)
forecast Exists Flag for crosstab data display
PROJECT_ID NUMBER (15)
Project Id
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
Project Name
PROJECT_ORG_NAME VARCHAR2 (240) Yes Organization Name
CUSTOMER_NAME VARCHAR2 (45)
Customer Name
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project Currency Code
PERIOD_NAME VARCHAR2 (30)
Period Name
PERIOD_TYPE VARCHAR2 (4000)
Period Type
PERIOD_START_DATE DATE
Yes Period Start Date
VALUE NUMBER

Value
Query Text

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


SELECT FORECAST_EXISTS_FLAG
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ORG_NAME
,      CUSTOMER_NAME
,      PROJECT_CURRENCY_CODE
,      PERIOD_NAME
,      PERIOD_TYPE
,      PERIOD_START_DATE
,      VALUE
FROM APPS.PA_FCST_PROJECT_SUM_V;

Dependencies

[top of page]

APPS.PA_FCST_PROJECT_SUM_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPA_BUDGET_LINES
SynonymPA_BUDGET_VERSIONS
PL/SQL PackagePA_FCST_GLOBAL - show dependent code
ViewPA_FCST_PROJECT_LIST_V
PL/SQL PackagePA_PROJECTS_MAINT_UTILS - show dependent code
SynonymPA_RESOURCE_ASSIGNMENTS
PL/SQL PackagePA_UTILS - show dependent code
SchemaPUBLIC
SynonymDUAL
APPS.PA_FCST_PROJECT_SUM_V is referenced by following:

SchemaAPPS
ViewPA_FCST_PERIODIC_DTL_V