[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_ALL_BASIC_UN_SEC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_PROJ_ALL_BASIC_UN_SEC_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) | Yes | The system-generated number that uniquely identifies the project |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | The project number that uniquely identifies the project. The project number can be user-entered or system-generated as defined in the implementation options |
PROJECT_NAME | VARCHAR2 | (30) | Yes | User-defined name that uniquely identifies the project |
PROJECT_DESCRIPTION | VARCHAR2 | (250) | The description of the project | |
PROJECT_TYPE | VARCHAR2 | (20) | Yes | The project type that classifies the project and defaults project information upon project entry |
CARRYING_OUT_ORGANIZATION_ID | NUMBER | (15) | Yes | The identifier of the organization that is responsible for the project work |
PROJECT_TYPE_CLASS_CODE | VARCHAR2 | (30) | Indicates the class of project type | |
PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | The status of the project. |
TEMPLATE_FLAG | VARCHAR2 | (1) | ||
PM_PROJECT_REFERENCE | VARCHAR2 | (25) | ||
PROJECT_NUMBER_SORT_ORDER | VARCHAR2 | (25) | Yes | |
ORG_ID | NUMBER | (15) | ||
START_DATE | DATE | |||
COMPLETION_DATE | DATE | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Yes | |
PROJECT_RATE_DATE | DATE | |||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
CHARGES_ALLOWED_FLAG | VARCHAR2 | (4000) | ||
CC_PRVDR_FLAG | VARCHAR2 | (1) | ||
PROJ_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
OPERATING_UNIT | VARCHAR2 | (240) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PROJECT_TYPE_CLASS_CODE
, PROJECT_STATUS_CODE
, TEMPLATE_FLAG
, PM_PROJECT_REFERENCE
, PROJECT_NUMBER_SORT_ORDER
, ORG_ID
, START_DATE
, COMPLETION_DATE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, CHARGES_ALLOWED_FLAG
, CC_PRVDR_FLAG
, PROJ_SET_OF_BOOKS_ID
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, OPERATING_UNIT
FROM APPS.PA_PROJ_ALL_BASIC_UN_SEC_V;
|
|
|