eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_REP_PROJ_SP_PA_V

Source

View Text - Preformatted


SELECT ppa.carrying_out_organization_id, ppc.class_category, ppc.class_code, ppc.code_percentage, ppa.name, ppa.segment1, ppa.project_id, ppp.project_role_type, ppp.person_id, ppm.probability_percentage, ppa.project_type, pps.project_status_name, pap.period_year, pap.quarter_num, pap.period_name, pap.pa_start_date, ppa.expected_approval_date, NVL(ppa.project_value,0) * NVL(ppc.code_percentage/100,1), NVL(ppa.project_value,0) * ppm.probability_percentage/100 * NVL(ppc.code_percentage/100,1), pa_projects_maint_utils.get_primary_customer_name(ppa.project_id), pai.org_id from pa_project_classes ppc, pa_projects_all ppa, pa_probability_members ppm, pa_project_statuses pps, pa_project_players ppp, pa_implementations pai, pa_periods_v pap WHERE ppa.project_id = ppc.project_id and ppa.project_id = ppp.project_id and ppm.probability_member_id = ppa.probability_member_id and pps.project_status_code = ppa.project_status_code and ppa.expected_approval_date between pap.pa_start_date and pap.pa_end_date and ppa.expected_approval_date is not null and ppa.probability_member_id is not null and pai.set_of_books_id = pap.set_of_books_id union select ppa.carrying_out_organization_id, ppc.class_category, ppc.class_code, ppc.code_percentage, ppa.name, ppa.segment1, ppa.project_id, ppp.project_role_type, ppp.person_id, ppm.probability_percentage, ppa.project_type, pps.project_status_name, pap.period_year, pap.quarter_num, pap.period_name, pap.pa_start_date, ppa.expected_approval_date, NVL(ppa.project_value,0) * NVL(ppc.code_percentage/100,1), NVL(ppa.project_value,0) * ppm.probability_percentage/100 * NVL(ppc.code_percentage/100,1), pa_projects_maint_utils.get_primary_customer_name(ppa.project_id), pai.org_id from pa_project_classes ppc, pa_projects_all ppa, pa_probability_members ppm, pa_project_statuses pps, pa_project_players ppp, pa_implementations pai, pa_periods_v pap where ppa.project_id = ppc.project_id and ppa.project_id = ppp.project_id and ppm.probability_member_id = ppa.probability_member_id and pps.project_status_code = ppa.project_status_code and ( ppa.expected_approval_date < sysdate and sysdate between pap.pa_start_date and pap.pa_end_date and ppa.expected_approval_date not between pap.pa_start_date and pap.pa_end_date ) and ppa.expected_approval_date is not null and ppa.probability_member_id is not null and pai.set_of_books_id = pap.set_of_books_id

View Text - HTML Formatted

SELECT PPA.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PPC.CODE_PERCENTAGE
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_ID
, PPP.PROJECT_ROLE_TYPE
, PPP.PERSON_ID
, PPM.PROBABILITY_PERCENTAGE
, PPA.PROJECT_TYPE
, PPS.PROJECT_STATUS_NAME
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, PAP.PERIOD_NAME
, PAP.PA_START_DATE
, PPA.EXPECTED_APPROVAL_DATE
, NVL(PPA.PROJECT_VALUE
, 0) * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, NVL(PPA.PROJECT_VALUE
, 0) * PPM.PROBABILITY_PERCENTAGE/100 * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID)
, PAI.ORG_ID
FROM PA_PROJECT_CLASSES PPC
, PA_PROJECTS_ALL PPA
, PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_PLAYERS PPP
, PA_IMPLEMENTATIONS PAI
, PA_PERIODS_V PAP
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPA.PROJECT_ID = PPP.PROJECT_ID
AND PPM.PROBABILITY_MEMBER_ID = PPA.PROBABILITY_MEMBER_ID
AND PPS.PROJECT_STATUS_CODE = PPA.PROJECT_STATUS_CODE
AND PPA.EXPECTED_APPROVAL_DATE BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID UNION SELECT PPA.CARRYING_OUT_ORGANIZATION_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, PPC.CODE_PERCENTAGE
, PPA.NAME
, PPA.SEGMENT1
, PPA.PROJECT_ID
, PPP.PROJECT_ROLE_TYPE
, PPP.PERSON_ID
, PPM.PROBABILITY_PERCENTAGE
, PPA.PROJECT_TYPE
, PPS.PROJECT_STATUS_NAME
, PAP.PERIOD_YEAR
, PAP.QUARTER_NUM
, PAP.PERIOD_NAME
, PAP.PA_START_DATE
, PPA.EXPECTED_APPROVAL_DATE
, NVL(PPA.PROJECT_VALUE
, 0) * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, NVL(PPA.PROJECT_VALUE
, 0) * PPM.PROBABILITY_PERCENTAGE/100 * NVL(PPC.CODE_PERCENTAGE/100
, 1)
, PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID)
, PAI.ORG_ID
FROM PA_PROJECT_CLASSES PPC
, PA_PROJECTS_ALL PPA
, PA_PROBABILITY_MEMBERS PPM
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_PLAYERS PPP
, PA_IMPLEMENTATIONS PAI
, PA_PERIODS_V PAP
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPA.PROJECT_ID = PPP.PROJECT_ID
AND PPM.PROBABILITY_MEMBER_ID = PPA.PROBABILITY_MEMBER_ID
AND PPS.PROJECT_STATUS_CODE = PPA.PROJECT_STATUS_CODE
AND ( PPA.EXPECTED_APPROVAL_DATE < SYSDATE
AND SYSDATE BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE
AND PPA.EXPECTED_APPROVAL_DATE NOT BETWEEN PAP.PA_START_DATE
AND PAP.PA_END_DATE )
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = PAP.SET_OF_BOOKS_ID