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_PJP_SUM_DENORM dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 329: from PJI_PA_PROJ_EVENTS_LOG i_log,

325: decode( invert.id,
326: 1, i_log.event_object,
327: 2, i_log.attribute2
328: ) event_object_id
329: from PJI_PA_PROJ_EVENTS_LOG i_log,
330: (
331: select 1 id
332: from dual
333: UNION ALL

Line 372: from PJI_PA_PROJ_EVENTS_LOG i_log,

368: decode( invert.id,
369: 1, i_log.event_object,
370: 2, i_log.attribute1
371: ) event_object_id
372: from PJI_PA_PROJ_EVENTS_LOG i_log,
373: (
374: select 1 id
375: from dual
376: UNION ALL

Line 444: from PJI_PA_PROJ_EVENTS_LOG i_log

440: (
441: select
442: distinct
443: i_log.ATTRIBUTE1
444: from PJI_PA_PROJ_EVENTS_LOG i_log
445: where 1=1
446: and i_log.worker_id = P_WORKER_ID
447: and i_log.event_type = 'PRG_CHANGE'
448: and i_log.event_object = -1

Line 501: -- * Use PJI_PA_PROJ_EVENTS_LOG * to determine which PRG/WBS

497: --use this parameter for now
498: --
499: --
500:
501: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which PRG/WBS
502: -- data to process. ***
503:
504: prg_denorm(
505: p_worker_id,

Line 1516: from PJI_PA_PROJ_EVENTS_LOG

1512: from PA_RBS_DENORM
1513: where STRUCT_VERSION_ID in
1514: (
1515: select EVENT_OBJECT
1516: from PJI_PA_PROJ_EVENTS_LOG
1517: where 1=1
1518: and EVENT_TYPE = 'PJI_RBS_CHANGE'
1519: and WORKER_ID = P_WORKER_ID
1520: )

Line 1571: from PJI_PA_PROJ_EVENTS_LOG

1567: from PA_RBS_DENORM
1568: where STRUCT_VERSION_ID in
1569: (
1570: select EVENT_OBJECT
1571: from PJI_PA_PROJ_EVENTS_LOG
1572: where 1=1
1573: and EVENT_TYPE = 'PJI_RBS_CHANGE'
1574: and WORKER_ID = P_WORKER_ID
1575: );

Line 1585: -- * Use PJI_PA_PROJ_EVENTS_LOG * to determine which RBS

1581: -- EVENT_TYPE = 'PJI_RBS_CHANGE' ==> EVENT_OBJECT = structure version
1582: --
1583: --
1584: --
1585: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which RBS
1586: -- data to process. ***
1587: --
1588:
1589: rbs_denorm(

Line 1615: from PJI_PA_PROJ_EVENTS_LOG

1611: from PA_RBS_DENORM
1612: where STRUCT_VERSION_ID in
1613: (
1614: select EVENT_OBJECT
1615: from PJI_PA_PROJ_EVENTS_LOG
1616: where 1=1
1617: and EVENT_TYPE = 'PJI_RBS_CHANGE'
1618: and WORKER_ID = P_WORKER_ID
1619: );

Line 1999: from PJI_PA_PROJ_EVENTS_LOG i_log,

1995: decode( invert.id,
1996: 1, i_log.event_object,
1997: 2, i_log.attribute1
1998: ) event_object_id
1999: from PJI_PA_PROJ_EVENTS_LOG i_log,
2000: (
2001: select 1 id
2002: from dual
2003: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')

Line 2034: from PJI_PA_PROJ_EVENTS_LOG i_log,

2030: decode( invert.id,
2031: 1, i_log.event_object,
2032: 2, i_log.attribute1
2033: ) event_object_id
2034: from PJI_PA_PROJ_EVENTS_LOG i_log,
2035: (
2036: select 1 id
2037: from dual
2038: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')

Line 4526: from PJI_PA_PROJ_EVENTS_LOG

4522: into l_rbs_level_id
4523: from PA_RBS_ELEMENTS pvt_level,
4524: (
4525: select distinct event_type, event_object
4526: from PJI_PA_PROJ_EVENTS_LOG
4527: where 1=1
4528: and event_type = 'PJI_RBS_CHANGE'
4529: and worker_id = P_WORKER_ID
4530: ) log

Line 4644: from PJI_PA_PROJ_EVENTS_LOG log1

4640: (
4641: select
4642: distinct
4643: log1.event_type, log1.event_object
4644: from PJI_PA_PROJ_EVENTS_LOG log1
4645: where 1=1
4646: and log1.event_type = 'PJI_RBS_CHANGE'
4647: and worker_id = P_WORKER_ID
4648: ) log11

Line 4676: from PJI_PA_PROJ_EVENTS_LOG log1

4672: (
4673: select
4674: distinct
4675: log1.event_type, log1.event_object
4676: from PJI_PA_PROJ_EVENTS_LOG log1
4677: where 1=1
4678: and log1.event_type = 'PJI_RBS_CHANGE'
4679: and worker_id = P_WORKER_ID
4680: ) log11

Line 4770: from PJI_PA_PROJ_EVENTS_LOG log1

4766: begin
4767: select count(*) into l_rbs_exists1
4768: from pa_rbs_denorm den,
4769: (select distinct log1.event_object
4770: from PJI_PA_PROJ_EVENTS_LOG log1
4771: where 1=1
4772: and log1.event_type = 'PJI_RBS_CHANGE'
4773: and worker_id = P_WORKER_ID)
4774: log11

Line 4871: from PJI_PA_PROJ_EVENTS_LOG log1

4867: begin
4868: select count(*) into l_rbs_exists2
4869: from pa_rbs_denorm den,
4870: (select distinct log1.event_object
4871: from PJI_PA_PROJ_EVENTS_LOG log1
4872: where 1=1
4873: and log1.event_type = 'PJI_RBS_CHANGE'
4874: and worker_id = P_WORKER_ID)
4875: log11

Line 4972: from PJI_PA_PROJ_EVENTS_LOG log1

4968: begin
4969: select count(*) into l_rbs_exists3
4970: from pa_rbs_denorm den,
4971: (select distinct log1.event_object
4972: from PJI_PA_PROJ_EVENTS_LOG log1
4973: where 1=1
4974: and log1.event_type = 'PJI_RBS_CHANGE'
4975: and worker_id = P_WORKER_ID)
4976: log11

Line 6223: from PJI_PA_PROJ_EVENTS_LOG

6219: into l_rbs_level_id
6220: from PA_RBS_ELEMENTS pvt_level,
6221: (
6222: select distinct event_type, event_object
6223: from PJI_PA_PROJ_EVENTS_LOG
6224: where 1=1
6225: and event_type = 'PJI_RBS_CHANGE'
6226: and worker_id = P_WORKER_ID
6227: ) log

Line 6291: from PJI_PA_PROJ_EVENTS_LOG log1

6287: (
6288: select
6289: distinct
6290: log1.event_type, log1.event_object
6291: from PJI_PA_PROJ_EVENTS_LOG log1
6292: where 1=1
6293: and log1.event_type = 'PJI_RBS_CHANGE'
6294: and worker_id = P_WORKER_ID
6295: ) log11