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

VIEW: APPS.PA_CAPITAL_PROJECTS_V

Object Details
Object Name: PA_CAPITAL_PROJECTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CAPITAL_PROJECTS_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
ROW_ID ROWID (10)
Oracle rowid
PROJECT_ID NUMBER (15)
Identifier of the project
PROJECT_NAME VARCHAR2 (30)
Name of the project
PROJECT_NUMBER VARCHAR2 (25)
Number of the project
PROJECT_STATUS_CODE VARCHAR2 (30)
Status of the project
PROJECT_TYPE VARCHAR2 (20)
Type of the project
INTERFACE_COMPLETE_ASSET_FLAG VARCHAR2 (1)
Indicates whether project type requires complete asset definition for interface
INTERFACE_ASSET_COST_CODE VARCHAR2 (1)
Not currently used
PROJECT_ORGANIZATION VARCHAR2 (240)
Project owning organization
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
UPDATE_ALLOWED VARCHAR2 (1)
Specifies whether user has update privileges for the project as determined by project-based security validation.
VIEW_LABOR_COSTS_ALLOWED VARCHAR2 (1)
Specifies whether user has view labor costs privilege for the project as determined by labor cost security validation.
CAPITALIZED_COST VARCHAR2 (40)
Project cost which has been interfaced to Oracle Assets
CAPITALIZABLE_COST VARCHAR2 (40)
Total project cost eligible to be capitalized
TOTAL_COSTS VARCHAR2 (40)
Total project cost, both capitalizable and non-capitalizable
EXPENSED VARCHAR2 (40)
Total project cost NOT eligible to be capitalized
CIP_COST VARCHAR2 (40)
Capitalizable cost which has not yet been interfaced
ASSET_ALLOCATION_METHOD VARCHAR2 (30)
Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level.
CAPITAL_EVENT_PROCESSING VARCHAR2 (30)
Capital Event Processing method. Used to determine when cost and assets are grouped for capitalization or retirement adjustment processing.
CAPITAL_COST_TYPE_CODE VARCHAR2 (1)
Specifies whether to capitalize raw or burdened costs for a capital project.
BURDEN_AMT_DISPLAY_METHOD VARCHAR2 (1)
Flag indicates to display Burden amount on same transaction or display it as a separate transaction.
TOTAL_BURDEN_FLAG VARCHAR2 (1)
Flag that indicates whether accounting lines need to be created for a transaction.
ORG_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PROJECT_STATUS_CODE
,      PROJECT_TYPE
,      INTERFACE_COMPLETE_ASSET_FLAG
,      INTERFACE_ASSET_COST_CODE
,      PROJECT_ORGANIZATION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UPDATE_ALLOWED
,      VIEW_LABOR_COSTS_ALLOWED
,      CAPITALIZED_COST
,      CAPITALIZABLE_COST
,      TOTAL_COSTS
,      EXPENSED
,      CIP_COST
,      ASSET_ALLOCATION_METHOD
,      CAPITAL_EVENT_PROCESSING
,      CAPITAL_COST_TYPE_CODE
,      BURDEN_AMT_DISPLAY_METHOD
,      TOTAL_BURDEN_FLAG
,      ORG_ID
FROM APPS.PA_CAPITAL_PROJECTS_V;

Dependencies

[top of page]

APPS.PA_CAPITAL_PROJECTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPA_CAPITAL_PROJECTS_BASE_V
PL/SQL PackagePA_MC_CURRENCY_PKG - show dependent code
SynonymPA_PROJECTS
SynonymPA_PROJECT_STATUSES
PL/SQL PackagePA_SECURITY - show dependent code

APPS.PA_CAPITAL_PROJECTS_V is not referenced by any database object