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.WMS_LMS_EXPECTED_RES dependencies on WMS_ELS_EXP_RESOURCE_GTEMP

Line 2141: INSERT INTO WMS_ELS_EXP_RESOURCE_GTEMP

2137: IF g_debug=1 THEN
2138: debug('Before inserting the data into Global temporary table','MATCH_RATE_EXP_RESOURCE');
2139: END IF;
2140:
2141: INSERT INTO WMS_ELS_EXP_RESOURCE_GTEMP
2142: (SELECT els_data_id
2143: , source_header_id
2144: , source_line_id
2145: , activity_id

Line 2209: FROM wms_els_exp_resource_gtemp weerg

2205: END IF;
2206:
2207: UPDATE wms_els_individual_tasks_b weitb
2208: SET num_trx_matched = num_trx_matched - (SELECT count(weerg.els_data_id)
2209: FROM wms_els_exp_resource_gtemp weerg
2210: , wms_els_exp_resource weer
2211: WHERE weerg.source_header_id = weer.source_header_id
2212: AND weerg.source_line_id = weer.source_line_id
2213: AND weerg.activity_id = weer.activity_id