[Home] [Help] [Dependency Information]
Object Name: | AMW_PROJECTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_PROJECTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about Audit Project.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the project |
NAME | VARCHAR2 | (30) | Yes | User-defined name that uniquely identifies the project |
SEGMENT1 | 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_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 | Organization Identifier |
CARRYING_OUT_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Name of the organization |
PUBLIC_SECTOR_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether the project is in the public sector or the private sector |
PUBLIC_SECTOR | VARCHAR2 | (80) | Yes | Indicates whether the project is in the public sector or the private sector |
PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | The status of the project. |
PROJECT_STATUS_NAME | VARCHAR2 | (80) | Yes | The user_defined project status name |
DESCRIPTION | VARCHAR2 | (250) | The description of the project | |
START_DATE | DATE | The date on which the project starts, expenditure items with item dates before the start date cannot be entered for the project | ||
COMPLETION_DATE | DATE | The date on which the project is completed; expenditure items with item dates after the completion date cannot be entered for the project | ||
CLOSED_DATE | DATE | The date that the project was closed by changing the project status to Closed | ||
DISTRIBUTION_RULE | VARCHAR2 | (30) | The distribution rule that specifies the contract projects revenue accrual and billing method | |
TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates whether the project is a Template or not | |
CREATED_FROM_PROJECT_ID | NUMBER | (15) | Holds the Project id of the source project. This value would be null for templates | |
TEMPLATE_START_DATE_ACTIVE | DATE | The effective start date of the template | ||
TEMPLATE_END_DATE_ACTIVE | DATE | Last effective date of the Template | ||
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Flag used with the project key flexfield. The project key flexfield is not implemented |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag used with the key flexfield. The project key flexfield is not implemented |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of the project |
PERSON_ID | NUMBER | Project manager id | ||
PERSON_NAME | VARCHAR2 | (4000) | Project manager name | |
CUSTOMER_ID | VARCHAR2 | (0) | Primary customer id | |
CUSTOMER_NAME | VARCHAR2 | (4000) | Primary customer name | |
RESOURCE_ID | VARCHAR2 | (0) | Resource id | |
PM_PRODUCT_CODE | VARCHAR2 | (30) | Pm Product Code | |
PM_PROJECT_REFERENCE | VARCHAR2 | (25) | Pm Project Reference | |
ACTUAL_START_DATE | DATE | The actual start date of the project. Applicable only for a project that has originated from an external system. | ||
ACTUAL_FINISH_DATE | DATE | The actual finish date of the project. Applicable only for a project that has originated from an external system. | ||
EARLY_START_DATE | DATE | The early start date of the project. Applicable only for a project that has originated from an external system. | ||
EARLY_FINISH_DATE | DATE | The early finish date of the project. Applicable only for a project that has originated from an external system. | ||
LATE_START_DATE | DATE | The late start date of the project. Applicable only for a project that has originated from an external system. | ||
LATE_FINISH_DATE | DATE | The late finish date of the project. Applicable only for a project that has originated from an external system. | ||
SCHEDULED_START_DATE | DATE | The scheduled start date of the project. Applicable only for a project that has originated from an external system. | ||
SCHEDULED_FINISH_DATE | DATE | The scheduled finish date of the project. Applicable only for a project that has originated from an external system. | ||
LOCATION_ID | NUMBER | (15) | Location id | |
COUNTRY_CODE | VARCHAR2 | (2) | Country code | |
COUNTRY_NAME | VARCHAR2 | (80) | Country name | |
REGION | VARCHAR2 | (240) | Region | |
CITY | VARCHAR2 | (80) | City | |
PROBABILITY_MEMBER_ID | NUMBER | (15) | Project probability represents the probability of a project becoming approved. It is used as a weighting average for reporting | |
PROBABILITY_PERCENTAGE | NUMBER | Probability percentage of the project becoming approved | ||
EXPECTED_APPROVAL_DATE | DATE | The expected date of the project approval. This is used for information purposes only. | ||
PROJECT_VALUE | NUMBER | Project value is used in reporting. For contract projects, it is the revenue amount. For capital and indirect projects, it is the cost amount. It is not assumed that the cost amount is raw or burdened. | ||
SERVICE_TYPE_CODE | VARCHAR2 | (30) | Yes | Service Type |
PROGRESS_STATUS_CODE | VARCHAR2 | (30) | Progress Status Code | |
PROGRESS_STATUS_NAME | VARCHAR2 | (80) | Progress Status Name | |
PROGRESS_ICON | VARCHAR2 | (80) | Progress Icon | |
PROGRESS_ICON_ACTIVE | VARCHAR2 | (80) | Linked Progress Icon | |
PROGRESS_REPORT_END_DATE | DATE | Progress Report End Date | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | Stores locking sequence number | |
VIEW_PSI_COLUMNS | CHAR | (1) | View psi columns | |
PSI_PROJFUNC_CURRENCY_CODE | VARCHAR2 | (0) | Psi Projfunc Currency Code | |
PSI_COLUMN4 | NUMBER | Psi Column | ||
PSI_COLUMN5 | NUMBER | Psi Column | ||
PSI_COLUMN6 | NUMBER | Psi Column | ||
PSI_COLUMN7 | NUMBER | Psi Column | ||
PSI_COLUMN8 | NUMBER | Psi Column | ||
PSI_COLUMN9 | NUMBER | Psi Column | ||
PSI_COLUMN10 | NUMBER | Psi Column | ||
PSI_COLUMN11 | NUMBER | Psi Column | ||
PSI_COLUMN12 | NUMBER | Psi Column | ||
PSI_COLUMN13 | NUMBER | Psi Column | ||
PSI_COLUMN14 | NUMBER | Psi Column | ||
PSI_COLUMN15 | NUMBER | Psi Column | ||
PSI_COLUMN16 | NUMBER | Psi Column | ||
PSI_COLUMN17 | NUMBER | Psi Column | ||
PSI_COLUMN18 | NUMBER | Psi Column | ||
PSI_COLUMN19 | NUMBER | Psi Column | ||
PSI_COLUMN20 | NUMBER | Psi Column | ||
PSI_COLUMN21 | NUMBER | Psi Column | ||
PSI_COLUMN22 | NUMBER | Psi Column | ||
PSI_COLUMN23 | NUMBER | Psi Column | ||
PSI_COLUMN24 | NUMBER | Psi Column | ||
PSI_COLUMN25 | NUMBER | Psi Column | ||
PSI_COLUMN26 | NUMBER | Psi Column | ||
PSI_COLUMN27 | NUMBER | Psi Column | ||
PSI_COLUMN28 | NUMBER | Psi Column | ||
PSI_COLUMN29 | NUMBER | Psi Column | ||
PSI_COLUMN30 | NUMBER | Psi Column | ||
PSI_COLUMN31 | NUMBER | Psi Column | ||
PSI_COLUMN32 | NUMBER | Psi Column | ||
PSI_COLUMN33 | NUMBER | Psi Column | ||
OPPORTUNITY_VALUE | NUMBER | Opportunity value | ||
OPP_VALUE_CURRENCY_CODE | VARCHAR2 | (15) | Opp Value Currency Code | |
PROJFUNC_OPP_VALUE | NUMBER | Projfunc Opp Value | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Projfunc Currency Code | |
PROJECT_OPP_VALUE | NUMBER | Project Opp Value | ||
REPORT_TYPE_NAME | VARCHAR2 | (80) | Report Type Name | |
REPORT_TYPE_ID | NUMBER | (15) | Report Type Id |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, NAME
, SEGMENT1
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, CARRYING_OUT_ORGANIZATION_NAME
, PUBLIC_SECTOR_FLAG
, PUBLIC_SECTOR
, PROJECT_STATUS_CODE
, PROJECT_STATUS_NAME
, DESCRIPTION
, START_DATE
, COMPLETION_DATE
, CLOSED_DATE
, DISTRIBUTION_RULE
, TEMPLATE_FLAG
, CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE
, TEMPLATE_END_DATE_ACTIVE
, SUMMARY_FLAG
, ENABLED_FLAG
, ORG_ID
, PROJECT_CURRENCY_CODE
, PERSON_ID
, PERSON_NAME
, CUSTOMER_ID
, CUSTOMER_NAME
, RESOURCE_ID
, PM_PRODUCT_CODE
, PM_PROJECT_REFERENCE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, EARLY_START_DATE
, EARLY_FINISH_DATE
, LATE_START_DATE
, LATE_FINISH_DATE
, SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE
, LOCATION_ID
, COUNTRY_CODE
, COUNTRY_NAME
, REGION
, CITY
, PROBABILITY_MEMBER_ID
, PROBABILITY_PERCENTAGE
, EXPECTED_APPROVAL_DATE
, PROJECT_VALUE
, SERVICE_TYPE_CODE
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_NAME
, PROGRESS_ICON
, PROGRESS_ICON_ACTIVE
, PROGRESS_REPORT_END_DATE
, RECORD_VERSION_NUMBER
, VIEW_PSI_COLUMNS
, PSI_PROJFUNC_CURRENCY_CODE
, PSI_COLUMN4
, PSI_COLUMN5
, PSI_COLUMN6
, PSI_COLUMN7
, PSI_COLUMN8
, PSI_COLUMN9
, PSI_COLUMN10
, PSI_COLUMN11
, PSI_COLUMN12
, PSI_COLUMN13
, PSI_COLUMN14
, PSI_COLUMN15
, PSI_COLUMN16
, PSI_COLUMN17
, PSI_COLUMN18
, PSI_COLUMN19
, PSI_COLUMN20
, PSI_COLUMN21
, PSI_COLUMN22
, PSI_COLUMN23
, PSI_COLUMN24
, PSI_COLUMN25
, PSI_COLUMN26
, PSI_COLUMN27
, PSI_COLUMN28
, PSI_COLUMN29
, PSI_COLUMN30
, PSI_COLUMN31
, PSI_COLUMN32
, PSI_COLUMN33
, OPPORTUNITY_VALUE
, OPP_VALUE_CURRENCY_CODE
, PROJFUNC_OPP_VALUE
, PROJFUNC_CURRENCY_CODE
, PROJECT_OPP_VALUE
, REPORT_TYPE_NAME
, REPORT_TYPE_ID
FROM APPS.AMW_PROJECTS_V;
APPS.AMW_PROJECTS_V is not referenced by any database object
|
|
|