[Home] [Help] [Dependency Information]
Object Name: | PA_CAPITAL_PROJECTS_BASE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_CAPITAL_PROJECTS_BASE_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
PROJECT_STATUS_CODE | VARCHAR2 | (30) | ||
PROJECT_TYPE | VARCHAR2 | (20) | ||
INTERFACE_COMPLETE_ASSET_FLAG | VARCHAR2 | (1) | ||
INTERFACE_ASSET_COST_CODE | VARCHAR2 | (1) | ||
PROJECT_ORGANIZATION | VARCHAR2 | (240) | ||
CAPITALIZED_COST | NUMBER | |||
CAPITALIZABLE_COST | NUMBER | |||
TOTAL_COSTS | NUMBER | |||
ASSET_ALLOCATION_METHOD | VARCHAR2 | (30) | ||
CAPITAL_EVENT_PROCESSING | VARCHAR2 | (30) | ||
CAPITAL_COST_TYPE_CODE | VARCHAR2 | (1) | ||
BURDEN_AMT_DISPLAY_METHOD | VARCHAR2 | (1) | ||
TOTAL_BURDEN_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_STATUS_CODE
, PROJECT_TYPE
, INTERFACE_COMPLETE_ASSET_FLAG
, INTERFACE_ASSET_COST_CODE
, PROJECT_ORGANIZATION
, CAPITALIZED_COST
, CAPITALIZABLE_COST
, TOTAL_COSTS
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CAPITAL_COST_TYPE_CODE
, BURDEN_AMT_DISPLAY_METHOD
, TOTAL_BURDEN_FLAG
FROM APPS.PA_CAPITAL_PROJECTS_BASE_V;
|
|
|