Product: | AMW - Internal Controls Manager (Obsolete) |
---|---|
Description: | This view returns information about Audit Project. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPV.PROJECT_ID
, PPV.NAME
, PPV.SEGMENT1
, PPV.PROJECT_TYPE
, PPV.CARRYING_OUT_ORGANIZATION_ID
, PPV.CARRYING_OUT_ORGANIZATION_NAME
, PPV.PUBLIC_SECTOR_FLAG
, PPV.PUBLIC_SECTOR
, PPV.PROJECT_STATUS_CODE
, PPV.PROJECT_STATUS_NAME
, PPV.DESCRIPTION
, PPV.START_DATE
, PPV.COMPLETION_DATE
, PPV.CLOSED_DATE
, PPV.DISTRIBUTION_RULE
, PPV.TEMPLATE_FLAG
, PPV.CREATED_FROM_PROJECT_ID
, PPV.TEMPLATE_START_DATE_ACTIVE
, PPV.TEMPLATE_END_DATE_ACTIVE
, PPV.SUMMARY_FLAG
, PPV.ENABLED_FLAG
, PPV.ORG_ID
, PPV.PROJECT_CURRENCY_CODE
, PPV.PERSON_ID
, PPV.PERSON_NAME
, PPV.CUSTOMER_ID
, PPV.CUSTOMER_NAME
, PPV.RESOURCE_ID
, PPV.PM_PRODUCT_CODE
, PPV.PM_PROJECT_REFERENCE
, PPV.ACTUAL_START_DATE
, PPV.ACTUAL_FINISH_DATE
, PPV.EARLY_START_DATE
, PPV.EARLY_FINISH_DATE
, PPV.LATE_START_DATE
, PPV.LATE_FINISH_DATE
, PPV.SCHEDULED_START_DATE
, PPV.SCHEDULED_FINISH_DATE
, PPV.LOCATION_ID
, PPV.COUNTRY_CODE
, PPV.COUNTRY_NAME
, PPV.REGION
, PPV.CITY
, PPV.PROBABILITY_MEMBER_ID
, PPV.PROBABILITY_PERCENTAGE
, PPV.EXPECTED_APPROVAL_DATE
, PPV.PROJECT_VALUE
, PPV.SERVICE_TYPE_CODE
, PPV.PROGRESS_STATUS_CODE
, PPV.PROGRESS_STATUS_NAME
, PPV.PROGRESS_ICON
, PPV.PROGRESS_ICON_ACTIVE
, PPV.PROGRESS_REPORT_END_DATE
, PPV.RECORD_VERSION_NUMBER
, PPV.VIEW_PSI_COLUMNS
, PPV.PSI_PROJFUNC_CURRENCY_CODE
, PPV.PSI_COLUMN4
, PPV.PSI_COLUMN5
, PPV.PSI_COLUMN6
, PPV.PSI_COLUMN7
, PPV.PSI_COLUMN8
, PPV.PSI_COLUMN9
, PPV.PSI_COLUMN10
, PPV.PSI_COLUMN11
, PPV.PSI_COLUMN12
, PPV.PSI_COLUMN13
, PPV.PSI_COLUMN14
, PPV.PSI_COLUMN15
, PPV.PSI_COLUMN16
, PPV.PSI_COLUMN17
, PPV.PSI_COLUMN18
, PPV.PSI_COLUMN19
, PPV.PSI_COLUMN20
, PPV.PSI_COLUMN21
, PPV.PSI_COLUMN22
, PPV.PSI_COLUMN23
, PPV.PSI_COLUMN24
, PPV.PSI_COLUMN25
, PPV.PSI_COLUMN26
, PPV.PSI_COLUMN27
, PPV.PSI_COLUMN28
, PPV.PSI_COLUMN29
, PPV.PSI_COLUMN30
, PPV.PSI_COLUMN31
, PPV.PSI_COLUMN32
, PPV.PSI_COLUMN33
, PPV.OPPORTUNITY_VALUE
, PPV.OPP_VALUE_CURRENCY_CODE
, PPV.PROJFUNC_OPP_VALUE
, PPV.PROJFUNC_CURRENCY_CODE
, PPV.PROJECT_OPP_VALUE
, PPV.REPORT_TYPE_NAME
, PPV.REPORT_TYPE_ID
FROM PA_PROJECT_LISTS_V PPV
WHERE PPV.PROJECT_TYPE=FND_PROFILE.VALUE('AMW_AUDIT_PROJECT_TYPE')