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_INDIVIDUAL_TASKS_B

Line 2036: --in WMS_ELS_INDIVIDUAL_TASKS_B using the where clause for that setup row(dynamic SQL),

2032: --the program WMS_ELS_EXPECTED_RES. Populate_Expecetd_Work.
2033:
2034:
2035: -- Do the matching of the rows in WMS_ELS_EXP_RESOURCE table with the setup rows
2036: --in WMS_ELS_INDIVIDUAL_TASKS_B using the where clause for that setup row(dynamic SQL),
2037: --starting with the setup row having the least sequence number. Once a match is found
2038: --stamp the Estimated_time column in WMS_ELS_EXP_RESOURCE table with the time required
2039: --to complete the transaction. Also stamp the Expecetd_Resource column based on the global
2040: --setup.

Line 2058: -- cursor to get all the rows in wms_els_individual_tasks_b table

2054: , p_Utilization_rate IN NUMBER
2055: )IS
2056:
2057:
2058: -- cursor to get all the rows in wms_els_individual_tasks_b table
2059: -- for matching
2060:
2061: CURSOR c_els_data(l_org_id NUMBER) IS
2062: SELECT els_data_id,

Line 2084: FROM wms_els_individual_tasks_b

2080: expected_txn_time,
2081: expected_idle_time,
2082: travel_time_threshold,
2083: num_trx_matched
2084: FROM wms_els_individual_tasks_b
2085: WHERE organization_id = l_org_id
2086: AND history_flag IS NULL
2087: AND Analysis_id IN (2,4)
2088: ORDER BY group_id DESC,sequence_number ASC;

Line 2199: -- Update the number of matched transactions in wms_els_individual_tasks_b

2195:
2196: END IF;
2197:
2198: -- Added for the bug # 5169490
2199: -- Update the number of matched transactions in wms_els_individual_tasks_b
2200: -- i.e, Deduct the matched transaction count for the tasks/record that has been
2201: -- populated again in wms_els_exp_resource table.
2202:
2203: IF g_debug=1 THEN

Line 2204: debug('Before updating the data in wms_els_individual_tasks_b table','MATCH_RATE_EXP_RESOURCE');

2200: -- i.e, Deduct the matched transaction count for the tasks/record that has been
2201: -- populated again in wms_els_exp_resource table.
2202:
2203: IF g_debug=1 THEN
2204: debug('Before updating the data in wms_els_individual_tasks_b table','MATCH_RATE_EXP_RESOURCE');
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)

Line 2207: UPDATE wms_els_individual_tasks_b weitb

2203: IF g_debug=1 THEN
2204: debug('Before updating the data in wms_els_individual_tasks_b table','MATCH_RATE_EXP_RESOURCE');
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

Line 2223: debug('After updating the data in wms_els_individual_tasks_b table','MATCH_RATE_EXP_RESOURCE');

2219: AND weitb.analysis_id IN (2, 4); -- Analysis_id should be Work outstanding (4) or both(2) */
2220:
2221:
2222: IF g_debug=1 THEN
2223: debug('After updating the data in wms_els_individual_tasks_b table','MATCH_RATE_EXP_RESOURCE');
2224: END IF;
2225:
2226:
2227: -- Now once all this is done Do the matching of the rows in WMS_ELS_EXP_RESOURCE table

Line 2229: --in WMS_ELS_INDIVIDUAL_TASKS_B using the where clause built dynamically (dynamic SQL),

2225:
2226:
2227: -- Now once all this is done Do the matching of the rows in WMS_ELS_EXP_RESOURCE table
2228: --with the setup rows
2229: --in WMS_ELS_INDIVIDUAL_TASKS_B using the where clause built dynamically (dynamic SQL),
2230: --starting with the setup row having the least sequence number. Once a match is found
2231: --stamp the Estimated_time column in WMS_ELS_EXP_RESOURCE table with the time required
2232: --to complete the transaction. Also stamp the Expecetd_Resource column based on the global
2233: --setup.

Line 2534: UPDATE wms_els_individual_tasks_b

2530: DBMS_SQL.close_cursor(c);
2531:
2532: --update the count with newly matched transactions
2533:
2534: UPDATE wms_els_individual_tasks_b
2535: SET
2536: num_trx_matched = l_total
2537: WHERE els_data_id = l_els_data.els_data_id;
2538: