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.

[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on PA_FI_ASSIG_TEMP

Line 951: DELETE FROM PA_FI_ASSIG_TEMP;

947: -- l_assignment_days as opposed to dividing by the number of
948: -- days which make the join below.
949: --
950: --Added for bug # 6144255
951: DELETE FROM PA_FI_ASSIG_TEMP;
952: INSERT INTO PA_FI_ASSIG_TEMP
953: (
954: SELECT asgmt.item_date ,
955: asgmt.item_quantity

Line 952: INSERT INTO PA_FI_ASSIG_TEMP

948: -- days which make the join below.
949: --
950: --Added for bug # 6144255
951: DELETE FROM PA_FI_ASSIG_TEMP;
952: INSERT INTO PA_FI_ASSIG_TEMP
953: (
954: SELECT asgmt.item_date ,
955: asgmt.item_quantity
956: FROM pa_forecast_items asgmt

Line 990: ' PA_FI_ASSIG_TEMP asgmt ';

986: ' nvl(res.confirmed_qty, 0)), 0)/ asgmt.item_quantity))/ :1 ' || '* 100) ';
987:
988: stmt_from := ' FROM ' ||
989: ' PA_FORECAST_ITEMS res, ' ||
990: ' PA_FI_ASSIG_TEMP asgmt ';
991:
992: stmt_where := ' WHERE ' ||
993: ' res.forecast_item_type = ''U'' ' ||
994: ' AND res.delete_flag = ''N'' ' ||