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_ROLLUP dependencies on PJI_PJP_RBS_HEADER

Line 3618: PJI_PJP_RBS_HEADER rbs_hdr,

3614: 'CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
3615: from
3616: PA_XBS_DENORM prg,
3617: PA_PROJ_ELEMENTS emt,
3618: PJI_PJP_RBS_HEADER rbs_hdr,
3619: PJI_PA_PROJ_EVENTS_LOG log
3620: where
3621: prg.SUP_PROJECT_ID = c.PROJECT_ID and
3622: (prg.SUB_EMT_ID = prg.SUB_ROLLUP_ID or

Line 4891: PJI_PJP_RBS_HEADER rbs_hdr

4887: rbs_hdr.PROJECT_ID,
4888: rbs_hdr.PLAN_VERSION_ID,
4889: rbs_hdr.RBS_VERSION_ID
4890: from PJI_PA_PROJ_EVENTS_LOG log,
4891: PJI_PJP_RBS_HEADER rbs_hdr
4892: where log.WORKER_ID = p_worker_id
4893: and ( (log.EVENT_TYPE = 'RBS_PUSH' and rbs_hdr.RBS_VERSION_ID = log.ATTRIBUTE2)
4894: or (log.EVENT_TYPE = 'RBS_DELETE' and rbs_hdr.RBS_VERSION_ID = log.EVENT_OBJECT)));
4895: -- Bug 12420151 -- Commented below select

Line 4901: PJI_PJP_RBS_HEADER rbs_hdr

4897: rbs_hdr.PROJECT_ID,
4898: rbs_hdr.PLAN_VERSION_ID,
4899: rbs_hdr.RBS_VERSION_ID
4900: from PJI_PA_PROJ_EVENTS_LOG log,
4901: PJI_PJP_RBS_HEADER rbs_hdr
4902: where log.WORKER_ID = p_worker_id and
4903: log.EVENT_TYPE = 'RBS_PUSH' and
4904: rbs_hdr.RBS_VERSION_ID =
4905: log.ATTRIBUTE2

Line 4912: PJI_PJP_RBS_HEADER rbs_hdr

4908: rbs_hdr.PROJECT_ID,
4909: rbs_hdr.PLAN_VERSION_ID,
4910: rbs_hdr.RBS_VERSION_ID
4911: from PJI_PA_PROJ_EVENTS_LOG log,
4912: PJI_PJP_RBS_HEADER rbs_hdr
4913: where log.WORKER_ID = p_worker_id and
4914: log.EVENT_TYPE = 'RBS_DELETE' and
4915: rbs_hdr.RBS_VERSION_ID = log.EVENT_OBJECT); */
4916:

Line 4967: from PJI_PJP_RBS_HEADER

4963:
4964: elsif (l_extraction_type = 'RBS') then
4965:
4966: delete
4967: from PJI_PJP_RBS_HEADER
4968: where RBS_VERSION_ID in (select distinct
4969: log.EVENT_OBJECT
4970: from PJI_PA_PROJ_EVENTS_LOG log
4971: where log.WORKER_ID = p_worker_id and

Line 5197: insert into PJI_PJP_RBS_HEADER

5193: l_project_id_tbl.delete;
5194:
5195: end if;
5196:
5197: insert into PJI_PJP_RBS_HEADER
5198: (
5199: PROJECT_ID,
5200: PLAN_VERSION_ID,
5201: RBS_VERSION_ID,

Line 5233: PJI_PJP_RBS_HEADER rbs_hdr

5229: (
5230: select
5231: 1
5232: from
5233: PJI_PJP_RBS_HEADER rbs_hdr
5234: where
5235: rbs_hdr.PROJECT_ID = c.PROJECT_ID and
5236: rbs_hdr.PLAN_VERSION_ID = -1 and
5237: rbs_hdr.RBS_VERSION_ID = c.RBS_VERSION_ID

Line 5251: insert into PJI_PJP_RBS_HEADER

5247: l_return_status);
5248:
5249: end if;
5250:
5251: insert into PJI_PJP_RBS_HEADER
5252: (
5253: PROJECT_ID,
5254: PLAN_VERSION_ID,
5255: RBS_VERSION_ID,

Line 5283: PJI_PJP_RBS_HEADER rbs_hdr

5279: 'A'
5280: from
5281: PJI_PJP_PROJ_BATCH_MAP map,
5282: PA_RBS_PRJ_ASSIGNMENTS asg,
5283: PJI_PJP_RBS_HEADER rbs_hdr
5284: where
5285: map.WORKER_ID = p_worker_id and
5286: asg.PROJECT_ID = map.PROJECT_ID and
5287: asg.REPORTING_USAGE_FLAG = 'Y' and

Line 5293: insert into PJI_PJP_RBS_HEADER

5289: -1 = rbs_hdr.PLAN_VERSION_ID (+) and
5290: asg.RBS_VERSION_ID = rbs_hdr.RBS_VERSION_ID (+) and
5291: rbs_hdr.PROJECT_ID is null;
5292:
5293: insert into PJI_PJP_RBS_HEADER
5294: (
5295: PROJECT_ID,
5296: PLAN_VERSION_ID,
5297: RBS_VERSION_ID,

Line 5371: update PJI_PJP_RBS_HEADER

5367: end if;
5368:
5369: end if;
5370:
5371: update PJI_PJP_RBS_HEADER
5372: set RBS_VERSION_ID = c.RBS_VERSION_ID,
5373: REPORTING_USAGE_FLAG = c.REPORTING_USAGE_FLAG,
5374: PROG_REP_USAGE_FLAG = c.PROG_REP_USAGE_FLAG,
5375: LAST_UPDATE_DATE = l_last_update_date,

Line 5385: insert into PJI_PJP_RBS_HEADER

5381: c.UPDATE_HEADER_ONLY_FLAG = 'MARK_AS_PROG_REP';
5382:
5383: if (sql%rowcount = 0) then
5384:
5385: insert into PJI_PJP_RBS_HEADER
5386: (
5387: PROJECT_ID,
5388: PLAN_VERSION_ID,
5389: RBS_VERSION_ID,

Line 5491: update PJI_PJP_RBS_HEADER

5487: l_project_id_tbl.delete;
5488:
5489: end if;
5490:
5491: update PJI_PJP_RBS_HEADER
5492: set RBS_VERSION_ID = c.RBS_VERSION_ID,
5493: LAST_UPDATE_DATE = l_last_update_date,
5494: LAST_UPDATED_BY = l_last_updated_by,
5495: LAST_UPDATE_LOGIN = l_last_update_login

Line 5502: insert into PJI_PJP_RBS_HEADER

5498: PLAN_VERSION_ID = -1;
5499:
5500: if (sql%rowcount = 0) then
5501:
5502: insert into PJI_PJP_RBS_HEADER
5503: (
5504: PROJECT_ID,
5505: PLAN_VERSION_ID,
5506: RBS_VERSION_ID,

Line 5601: update PJI_PJP_RBS_HEADER

5597: l_project_id_tbl.delete;
5598:
5599: end if;
5600:
5601: update PJI_PJP_RBS_HEADER
5602: set RBS_VERSION_ID = c.RBS_VERSION_ID,
5603: LAST_UPDATE_DATE = l_last_update_date,
5604: LAST_UPDATED_BY = l_last_updated_by,
5605: LAST_UPDATE_LOGIN = l_last_update_login

Line 6074: PJI_PJP_RBS_HEADER sup_rbs_hdr,

6070: null ATTRIBUTE19, -- update header only
6071: 'NEW_CONVERTED_RBS_PRG_EVENT' ATTRIBUTE20 -- flg converted events
6072: from
6073: PJI_XBS_DENORM_DELTA prg,
6074: PJI_PJP_RBS_HEADER sup_rbs_hdr,
6075: PA_PROJ_ELEMENT_VERSIONS sub_ver,
6076: PA_RBS_VERSIONS_B hdr
6077: where
6078: prg.STRUCT_TYPE = 'PRG' and

Line 6087: PJI_PJP_RBS_HEADER sub_rbs_hdr,

6083: sup_rbs_hdr.PROG_REP_USAGE_FLAG = 'Y' and
6084: sub_ver.ELEMENT_VERSION_ID = prg.SUB_ID and
6085: hdr.RBS_VERSION_ID = sup_rbs_hdr.RBS_VERSION_ID
6086: ) evt,
6087: PJI_PJP_RBS_HEADER sub_rbs_hdr,
6088: PJI_PA_PROJ_EVENTS_LOG log
6089: where
6090: evt.ATTRIBUTE1 = sub_rbs_hdr.PROJECT_ID (+) and
6091: -1 = sub_rbs_hdr.PLAN_VERSION_ID (+) and

Line 6154: insert into PJI_PJP_RBS_HEADER

6150: l_project_id_tbl.delete;
6151:
6152: end if;
6153:
6154: insert into PJI_PJP_RBS_HEADER
6155: (
6156: PROJECT_ID,
6157: PLAN_VERSION_ID,
6158: RBS_VERSION_ID,

Line 6940: select /+ ordered cardinality(MAP 1) use_nl(BAL) index (rbs_hdr, PJI_PJP_RBS_HEADER_N1) / -- Modified for Bug 14735308

6936: sum(src1.QUANTITY) QUANTITY,
6937: sum(src1.BILL_QUANTITY) BILL_QUANTITY
6938: from
6939: (
6940: select /*+ ordered cardinality(MAP 1) use_nl(BAL) index (rbs_hdr, PJI_PJP_RBS_HEADER_N1) */ -- Modified for Bug 14735308
6941: -- initial actuals data /* Added for bug 9836218 */ /* modified hint for 14724124 */
6942: bal.TXN_ACCUM_HEADER_ID,
6943: bal.RESOURCE_CLASS_ID,
6944: bal.PROJECT_ID,

Line 7011: PJI_PJP_RBS_HEADER rbs_hdr

7007: bal.BILL_QUANTITY
7008: from
7009: PJI_PJP_PROJ_BATCH_MAP map,
7010: PJI_FP_TXN_ACCUM bal,
7011: PJI_PJP_RBS_HEADER rbs_hdr
7012: where
7013: l_extraction_type in ('FULL', 'PARTIAL') and
7014: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
7015: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 7021: select /+ ordered cardinality(MAP 1) use_nl(BAL) index (rbs_hdr, PJI_PJP_RBS_HEADER_N1) / -- Modified for Bug 14735308

7017: bal.PROJECT_ID = map.PROJECT_ID and
7018: bal.PROJECT_ID = rbs_hdr.PROJECT_ID and
7019: -1 = rbs_hdr.PLAN_VERSION_ID
7020: union all -- initial commitments data
7021: select /*+ ordered cardinality(MAP 1) use_nl(BAL) index (rbs_hdr, PJI_PJP_RBS_HEADER_N1) */ -- Modified for Bug 14735308
7022: --added hint for 14724124
7023: bal.TXN_ACCUM_HEADER_ID,
7024: to_number(null) RESOURCE_CLASS_ID,
7025: bal.PROJECT_ID,

Line 7092: PJI_PJP_RBS_HEADER rbs_hdr

7088: to_number(null) BILL_QUANTITY
7089: from
7090: PJI_PJP_PROJ_BATCH_MAP map,
7091: PJI_FP_TXN_ACCUM1 bal,
7092: PJI_PJP_RBS_HEADER rbs_hdr
7093: where
7094: l_extraction_type in ('FULL', 'PARTIAL') and
7095: -- decode(l_extraction_type,'FULL','Y','PARTIAL',decode(bitand(l_refresh_code,1),1,'Y','N'),'N') ='Y' and -- Bug#5099574
7096: -- l_plan_type_id IS NULL and -- Bug#5099574

Line 7172: PJI_PJP_RBS_HEADER rbs_hdr

7168: tmp7.BILL_QUANTITY
7169: from
7170: (select distinct STG_ROWID, worker_id from PJI_PJP_RMAP_FPR) tmp7_r, -- Added for bug 16383776
7171: PJI_FM_AGGR_FIN7 tmp7,
7172: PJI_PJP_RBS_HEADER rbs_hdr
7173: where
7174: l_extraction_type = 'INCREMENTAL' and
7175: tmp7_r.WORKER_ID = p_worker_id and
7176: tmp7_r.STG_ROWID = tmp7.ROWID and

Line 13558: PJI_PJP_RBS_HEADER rbs_hdr,

13554: sum(pjp1.CUSTOM15) CUSTOM15
13555: from
13556: PJI_FP_AGGR_PJP1 pjp1,
13557: PJI_ROLLUP_LEVEL_STATUS ss,
13558: PJI_PJP_RBS_HEADER rbs_hdr,
13559: PJI_PJP_WBS_HEADER wbs_hdr,
13560: PA_RBS_DENORM rbs
13561: where
13562: l_extraction_type <> 'RBS' and

Line 14013: PJI_PJP_RBS_HEADER rbs_hdr,

14009: sum(pjp1.CUSTOM15) CUSTOM15
14010: from
14011: PJI_FP_AGGR_PJP1_T pjp1,
14012: PJI_ROLLUP_LEVEL_STATUS ss,
14013: PJI_PJP_RBS_HEADER rbs_hdr,
14014: PJI_PJP_WBS_HEADER wbs_hdr,
14015: PA_RBS_DENORM rbs
14016: where
14017: -- l_extraction_type <> 'RBS' and