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


VIEW: APPS.AMW_PROJECTS_V

Object Details
Object Name: AMW_PROJECTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_PROJECTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view returns information about Audit Project.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.AMW_PROJECTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackagePA_PROJECTS_MAINT_UTILS - show dependent code
PL/SQL PackagePA_PROJECT_DATES_UTILS - show dependent code
ViewPA_PROJECT_LISTS_V
PL/SQL PackagePA_PROJECT_PARTIES_UTILS - show dependent code

APPS.AMW_PROJECTS_V is not referenced by any database object