VIEW: APPS.AMW_PROJECTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')