DBA Data[Home] [Help]

APPS.PJI_PJP_GEN_PERF_ALL dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 2392: PJI_PA_PROJ_EVENTS_LOG log

2388: distinct
2389: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
2390: to_number(log.ATTRIBUTE1) PROJECT_ID
2391: from
2392: PJI_PA_PROJ_EVENTS_LOG log
2393: where
2394: log.WORKER_ID = p_worker_id and
2395: log.EVENT_TYPE = 'RBS_ASSOC'
2396: ) log

Line 2476: PJI_PA_PROJ_EVENTS_LOG log

2472: distinct
2473: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
2474: to_numbeR(log.ATTRIBUTE1) PROJECT_ID
2475: from
2476: PJI_PA_PROJ_EVENTS_LOG log
2477: where
2478: log.WORKER_ID = p_worker_id and
2479: log.EVENT_TYPE = 'RBS_ASSOC'
2480: ) log

Line 2553: PJI_PA_PROJ_EVENTS_LOG log,

2549: to_number(null) G2_OTH_COMMITTED_COST,
2550: bal.QUANTITY,
2551: bal.BILL_QUANTITY
2552: from
2553: PJI_PA_PROJ_EVENTS_LOG log,
2554: PJI_PJP_PROJ_EXTR_STATUS stat,
2555: PJI_FP_TXN_ACCUM bal
2556: where
2557: p_extraction_type = 'RBS' and

Line 2632: PJI_PA_PROJ_EVENTS_LOG log,

2628: bal.G2_OTH_COMMITTED_COST,
2629: to_number(null) QUANTITY,
2630: to_number(null) BILL_QUANTITY
2631: from
2632: PJI_PA_PROJ_EVENTS_LOG log,
2633: PJI_PJP_PROJ_EXTR_STATUS stat,
2634: PJI_FP_TXN_ACCUM1 bal
2635: where
2636: p_extraction_type = 'RBS' and

Line 3048: PJI_PA_PROJ_EVENTS_LOG log

3044: distinct
3045: to_number(log.EVENT_OBJECT) RBS_VERSION_ID,
3046: to_number(log.ATTRIBUTE1) PROJECT_ID
3047: from
3048: PJI_PA_PROJ_EVENTS_LOG log
3049: where
3050: log.WORKER_ID = p_worker_id and
3051: log.EVENT_TYPE = 'RBS_ASSOC'
3052: ) log

Line 4236: PJI_PA_PROJ_EVENTS_LOG log,

4232: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
4233: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
4234: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
4235: from
4236: PJI_PA_PROJ_EVENTS_LOG log,
4237: PJI_PJP_WBS_HEADER wbs_hdr,
4238: PJI_XBS_DENORM_DELTA wbs,
4239: PJI_XBS_DENORM prg,
4240: PJI_FP_XBS_ACCUM_F fpr,

Line 5551: PJI_PA_PROJ_EVENTS_LOG log,

5547: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
5548: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
5549: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
5550: from
5551: PJI_PA_PROJ_EVENTS_LOG log,
5552: PJI_PJP_WBS_HEADER wbs_hdr,
5553: PJI_XBS_DENORM_DELTA wbs,
5554: PJI_XBS_DENORM prg,
5555: PJI_FP_XBS_ACCUM_F fpr,

Line 6866: PJI_PA_PROJ_EVENTS_LOG log,

6862: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
6863: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
6864: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
6865: from
6866: PJI_PA_PROJ_EVENTS_LOG log,
6867: PJI_PJP_WBS_HEADER wbs_hdr,
6868: PJI_XBS_DENORM_DELTA wbs,
6869: PJI_XBS_DENORM prg,
6870: PJI_FP_XBS_ACCUM_F fpr,

Line 8180: PJI_PA_PROJ_EVENTS_LOG log,

8176: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
8177: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
8178: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
8179: from
8180: PJI_PA_PROJ_EVENTS_LOG log,
8181: PJI_PJP_WBS_HEADER wbs_hdr,
8182: PJI_XBS_DENORM_DELTA wbs,
8183: PJI_XBS_DENORM prg,
8184: PJI_FP_XBS_ACCUM_F fpr,

Line 9494: PJI_PA_PROJ_EVENTS_LOG log,

9490: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
9491: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
9492: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
9493: from
9494: PJI_PA_PROJ_EVENTS_LOG log,
9495: PJI_PJP_WBS_HEADER wbs_hdr,
9496: PJI_XBS_DENORM_DELTA wbs,
9497: PJI_XBS_DENORM prg,
9498: PJI_FP_XBS_ACCUM_F fpr,

Line 10808: PJI_PA_PROJ_EVENTS_LOG log,

10804: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
10805: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
10806: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
10807: from
10808: PJI_PA_PROJ_EVENTS_LOG log,
10809: PJI_PJP_WBS_HEADER wbs_hdr,
10810: PJI_XBS_DENORM_DELTA wbs,
10811: PJI_XBS_DENORM prg,
10812: PJI_FP_XBS_ACCUM_F fpr,

Line 12122: PJI_PA_PROJ_EVENTS_LOG log,

12118: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
12119: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
12120: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
12121: from
12122: PJI_PA_PROJ_EVENTS_LOG log,
12123: PJI_PJP_WBS_HEADER wbs_hdr,
12124: PJI_XBS_DENORM_DELTA wbs,
12125: PJI_XBS_DENORM prg,
12126: PJI_FP_XBS_ACCUM_F fpr,

Line 13436: PJI_PA_PROJ_EVENTS_LOG log,

13432: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
13433: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
13434: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
13435: from
13436: PJI_PA_PROJ_EVENTS_LOG log,
13437: PJI_PJP_WBS_HEADER wbs_hdr,
13438: PJI_XBS_DENORM_DELTA wbs,
13439: PJI_XBS_DENORM prg,
13440: PJI_FP_XBS_ACCUM_F fpr,

Line 14750: PJI_PA_PROJ_EVENTS_LOG log,

14746: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
14747: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
14748: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
14749: from
14750: PJI_PA_PROJ_EVENTS_LOG log,
14751: PJI_PJP_WBS_HEADER wbs_hdr,
14752: PJI_XBS_DENORM_DELTA wbs,
14753: PJI_XBS_DENORM prg,
14754: PJI_FP_XBS_ACCUM_F fpr,

Line 16064: PJI_PA_PROJ_EVENTS_LOG log,

16060: wbs.SIGN * fpr.CUSTOM13 CUSTOM13,
16061: wbs.SIGN * fpr.CUSTOM14 CUSTOM14,
16062: wbs.SIGN * fpr.CUSTOM15 CUSTOM15
16063: from
16064: PJI_PA_PROJ_EVENTS_LOG log,
16065: PJI_PJP_WBS_HEADER wbs_hdr,
16066: PJI_XBS_DENORM_DELTA wbs,
16067: PJI_XBS_DENORM prg,
16068: PJI_FP_XBS_ACCUM_F fpr,