APPS.WMS_LMS_LABOR_PRODUCTIVITY dependencies on WMS_ELS_TRX_SRC

Line 28: -- This procedure will match all the transaction records in wms_els_trx_src

24:
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

Line 33: -- with least sequnce.Update the els_data_id column of WMS_ELS_TRX_SRC table

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
34: -- with the eld_data_id of the setup line with which the matching was found
35: -- update the zone and item category columns with zone_id's and item_category_id of the
36: -- els data row with which the match was found.
37: -- 2). Update the travel and the idle time in the for the transaction row by

Line 163: -- select the maximum els_trx_src_id from wms_els_trx_src_id

159: debug('Org is Labor Enabled','MATCH_RATE_TRX_RECORDS');
160: END IF;
161:
162:
163: -- select the maximum els_trx_src_id from wms_els_trx_src_id
164: -- before this processing begins so that we dont update
165: -- the newly added rows which may be added during the
166: -- execution of this program as non-attributed without
167: -- even picking them for processing

Line 173: select max(els_trx_src_id) into l_max_id from wms_els_trx_src

169: -- bucketed against a wrong setup row eith higher sequence number
170: -- as the newly added rows may be added after the first few passes
171: -- of the setup rows have already been done
172:
173: select max(els_trx_src_id) into l_max_id from wms_els_trx_src
174: where organization_id = p_org_id;
175:
176: IF g_debug=1 THEN
177: debug('Value of the l_max_id at time of the beginning of the process'||l_max_id,'MATCH_RATE_TRX_RECORDS');

Line 197: -- used to exit the processing once all rows in wms_els_trx_src are exhaused even before

193: l_sql:=NULL;
194:
195: -- This fuction will return TRUE if more rows are left non matched after a certain pass of the
196: -- setup data. It will return FALSE when no more rows are left to process. This fucntion will be
197: -- used to exit the processing once all rows in wms_els_trx_src are exhaused even before
198: -- all the rows in setup are exhausted.
199:
200: IF g_debug=1 THEN
201: debug('Check if we have some more rows to process if no exit','MATCH_RATE_TRX_RECORDS');

Line 339: l_sql :=' UPDATE wms_els_trx_src '

335: IF g_debug=1 THEN
336: debug('The value of l_where_clause is '|| l_where_clause,'MATCH_RATE_TRX_RECORDS');
337: END IF;
338:
339: l_sql :=' UPDATE wms_els_trx_src '
340: || ' SET '
341: || ' els_data_id = :els_data_id'
342: || ' , source_zone_id = :source_zone'
343: || ' , destination_zone_id = :destination_zone'

Line 676: FROM wms_els_trx_src

672: count(*) num_tasks,
673: task_method_id,
674: group_size,
675: SUM(travel_time) total_travel_time
676: FROM wms_els_trx_src
677: WHERE organization_id = p_org_id
678: AND match_group = 1
679: AND transaction_date IS NOT NULL
680: AND grouped_task_identifier IS NOT NULL

Line 903: UPDATE wms_els_trx_src SET unattributed_flag = 1 , match_group = 2

899:
900: -- now update all txns having els_data_id as NULL with processed flag as 1
901: -- also update the match_group flag to 2(done)
902:
903: UPDATE wms_els_trx_src SET unattributed_flag = 1 , match_group = 2
904: WHERE els_data_id IS NULL and els_trx_src_id <= l_max_id AND organization_id = p_org_id;
905:
906: l_update_count := SQL%ROWCOUNT;
907: