[Home] [Help]
7006: bal.QUANTITY,
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
7087: to_number(null) QUANTITY,
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
7244: to_number(null) G2_OTH_COMMITTED_COST,
7245: bal.QUANTITY,
7246: bal.BILL_QUANTITY
7247: from
7248: PJI_FP_TXN_ACCUM bal,
7249: (
7250: select
7251: distinct
7252: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
7328: bal.G2_OTH_COMMITTED_COST,
7329: to_number(null) QUANTITY,
7330: to_number(null) BILL_QUANTITY
7331: from
7332: PJI_FP_TXN_ACCUM1 bal,
7333: (
7334: select
7335: distinct
7336: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
7344: where
7345: l_extraction_type = 'INCREMENTAL' and
7346: bal.PROJECT_ID = log.PROJECT_ID
7347: union all
7348: select /*+ ordered index(bal, PJI_FP_TXN_ACCUM_N2)*/
7349: -- RBS change processing actuals
7350: --modified hint for 14724124
7351: bal.TXN_ACCUM_HEADER_ID,
7352: bal.RESOURCE_CLASS_ID,
7416: bal.BILL_QUANTITY
7417: from
7418: PJI_PA_PROJ_EVENTS_LOG log,
7419: PJI_PJP_PROJ_EXTR_STATUS stat,
7420: PJI_FP_TXN_ACCUM bal
7421: where
7422: l_extraction_type = 'RBS' and
7423: log.WORKER_ID = p_worker_id and
7424: log.EVENT_TYPE = 'RBS_PUSH' and
7496: to_number(null) BILL_QUANTITY
7497: from
7498: PJI_PA_PROJ_EVENTS_LOG log,
7499: PJI_PJP_PROJ_EXTR_STATUS stat,
7500: PJI_FP_TXN_ACCUM1 bal
7501: where
7502: l_extraction_type = 'RBS' and
7503: log.WORKER_ID = p_worker_id and
7504: log.EVENT_TYPE = 'RBS_PUSH' and