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_SEARCH_PVT dependencies on PA_FI_ASSIG_TEMP

Line 934: DELETE FROM PA_FI_ASSIG_TEMP;

930: -- l_assignment_days as opposed to dividing by the number of
931: -- days which make the join below.
932: --
933: --Added for bug # 6144255
934: DELETE FROM PA_FI_ASSIG_TEMP;
935: INSERT INTO PA_FI_ASSIG_TEMP
936: (
937: SELECT asgmt.item_date ,
938: asgmt.item_quantity

Line 935: INSERT INTO PA_FI_ASSIG_TEMP

931: -- days which make the join below.
932: --
933: --Added for bug # 6144255
934: DELETE FROM PA_FI_ASSIG_TEMP;
935: INSERT INTO PA_FI_ASSIG_TEMP
936: (
937: SELECT asgmt.item_date ,
938: asgmt.item_quantity
939: FROM pa_forecast_items asgmt

Line 973: ' PA_FI_ASSIG_TEMP asgmt ';

969: ' nvl(res.confirmed_qty, 0)), 0)/ asgmt.item_quantity))/ :1 ' || '* 100) ';
970:
971: stmt_from := ' FROM ' ||
972: ' PA_FORECAST_ITEMS res, ' ||
973: ' PA_FI_ASSIG_TEMP asgmt ';
974:
975: stmt_where := ' WHERE ' ||
976: ' res.forecast_item_type = ''U'' ' ||
977: ' AND res.delete_flag = ''N'' ' ||