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_PMV_UTLZ dependencies on PA_WORK_TYPES_B

Line 713: PA_WORK_TYPES_B worktype,

709: PJI_PMV_TIME_DIM_TMP time,
710: PJI_PMV_WT_DIM_TMP wt,
711: PJI_RM_WTO_F_MV fct,
712: PJI_PMV_ORG_DIM_TMP hou,
713: PA_WORK_TYPES_B worktype,
714: PA_IMPLEMENTATIONS_ALL imp
715: WHERE fct.expenditure_org_id = hou.id
716: AND fct.expenditure_organization_id = horg.id
717: AND wt.id = worktype.work_type_id

Line 766: PA_WORK_TYPES_B worktype,

762: PJI_PMV_TCMP_DIM_TMP time,
763: PJI_PMV_WT_DIM_TMP wt,
764: PJI_RM_WTO_F_MV fct,
765: PJI_PMV_ORG_DIM_TMP hou,
766: PA_WORK_TYPES_B worktype,
767: PA_IMPLEMENTATIONS_ALL imp
768: WHERE fct.expenditure_org_id = hou.id
769: AND fct.expenditure_organization_id = horg.id
770: AND wt.id = worktype.work_type_id

Line 1302: PA_WORK_TYPES_B worktype,

1298: PJI_PMV_WT_DIM_TMP wt,
1299: PJI_RM_RES_WT_F fct,
1300: PJI_PMV_ORG_DIM_TMP hou,
1301: PJI_PMV_JB_DIM_TMP job,
1302: PA_WORK_TYPES_B worktype,
1303: PA_IMPLEMENTATIONS_ALL imp
1304: WHERE fct.expenditure_org_id = hou.id
1305: AND fct.expenditure_organization_id = horg.id
1306: AND wt.id = worktype.work_type_id

Line 1358: PA_WORK_TYPES_B worktype,

1354: PJI_PMV_WT_DIM_TMP wt,
1355: PJI_RM_RES_WT_F fct,
1356: PJI_PMV_ORG_DIM_TMP hou,
1357: PJI_PMV_JB_DIM_TMP job,
1358: PA_WORK_TYPES_B worktype,
1359: PA_IMPLEMENTATIONS_ALL imp
1360: WHERE fct.expenditure_org_id = hou.id
1361: AND fct.expenditure_organization_id = horg.id
1362: AND wt.id = worktype.work_type_id

Line 2444: PA_WORK_TYPES_B worktype,

2440: PJI_PMV_TIME_DIM_TMP time,
2441: PJI_PMV_WT_DIM_TMP wt,
2442: PJI_RM_WTO_F_MV fct,
2443: PJI_PMV_ORG_DIM_TMP hou,
2444: PA_WORK_TYPES_B worktype,
2445: PA_IMPLEMENTATIONS_ALL imp
2446: WHERE fct.expenditure_org_id = hou.id
2447: AND fct.expenditure_organization_id = horg.id
2448: AND wt.id = worktype.work_type_id

Line 2497: PA_WORK_TYPES_B worktype,

2493: PJI_PMV_TIME_DIM_TMP time,
2494: PJI_PMV_WT_DIM_TMP wt,
2495: PJI_RM_WTO_F_MV fct,
2496: PJI_PMV_ORG_DIM_TMP hou,
2497: PA_WORK_TYPES_B worktype,
2498: PA_IMPLEMENTATIONS_ALL imp
2499: WHERE fct.expenditure_org_id = hou.id
2500: AND fct.expenditure_organization_id = horg.id
2501: AND wt.id = worktype.work_type_id

Line 2992: PA_WORK_TYPES_B worktype,

2988: PJI_PMV_WT_DIM_TMP wt,
2989: PJI_RM_RES_WT_F fct,
2990: PJI_PMV_ORG_DIM_TMP hou,
2991: PJI_PMV_JB_DIM_TMP job,
2992: PA_WORK_TYPES_B worktype,
2993: PA_IMPLEMENTATIONS_ALL imp
2994: WHERE fct.expenditure_org_id = hou.id
2995: AND fct.expenditure_organization_id = horg.id
2996: AND wt.id = worktype.work_type_id

Line 3047: PA_WORK_TYPES_B worktype,

3043: PJI_PMV_WT_DIM_TMP wt,
3044: PJI_RM_RES_WT_F fct,
3045: PJI_PMV_ORG_DIM_TMP hou,
3046: PJI_PMV_JB_DIM_TMP job,
3047: PA_WORK_TYPES_B worktype,
3048: PA_IMPLEMENTATIONS_ALL imp
3049: WHERE fct.expenditure_org_id = hou.id
3050: AND fct.expenditure_organization_id = horg.id
3051: AND wt.id = worktype.work_type_id

Line 4025: PA_WORK_TYPES_B worktype,

4021: PJI_PMV_TIME_DIM_TMP time,
4022: PJI_PMV_WT_DIM_TMP wt,
4023: PJI_RM_WTO_F_MV fct,
4024: PJI_PMV_ORG_DIM_TMP hou,
4025: PA_WORK_TYPES_B worktype,
4026: PA_IMPLEMENTATIONS_ALL imp
4027: WHERE fct.expenditure_org_id = hou.id
4028: AND fct.expenditure_organization_id = horg.id
4029: AND fct.work_type_id = wt.id

Line 4096: PA_WORK_TYPES_B worktype,

4092: PJI_PMV_TIME_DIM_TMP time,
4093: PJI_PMV_WT_DIM_TMP wt,
4094: PJI_RM_WTO_F_MV fct,
4095: PJI_PMV_ORG_DIM_TMP hou,
4096: PA_WORK_TYPES_B worktype,
4097: PA_IMPLEMENTATIONS_ALL imp
4098: WHERE fct.expenditure_org_id = hou.id
4099: AND fct.expenditure_organization_id = horg.id
4100: AND fct.work_type_id = wt.id

Line 4893: PA_WORK_TYPES_B worktype,

4889: PJI_PMV_WT_DIM_TMP wt,
4890: PJI_RM_RES_WT_F fct,
4891: PJI_PMV_ORG_DIM_TMP hou,
4892: PJI_PMV_JB_DIM_TMP job,
4893: PA_WORK_TYPES_B worktype,
4894: PA_IMPLEMENTATIONS_ALL imp
4895: WHERE fct.expenditure_org_id = hou.id
4896: AND fct.expenditure_organization_id = horg.id
4897: AND fct.work_type_id = wt.id

Line 4966: PA_WORK_TYPES_B worktype,

4962: PJI_PMV_WT_DIM_TMP wt,
4963: PJI_RM_RES_WT_F fct,
4964: PJI_PMV_ORG_DIM_TMP hou,
4965: PJI_PMV_JB_DIM_TMP job,
4966: PA_WORK_TYPES_B worktype,
4967: PA_IMPLEMENTATIONS_ALL imp
4968: WHERE fct.expenditure_org_id = hou.id
4969: AND fct.expenditure_organization_id = horg.id
4970: AND fct.work_type_id = wt.id

Line 6055: ,pa_work_types_b wtb

6051: ,pji_pmv_time_dim_tmp time
6052: ,pji_pmv_wt_dim_tmp wt
6053: ,pji_rm_res_wt_f fct
6054: ,pji_pmv_org_dim_tmp hou
6055: ,pa_work_types_b wtb
6056: ,pa_resources_denorm resd
6057: ,pa_implementations_all imp
6058: WHERE
6059: fct.expenditure_org_id = hou.id

Line 6185: ,pa_work_types_b wtb

6181: ,pji_pmv_wt_dim_tmp wt
6182: ,pji_rm_res_wt_f fct
6183: ,pji_pmv_jb_dim_tmp jbt
6184: ,pji_pmv_org_dim_tmp hou
6185: ,pa_work_types_b wtb
6186: ,pa_resources_denorm resd
6187: ,pa_implementations_all imp
6188: WHERE
6189: fct.expenditure_org_id = hou.id

Line 6711: ,pa_work_types_b wtb

6707: ,pji_pmv_time_dim_tmp time
6708: ,pji_pmv_wt_dim_tmp wt
6709: ,pji_rm_res_wt_f fct
6710: ,pji_pmv_org_dim_tmp hou
6711: ,pa_work_types_b wtb
6712: ,pa_resources_denorm resd
6713: ,pa_implementations_all imp
6714: WHERE
6715: fct.expenditure_org_id = hou.id

Line 6849: ,pa_work_types_b wtb

6845: ,pji_pmv_wt_dim_tmp wt
6846: ,pji_rm_res_wt_f fct
6847: ,pji_pmv_jb_dim_tmp jbt
6848: ,pji_pmv_org_dim_tmp hou
6849: ,pa_work_types_b wtb
6850: ,pa_resources_denorm resd
6851: ,pa_implementations_all imp
6852: WHERE
6853: fct.expenditure_org_id = hou.id

Line 7571: ,pa_work_types_b wtb

7567: ,pji_pmv_time_dim_tmp time
7568: ,pji_pmv_wt_dim_tmp wt
7569: ,pji_rm_res_wt_f fct
7570: ,pji_pmv_org_dim_tmp hou
7571: ,pa_work_types_b wtb
7572: ,pa_resources_denorm resd
7573: ,pa_implementations_all imp
7574: WHERE
7575: fct.expenditure_org_id = hou.id

Line 7619: ,pa_work_types_b wtb

7615: ,pji_pmv_time_dim_tmp time
7616: ,pji_pmv_wt_dim_tmp wt
7617: ,pji_rm_res_wt_f fct
7618: ,pji_pmv_org_dim_tmp hou
7619: ,pa_work_types_b wtb
7620: ,pa_resources_denorm resd
7621: ,pa_implementations_all imp
7622: WHERE
7623: fct.expenditure_org_id = hou.id

Line 7844: ,pa_work_types_b wtb

7840: ,pji_pmv_wt_dim_tmp wt
7841: ,pji_rm_res_wt_f fct
7842: ,pji_pmv_jb_dim_tmp jbt
7843: ,pji_pmv_org_dim_tmp hou
7844: ,pa_work_types_b wtb
7845: ,pa_resources_denorm resd
7846: ,pa_implementations_all imp
7847: WHERE
7848: fct.expenditure_org_id = hou.id

Line 7895: ,pa_work_types_b wtb

7891: ,pji_pmv_wt_dim_tmp wt
7892: ,pji_rm_res_wt_f fct
7893: ,pji_pmv_jb_dim_tmp jbt
7894: ,pji_pmv_org_dim_tmp hou
7895: ,pa_work_types_b wtb
7896: ,pa_resources_denorm resd
7897: ,pa_implementations_all imp
7898: WHERE
7899: fct.expenditure_org_id = hou.id