APPS.WMS_LMS_LABOR_PRODUCTIVITY dependencies on WMS_ELS_INDIVIDUAL_TASKS_B

Line 29: -- table with the setup rows in wms_els_individual_tasks_b and wms_els_grouped_tasks_b

25:
26:
27:
28: -- This procedure will match all the transaction records in wms_els_trx_src
29: -- table with the setup rows in wms_els_individual_tasks_b and wms_els_grouped_tasks_b
30: --It will DO the following
31:
32: -- 1) do the matching of transaction data with els data. Start with the setup row
33: -- with least sequnce.Update the els_data_id column of WMS_ELS_TRX_SRC table

Line 74: FROM wms_els_individual_tasks_b

70: expected_txn_time,
71: expected_idle_time,
72: travel_time_threshold,
73: num_trx_matched
74: FROM wms_els_individual_tasks_b
75: WHERE organization_id = l_org_id
76: AND history_flag IS NULL
77: AND analysis_id IN( 2,3)
78: ORDER BY sequence_number,group_id;

Line 594: UPDATE wms_els_individual_tasks_b

590: DBMS_SQL.close_cursor(c);
591:
592: --update the count with newly matched transactions
593:
594: UPDATE wms_els_individual_tasks_b
595: SET
596: num_trx_matched = l_total
597: WHERE els_data_id = l_els_data.els_data_id;
598: