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

VIEW: APPS.PA_NG_BUDGET_BY_RESOURCE_V

Object Details
Object Name: PA_NG_BUDGET_BY_RESOURCE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_NG_BUDGET_BY_RESOURCE_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
BUDGET_VERSION_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
BUDGET_TYPE_CODE VARCHAR2 (30)
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

ORIG_RAW_COST NUMBER

ORIG_BURDENED_COST NUMBER

ORIG_REVENUE NUMBER

ORIG_QUANTITY NUMBER

ORIG_LABOR_QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      BUDGET_TYPE_CODE
,      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
,      ORIG_RAW_COST
,      ORIG_BURDENED_COST
,      ORIG_REVENUE
,      ORIG_QUANTITY
,      ORIG_LABOR_QUANTITY
,      UNIT_OF_MEASURE
FROM APPS.PA_NG_BUDGET_BY_RESOURCE_V;

Dependencies

[top of page]

APPS.PA_NG_BUDGET_BY_RESOURCE_V references the following:

SchemaAPPS
ViewPA_BASE_BUDGET_BY_RESOURCE_V
SynonymPA_BUDGET_VERSIONS
ViewPA_ORIG_BUDGET_BY_RESOURCE_V
APPS.PA_NG_BUDGET_BY_RESOURCE_V is referenced by following:

SchemaAPPS
ViewPA_BUDGET_BY_RESOURCE_V