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

VIEW: APPS.PA_FCST_PROJ_PERIODIC_V

Object Details
Object Name: PA_FCST_PROJ_PERIODIC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_FCST_PROJ_PERIODIC_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

Project Id
ASSIGNMENT_ID NUMBER

Assignment Id
ASSIGNMENT_NAME VARCHAR2 (80)
Assignment Name
RESOURCE_ASSIGNMENT_ID NUMBER (15)
Resource Assignment Id
PERIOD_NAME VARCHAR2 (30)
Period Name
PERIOD_START_DATE DATE

Period Start Date
PLAN_PROCESSING_CODE VARCHAR2 (2)
Plan Processing Code
STD_BILL_RATE NUMBER

Standard Bill Rate
AVG_BILL_RATE NUMBER

Average Bill Rate
AVG_DISCOUNT_PERCENTAGE NUMBER

Average Discount Percentage
PROJECT_TOTAL NUMBER

Project Total
VALUE NUMBER

Value
Query Text

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


SELECT PROJECT_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      RESOURCE_ASSIGNMENT_ID
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PLAN_PROCESSING_CODE
,      STD_BILL_RATE
,      AVG_BILL_RATE
,      AVG_DISCOUNT_PERCENTAGE
,      PROJECT_TOTAL
,      VALUE
FROM APPS.PA_FCST_PROJ_PERIODIC_V;

Dependencies

[top of page]

APPS.PA_FCST_PROJ_PERIODIC_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymPA_BUDGET_LINES
SynonymPA_BUDGET_VERSIONS
PL/SQL PackagePA_FCST_GLOBAL - show dependent code
ViewPA_FCST_PERIODS_TMP_V
PL/SQL PackagePA_PERIOD_PROCESS_PKG - show dependent code
SynonymPA_PROJECT_ASSIGNMENTS
SynonymPA_RESOURCE_ASSIGNMENTS
SchemaPUBLIC
SynonymDUAL
APPS.PA_FCST_PROJ_PERIODIC_V is referenced by following:

SchemaAPPS
ViewPA_FCST_PROJ_DTL_V