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.PA_SUMMARIZE_FORECAST_UTIL_PVT dependencies on GL_PERIODS

Line 562: ,gl_periods pp

558: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
559: ,'Y' delete_flag
560: FROM pa_forecast_items fi
561: ,pa_forecast_item_details fid
562: ,gl_periods pp
563: WHERE fi.forecast_item_id = fid.forecast_item_id
564: AND fi.expenditure_org_id = l_org_id
565: AND fid.expenditure_org_id = l_org_id
566: AND fi.forecast_item_type IN ('A', 'U')

Line 669: ,gl_periods gp

665: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
666: ,'Y' delete_flag
667: FROM pa_forecast_items fi
668: ,pa_forecast_item_details fid
669: ,gl_periods gp
670: WHERE fi.forecast_item_id = fid.forecast_item_id
671: AND fi.expenditure_org_id = l_org_id
672: AND fid.expenditure_org_id = l_org_id
673: AND fi.forecast_item_type IN ('A', 'U')

Line 876: ,gl_periods pp

872: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
873: ,'Y' delete_flag
874: FROM pa_forecast_items fi
875: ,pa_forecast_item_details fid
876: ,gl_periods pp
877: ,gl_periods gp
878: WHERE fi.forecast_item_id = fid.forecast_item_id
879: AND fi.expenditure_org_id = l_org_id
880: AND fid.expenditure_org_id = l_org_id

Line 877: ,gl_periods gp

873: ,'Y' delete_flag
874: FROM pa_forecast_items fi
875: ,pa_forecast_item_details fid
876: ,gl_periods pp
877: ,gl_periods gp
878: WHERE fi.forecast_item_id = fid.forecast_item_id
879: AND fi.expenditure_org_id = l_org_id
880: AND fid.expenditure_org_id = l_org_id
881: AND fi.forecast_item_type IN ('A', 'U')

Line 987: ,gl_periods pp

983: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
984: ,'Y' delete_flag
985: FROM pa_forecast_items fi
986: ,pa_forecast_item_details fid
987: ,gl_periods pp
988: WHERE fi.forecast_item_id = fid.forecast_item_id
989: AND fi.expenditure_org_id = l_org_id
990: AND fid.expenditure_org_id = l_org_id
991: AND fi.forecast_item_type IN ('A', 'U')

Line 1092: ,gl_periods gp

1088: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
1089: ,'Y' delete_flag
1090: FROM pa_forecast_items fi
1091: ,pa_forecast_item_details fid
1092: ,gl_periods gp
1093: WHERE fi.forecast_item_id = fid.forecast_item_id
1094: AND fi.expenditure_org_id = l_org_id
1095: AND fid.expenditure_org_id = l_org_id
1096: AND fi.forecast_item_type IN ('A', 'U')

Line 1196: ,gl_periods pp

1192: ,DECODE(fid.reduce_capacity_flag, 'Y', 1, 'N', 0) * NVL(fid.item_quantity, 0) reduce_capacity
1193: ,'Y' delete_flag
1194: FROM pa_forecast_items fi
1195: ,pa_forecast_item_details fid
1196: ,gl_periods pp
1197: ,gl_periods gp
1198: WHERE fi.forecast_item_id = fid.forecast_item_id
1199: AND fi.expenditure_org_id = l_org_id
1200: AND fid.expenditure_org_id = l_org_id

Line 1197: ,gl_periods gp

1193: ,'Y' delete_flag
1194: FROM pa_forecast_items fi
1195: ,pa_forecast_item_details fid
1196: ,gl_periods pp
1197: ,gl_periods gp
1198: WHERE fi.forecast_item_id = fid.forecast_item_id
1199: AND fi.expenditure_org_id = l_org_id
1200: AND fid.expenditure_org_id = l_org_id
1201: AND fi.forecast_item_type IN ('A', 'U')