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_GL_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, glp.period_year, glp.quarter_num, glp.period_name, glp.period_set_name, glp.period_num, 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, gl_sets_of_books glsob, pa_implementations pai, gl_periods glp 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 glp.start_date and glp.end_date and ppa.expected_approval_date is not null and ppa.probability_member_id is not null and pai.set_of_books_id = glsob.set_of_books_id and glsob.period_set_name = glp.period_set_name and glsob.accounted_period_type = glp.period_type 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, glp.period_year, glp.quarter_num, glp.period_name, glp.period_set_name, glp.period_num, 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, gl_sets_of_books glsob, pa_implementations pai, gl_periods glp 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 glp.start_date and glp.end_date and ppa.expected_approval_date not between glp.start_date and glp.end_date ) and ppa.expected_approval_date is not null and ppa.probability_member_id is not null and pai.set_of_books_id = glsob.set_of_books_id and glsob.period_set_name = glp.period_set_name and glsob.accounted_period_type = glp.period_type

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
, GLP.PERIOD_YEAR
, GLP.QUARTER_NUM
, GLP.PERIOD_NAME
, GLP.PERIOD_SET_NAME
, GLP.PERIOD_NUM
, 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
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS PAI
, GL_PERIODS GLP
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 GLP.START_DATE
AND GLP.END_DATE
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE 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
, GLP.PERIOD_YEAR
, GLP.QUARTER_NUM
, GLP.PERIOD_NAME
, GLP.PERIOD_SET_NAME
, GLP.PERIOD_NUM
, 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
, GL_SETS_OF_BOOKS GLSOB
, PA_IMPLEMENTATIONS PAI
, GL_PERIODS GLP
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 GLP.START_DATE
AND GLP.END_DATE
AND PPA.EXPECTED_APPROVAL_DATE NOT BETWEEN GLP.START_DATE
AND GLP.END_DATE )
AND PPA.EXPECTED_APPROVAL_DATE IS NOT NULL
AND PPA.PROBABILITY_MEMBER_ID IS NOT NULL
AND PAI.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID
AND GLSOB.PERIOD_SET_NAME = GLP.PERIOD_SET_NAME
AND GLSOB.ACCOUNTED_PERIOD_TYPE = GLP.PERIOD_TYPE