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_FM_SUM_ROLLUP_FIN dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 29: PJI_PJI_PROJ_BATCH_MAP map,

25: select
26: p_worker_id WORKER_ID,
27: fin9.ROWID STG_ROWID
28: from
29: PJI_PJI_PROJ_BATCH_MAP map,
30: PJI_FM_AGGR_FIN9 fin9
31: where
32: map.WORKER_ID = p_worker_id and
33: fin9.PROJECT_ID = map.PROJECT_ID;

Line 470: PJI_PJI_PROJ_BATCH_MAP map

466: select
467: map.PROJECT_ID,
468: map.NEW_PROJECT_ORGANIZATION_ID
469: from
470: PJI_PJI_PROJ_BATCH_MAP map
471: where
472: map.NEW_PROJECT_ORGANIZATION_ID <> map.PROJECT_ORGANIZATION_ID
473: ) map
474: where

Line 2146: PJI_PJI_PROJ_BATCH_MAP map,

2142: then -fpp.FORECAST_LABOR_HRS
2143: else to_number(null)
2144: end FORECAST_LABOR_HRS
2145: from
2146: PJI_PJI_PROJ_BATCH_MAP map,
2147: PJI_FP_PROJ_F fpp
2148: where
2149: l_extraction_type <> 'FULL' and
2150: map.WORKER_ID = p_worker_id and

Line 2533: PJI_PJI_PROJ_BATCH_MAP map,

2529: then -fpp.FORECAST_LABOR_HRS
2530: else to_number(null)
2531: end FORECAST_LABOR_HRS
2532: from
2533: PJI_PJI_PROJ_BATCH_MAP map,
2534: PJI_FP_PROJ_F fpp
2535: where
2536: l_extraction_type <> 'FULL' and
2537: map.WORKER_ID = p_worker_id and

Line 2923: PJI_PJI_PROJ_BATCH_MAP map,

2919: then -fpp.FORECAST_LABOR_HRS
2920: else to_number(null)
2921: end FORECAST_LABOR_HRS
2922: from
2923: PJI_PJI_PROJ_BATCH_MAP map,
2924: PJI_FP_PROJ_F fpp
2925: where
2926: l_extraction_type <> 'FULL' and
2927: map.WORKER_ID = p_worker_id and

Line 3247: PJI_PJI_PROJ_BATCH_MAP map,

3243: then -fpp.FORECAST_LABOR_HRS
3244: else to_number(null)
3245: end FORECAST_LABOR_HRS
3246: from
3247: PJI_PJI_PROJ_BATCH_MAP map,
3248: PJI_FP_PROJ_F fpp
3249: where
3250: l_extraction_type <> 'FULL' and
3251: map.WORKER_ID = p_worker_id and

Line 3543: PJI_PJI_PROJ_BATCH_MAP map,

3539: -fpw.BILL_LABOR_HRS,
3540: -fpw.QUANTITY,
3541: -fpw.BILL_QUANTITY
3542: from
3543: PJI_PJI_PROJ_BATCH_MAP map,
3544: PJI_FP_PROJ_ET_WT_F fpw
3545: where
3546: l_extraction_type = 'PARTIAL' and
3547: map.WORKER_ID = p_worker_id and

Line 4042: PJI_PJI_PROJ_BATCH_MAP map,

4038: -fpe.BILL_LABOR_HRS,
4039: -fpe.QUANTITY,
4040: -fpe.BILL_QUANTITY
4041: from
4042: PJI_PJI_PROJ_BATCH_MAP map,
4043: PJI_FP_PROJ_ET_F fpe
4044: where
4045: l_extraction_type = 'PARTIAL' and
4046: map.WORKER_ID = p_worker_id and

Line 4626: PJI_PJI_PROJ_BATCH_MAP map,

4622: to_number(null) FORECAST_RAW_COST,
4623: to_number(null) FORECAST_BURDENED_COST,
4624: to_number(null) FORECAST_LABOR_HRS
4625: from
4626: PJI_PJI_PROJ_BATCH_MAP map,
4627: PJI_FP_PROJ_F fpp
4628: where
4629: l_extraction_type = 'PARTIAL' and
4630: map.WORKER_ID = p_worker_id and

Line 4992: FROM PJI_PJI_PROJ_BATCH_MAP map

4988: IS
4989: SELECT
4990: map.PROJECT_ID
4991: , map.NEW_PROJECT_ORGANIZATION_ID
4992: FROM PJI_PJI_PROJ_BATCH_MAP map
4993: WHERE 1=1
4994: AND map.WORKER_ID = c_worker_id
4995: AND map.PROJECT_ORGANIZATION_ID <> map.NEW_PROJECT_ORGANIZATION_ID
4996: ;