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


VIEW: APPS.PA_BUDGET_BY_PA_PERIOD_V

Object Details
Object Name: PA_BUDGET_BY_PA_PERIOD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_BUDGET_BY_PA_PERIOD_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
BUDGET_TYPE_CODE VARCHAR2 (30)
PA_PERIOD VARCHAR2 (20)
GL_PERIOD_NAME VARCHAR2 (15)
PERIOD_YEAR NUMBER (15)
PERIOD_START_DATE DATE

PERIOD_END_DATE DATE

RESOURCE_LIST_MEMBER_ID NUMBER (15)
RESOURCE_LIST_ID NUMBER (15)
RESOURCE_ID NUMBER (15)
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1)
BASE_RAW_COST NUMBER

BASE_BURDENED_COST NUMBER

BASE_REVENUE NUMBER

BASE_QUANTITY NUMBER

BASE_LABOR_QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
ORIG_RAW_COST NUMBER

ORIG_BURDENED_COST NUMBER

ORIG_REVENUE NUMBER

ORIG_QUANTITY NUMBER

ORIG_LABOR_QUANTITY NUMBER

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      BUDGET_TYPE_CODE
,      PA_PERIOD
,      GL_PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      RESOURCE_ID
,      RESOURCE_ACCUMULATED_FLAG
,      BASE_RAW_COST
,      BASE_BURDENED_COST
,      BASE_REVENUE
,      BASE_QUANTITY
,      BASE_LABOR_QUANTITY
,      UNIT_OF_MEASURE
,      ORIG_RAW_COST
,      ORIG_BURDENED_COST
,      ORIG_REVENUE
,      ORIG_QUANTITY
,      ORIG_LABOR_QUANTITY
FROM APPS.PA_BUDGET_BY_PA_PERIOD_V;

Dependencies

[top of page]

APPS.PA_BUDGET_BY_PA_PERIOD_V references the following:

SchemaAPPS
PL/SQL PackagePA_MISC - show dependent code
ViewPA_NG_BUDGET_BY_PA_PERIOD_V
APPS.PA_BUDGET_BY_PA_PERIOD_V is referenced by following:

SchemaAPPS
Package BodyPA_ACCUM_API - show dependent code
Package BodyPA_BIS_SUMMARY - show dependent code