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.

APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_PROJECTS_ALL

Line 902: pa_projects_all p1

898: nvl(p_incremental_mode,'N') = 'N'
899: and object_type = 'PA_STRUCTURES'
900: and prg_group is not null
901: and exists ( select 'x' from
902: pa_projects_all p1
903: where p1.project_id = ver.project_id
904: and nvl(p1.org_id,-1) = nvl(P_OPERATING_UNIT,nvl(p1.org_id,-1)))
905: group by prg_group
906: union all

Line 1316: from pa_projects_all a

1312:
1313: l_budget_lines_cnt := 0;
1314:
1315: For k in (select a.project_id
1316: from pa_projects_all a
1317: where nvl(p_incremental_mode,'N') = 'N'
1318: and template_flag = 'N' -- Bug 9059688
1319: and nvl(a.org_id,-1) = nvl(p_operating_unit,nvl(a.org_id,-1))
1320: --added for 12.1.3 feature for new parameter Project Status

Line 1453: from pa_projects_all a

1449: else
1450: /* Code added for bug 8416116 ends */
1451:
1452: For k in ( select a.project_id
1453: from pa_projects_all a
1454: where ( nvl(p_incremental_mode,'N') = 'N' and g_launch_type <> 'RPPD' ) -- sridhar_phase_1 p_wbs_temp_table_size <> 666666
1455: and template_flag = 'N' -- Bug 9059688
1456: and nvl(a.org_id,-1) = nvl(p_operating_unit,nvl(a.org_id,-1))
1457: and

Line 1464: from pji_launch_incr a, pa_projects_all b /* added for bug 9712797 */

1460: ( select 'x'
1461: from pji_prg_group b where a.project_id = b.project_id )
1462: union all
1463: select a.project_id
1464: from pji_launch_incr a, pa_projects_all b /* added for bug 9712797 */
1465: where ( nvl(p_incremental_mode,'N') = 'Y' or g_launch_type = 'RPPD' ) -- sridhar_phase_1 p_wbs_temp_table_size = 666666
1466: and a. project_id = b.project_id /* added for bug 9712797 */
1467: -- Moved following condition to the next line for UPPD case. Not applicable for RPPD case
1468: -- and nvl(b.project_status_code,'PS') = nvl(p_project_status,nvl(b.project_status_code,'PS')) /* added for bug 9712797 */

Line 1594: ) GROUP BY project_id ) t1 , pa_projects_all p1

1590: sum(decode(incr_type, 'VAL_ACT_FC_COST',1,0)) FC_COST /* Added for bug 12328939 */
1591: from
1592: ( select distinct incr_type , project_id
1593: FROM PJI_LAUNCH_INCR where incr_type like 'VAL%'
1594: ) GROUP BY project_id ) t1 , pa_projects_all p1
1595: where p1.project_id = t1.project_id
1596: order by p1.segment1 ;
1597:
1598: BEGIN

Line 1684: pa_projects_all ppa

1680: SELECT DISTINCT pa.project_id project_id
1681: FROM (SELECT a.project_id ,
1682: SUM (a.total_accrued_amount) total_rev
1683: FROM pa_summary_project_fundings a,
1684: pa_projects_all ppa
1685: where PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1686: and a.project_id = ppa.project_id
1687: GROUP BY a.project_id
1688: )

Line 1695: pa_projects_all ppa

1691: ,sum(pf.projfunc_allocated_amount) Net_fund
1692: FROM pa_project_fundings pf
1693: ,pa_agreements_all agr
1694: ,pa_project_customers cust,
1695: pa_projects_all ppa
1696: WHERE 1=1
1697: and pf.project_id = ppa.project_id
1698: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1699: AND pf.agreement_id = agr.agreement_id

Line 1713: pa_projects_all ppa

1709: + additional_funding_amount
1710: + cancelled_funding_amount
1711: + funding_adjustment_amount) total_fund
1712: FROM pji_ac_xbs_accum_f f,
1713: pa_projects_all ppa
1714: WHERE f.project_id = ppa.project_id
1715: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1716: AND f.currency_code = ppa.projfunc_currency_code
1717: AND time_id = -1

Line 1723: pa_projects_all pa,

1719: AND initial_funding_amount IS NOT NULL
1720: GROUP BY f.project_id
1721: )
1722: report ,
1723: pa_projects_all pa,
1724: pa_project_statuses pps
1725: WHERE pa.project_id = base_fund.project_id
1726: and pa.project_id = base_rev.project_id
1727: AND base_rev.project_id = report.project_id

Line 1745: pa_projects_all ppa

1741: budgets.cost - reporting.cost cost_diff_budgets
1742: FROM (SELECT ver.project_id,
1743: sum(ver.burdened_cost) cost
1744: FROM pa_budget_versions ver,
1745: pa_projects_all ppa
1746: WHERE ver.budget_status_code = 'B'
1747: and ver.project_id = ppa.project_id
1748: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1749: AND ver.current_flag = 'Y'

Line 1758: pa_projects_all p

1754: LEFT OUTER JOIN
1755: (SELECT f.project_id, p.project_status_code,
1756: Sum(brdn_cost) cost
1757: FROM pji_fp_xbs_accum_f f,
1758: pa_projects_all p
1759: WHERE plan_version_id = -3
1760: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1761: AND rbs_aggr_level = 'T'
1762: AND wbs_rollup_flag = 'Y'

Line 1772: ON budgets.project_id = reporting.project_id ) costbud, pa_projects_all pa

1768: WHERE approved_cost_plan_type_flag = 'Y')
1769: AND f.currency_code = p.projfunc_currency_code
1770: AND f.project_id = p.project_id
1771: GROUP BY f.project_id, p.project_status_code) reporting
1772: ON budgets.project_id = reporting.project_id ) costbud, pa_projects_all pa
1773: where nvl(costbud.BUDGET_COST, 0) <> nvl(costbud.REPORTING_COST, 0)
1774: AND pa.project_id = costbud.project_id
1775: AND pa.template_flag = 'N'
1776: AND pa.org_id = nvl(p_operating_unit, pa.org_id )

Line 1790: pa_projects_all ppa

1786: budgets.revenue - reporting.revenue rev_diff_budgets
1787: FROM (SELECT ver.project_id,
1788: sum(ver.revenue) revenue
1789: FROM pa_budget_versions ver,
1790: pa_projects_all ppa
1791: WHERE ver.budget_status_code = 'B'
1792: and ver.project_id = ppa.project_id
1793: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1794: AND ver.current_flag = 'Y'

Line 1803: pa_projects_all p

1799: LEFT OUTER JOIN
1800: (SELECT f.project_id, p.project_status_code,
1801: Sum(revenue) revenue
1802: FROM pji_fp_xbs_accum_f f,
1803: pa_projects_all p
1804: WHERE plan_version_id = -3
1805: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1806: AND rbs_aggr_level = 'T'
1807: AND wbs_rollup_flag = 'Y'

Line 1817: ON budgets.project_id = reporting.project_id ) revbud, pa_projects_all pa

1813: WHERE approved_rev_plan_type_flag = 'Y')
1814: AND f.currency_code = p.projfunc_currency_code
1815: AND f.project_id = p.project_id
1816: group by f.project_id, p.project_status_code) reporting
1817: ON budgets.project_id = reporting.project_id ) revbud, pa_projects_all pa
1818: where nvl(revbud.BUDGET_REVENUE, 0) <> nvl(revbud.REPORTING_REVENUE, 0)
1819: AND pa.project_id = revbud.project_id
1820: AND pa.template_flag = 'N'
1821: AND pa.org_id = nvl(p_operating_unit, pa.org_id )

Line 1828: FROM pa_projects_all p1 ,

1824:
1825: -- For Actuals
1826: CURSOR get_proj_cost IS
1827: SELECT distinct p1.project_id
1828: FROM pa_projects_all p1 ,
1829: (SELECT
1830: /*+ ordered */
1831: SUM(cdl.burdened_cost) amt,
1832: pa.project_id

Line 1833: FROM pa_projects_all pa,

1829: (SELECT
1830: /*+ ordered */
1831: SUM(cdl.burdened_cost) amt,
1832: pa.project_id
1833: FROM pa_projects_all pa,
1834: pa_cost_distribution_lines_all cdl
1835: WHERE pa.template_flag = 'N'
1836: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(pa.project_status_code,'STATUS_REPORTING') = 'Y'
1837: AND pa.project_id = cdl.project_id

Line 1847: FROM pa_projects_all p ,

1843: (SELECT
1844: /*+ ordered */
1845: brdn_cost amt,
1846: f.project_id
1847: FROM pa_projects_all p ,
1848: pji_fp_xbs_accum_f f
1849: WHERE p.project_id = f.project_id
1850: and PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(p.project_status_code,'STATUS_REPORTING') = 'Y'
1851: AND f.currency_code = p.projfunc_currency_code

Line 1876: FROM pa_projects_all p1 ,

1872: /* Added for bug 12328939 starts */
1873: -- For Workplan Actuals
1874: CURSOR get_proj_wp_cost IS
1875: SELECT distinct p1.project_id
1876: FROM pa_projects_all p1 ,
1877: (SELECT project_id,
1878: Sum(Nvl(act_labor_hrs,0)) act_ppl_effort,
1879: Sum(Nvl(act_equip_hrs,0)) act_eq_effort,
1880: Sum(Nvl(act_raw_cost,0)) act_raw_cost,

Line 1926: FROM pa_projects_all p1 ,

1922: or l_run_type <> 'REFRESH') ;
1923: -- For Cost Forecast Actuals
1924: CURSOR get_proj_fc_cost IS
1925: SELECT distinct p1.project_id
1926: FROM pa_projects_all p1 ,
1927: (SELECT project_id,
1928: Sum(Nvl(act_labor_hrs,0)) act_ppl_effort,
1929: Sum(Nvl(act_equip_hrs,0)) act_eq_effort,
1930: Sum(Nvl(act_raw_cost,0)) act_raw_cost,

Line 2342: pa_projects_all p1

2338: log.EVENT_TYPE = 'PRG_CHANGE' AND
2339: log.EVENT_OBJECT <> - 1 AND
2340: ver.PRG_GROUP IN (log.EVENT_OBJECT, log.ATTRIBUTE1)
2341: and exists ( select 'x' from
2342: pa_projects_all p1
2343: where p1.project_id = ver.project_id
2344: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2345:
2346: --

Line 2371: pa_projects_all p1

2367: WHERE grp2.incr_type = 'PROJ_BASE'
2368: AND grp2.prg_group = - 1
2369: AND grp2.project_id = to_number(log.attribute1) )
2370: and exists ( select 'x' from
2371: pa_projects_all p1
2372: where p1.project_id = to_number(log.attribute1)
2373: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2374:
2375: --

Line 2398: pa_projects_all p1

2394: WHERE grp2.incr_type = 'PROJ_BASE'
2395: AND grp2.prg_group = - 1
2396: AND grp2.project_id = to_number(log.attribute1) )
2397: and exists ( select 'x' from
2398: pa_projects_all p1
2399: where p1.project_id = to_number(log.attribute1)
2400: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2401:
2402: --

Line 2427: pa_projects_all p1

2423: WHERE grp2.incr_type = 'PROJ_BASE'
2424: AND grp2.prg_group = - 1
2425: AND grp2.project_id = asg.project_id )
2426: and exists ( select 'x' from
2427: pa_projects_all p1
2428: where p1.project_id = asg.project_id
2429: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2430:
2431: --

Line 2456: pa_projects_all p1

2452: WHERE grp2.incr_type = 'PROJ_BASE'
2453: AND grp2.prg_group = - 1
2454: AND grp2.project_id = asg.project_id )
2455: and exists ( select 'x' from
2456: pa_projects_all p1
2457: where p1.project_id = asg.project_id
2458: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1))) ;
2459:
2460: -- INSERT 005

Line 2503: pa_projects_all p1

2499: WHERE grp2.incr_type = 'PROJ_BASE'
2500: AND grp2.prg_group = - 1
2501: AND grp2.project_id = a1.project_id )
2502: and exists ( select 'x' from
2503: pa_projects_all p1
2504: where p1.project_id = a1.project_id
2505: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2506:
2507: -- INSERT 007

Line 2525: pa_projects_all p1

2521: WHERE grp2.incr_type = 'PROJ_BASE'
2522: AND grp2.prg_group = - 1
2523: AND grp2.project_id = a1.project_id )
2524: and exists ( select 'x' from
2525: pa_projects_all p1
2526: where p1.project_id = a1.project_id
2527: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2528:
2529: INSERT INTO PJI_LAUNCH_INCR

Line 2547: pa_projects_all p1

2543: WHERE grp2.incr_type = 'PROJ_BASE'
2544: AND grp2.prg_group = - 1
2545: AND grp2.project_id = a1.project_id )
2546: and exists ( select 'x' from
2547: pa_projects_all p1
2548: where p1.project_id = a1.project_id
2549: and nvl(p1.org_id,-1) = nvl(p_operating_unit,nvl(p1.org_id,-1)));
2550:
2551: --