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_UTILS dependencies on WMS_ELS_TRX_SRC

Line 234: DELETE wms_els_trx_src

230: -- costed against them
231:
232: FORALL i IN l_els_id_tab.first..l_els_id_tab.last
233:
234: DELETE wms_els_trx_src
235: WHERE els_data_id = l_els_id_tab(i);
236:
237: l_records_deleted :=SQL%ROWCOUNT;
238:

Line 240: debug('Number of records deleted from wms_els_trx_src table '|| l_records_deleted,

236:
237: l_records_deleted :=SQL%ROWCOUNT;
238:
239: IF g_debug=1 THEN
240: debug('Number of records deleted from wms_els_trx_src table '|| l_records_deleted,
241: 'PURGE_LMS_SETUP_HISTORY'
242: );
243: END IF;
244:

Line 336: INSERT INTO WMS_ELS_TRX_SRC

332: END IF;
333:
334: --select the summary row from the table and insert into the table
335:
336: INSERT INTO WMS_ELS_TRX_SRC
337: (els_trx_src_id,
338: els_data_id,
339: organization_id,
340: travel_time,

Line 348: SELECT WMS_ELS_TRX_SRC_S.NEXTVAL,

344: last_updated_by,
345: created_by,
346: creation_date
347: )
348: SELECT WMS_ELS_TRX_SRC_S.NEXTVAL,
349: els_data_id,
350: organization_id,
351: travel_time,
352: transaction_time,

Line 364: FROM WMS_ELS_TRX_SRC

360: organization_id,
361: AVG(TRAVEL_TIME) travel_time,
362: AVG(TRANSACTION_TIME) transaction_time,
363: AVG(IDLE_TIME) Idle_time
364: FROM WMS_ELS_TRX_SRC
365: WHERE transaction_date < p_purge_date
366: AND organization_id = p_org_id
367: AND els_data_id IS NOT NULL
368: GROUP BY ELS_DATA_ID,organization_id

Line 449: DELETE wms_els_trx_src

445: ,'PURGE_LMS_TRANSACTIONS'
446: );
447: END IF;
448:
449: DELETE wms_els_trx_src
450: WHERE transaction_date <= NVL(TO_DATE(p_purge_date,'YYYY/MM/DD HH24:MI:SS'),SYSDATE)
451: AND organization_id = p_org_id;
452:
453: l_records_deleted :=SQL%ROWCOUNT;

Line 970: SELECT AVG(travel_time) FROM WMS_ELS_TRX_SRC

966: --Bulk update is used here for performance enhancement resons.
967:
968: UPDATE wms_els_individual_tasks_b SET
969: actual_travel_time=(
970: SELECT AVG(travel_time) FROM WMS_ELS_TRX_SRC
971: WHERE els_data_id=l_els_data_id_tab(i)
972: AND NVL(Transaction_Date,SYSDATE) >= NVL(l_date,SYSDATE)
973: AND (
974: (l_time_frame_average_id =3)

Line 979: SELECT AVG(Transaction_time) FROM WMS_ELS_TRX_SRC

975: OR ((l_time_frame_average_id <> 3 ) AND (TRANSACTION_DATE IS NOT NULL))
976: )
977: ),
978: actual_txn_time =(
979: SELECT AVG(Transaction_time) FROM WMS_ELS_TRX_SRC
980: WHERE els_data_id=l_els_data_id_tab(i)
981: AND NVL(Transaction_Date,SYSDATE) >= NVL(l_date,SYSDATE)
982: AND (
983: (l_time_frame_average_id =3)

Line 988: SELECT AVG(idle_time) FROM WMS_ELS_TRX_SRC

984: OR ((l_time_frame_average_id <> 3 ) AND (TRANSACTION_DATE IS NOT NULL))
985: )
986: ),
987: actual_idle_time=(
988: SELECT AVG(idle_time) FROM WMS_ELS_TRX_SRC
989: WHERE els_data_id=l_els_data_id_tab(i)
990: AND NVL(Transaction_Date,SYSDATE) >= NVL(l_date,SYSDATE)
991: AND (
992: (l_time_frame_average_id =3)

Line 1073: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_trx_src

1069: RETURN NUMBER IS
1070: is_unprocessed NUMBER;
1071: BEGIN
1072:
1073: select 1 into is_unprocessed from dual where exists (select 1 from wms_els_trx_src
1074: where els_data_id IS NULL
1075: and organization_id = p_org_id
1076: and els_trx_src_id <= p_max_id
1077: );

Line 1739: FROM WMS_ELS_TRX_SRC

1735: , sysdate
1736: , FND_GLOBAL.LOGIN_ID
1737: , FND_GLOBAL.USER_ID
1738: , sysdate
1739: FROM WMS_ELS_TRX_SRC
1740: WHERE ELS_DATA_ID IS NULL
1741: AND ELS_TRX_SRC_ID = l_els_trx_src_id
1742: AND UNATTRIBUTED_FLAG = 1 ;
1743:

Line 1748: FROM WMS_ELS_TRX_SRC

1744:
1745: /* Added the following select statement for bug 5194353 */
1746:
1747: SELECT nvl(group_id,0) into l_grp_id
1748: FROM WMS_ELS_TRX_SRC
1749: WHERE ELS_TRX_SRC_ID = l_els_trx_src_id;
1750:
1751: if(l_grp_id = 1) then
1752: l_seq_num_man_and_usr_directed := nvl(l_seq_num_man_and_usr_directed,0) +10;

Line 1901: ' FROM wms_els_trx_src' ||

1897: ' , count(*) task_range_from' ||
1898: ' , count(*) task_range_to' ||
1899: ' , sum(travel_and_idle_time) exp_travel_time' ||
1900: ' , sum(travel_and_idle_time) act_travel_Time' ||
1901: ' FROM wms_els_trx_src' ||
1902: ' where els_data_id is null' ||
1903: ' and organization_id = '|| p_org_id ||
1904: ' and Els_Trx_Src_Id IN (' || P_COPY_ID || ') '||
1905: ' and unattributed_flag = 1 '||

Line 1962: 'UPDATE wms_els_trx_src ' ||

1958:
1959:
1960: --Completed entering all the values. Now have to change the unattributed_lines flag of all are selected rows.
1961: EXECUTE IMMEDIATE
1962: 'UPDATE wms_els_trx_src ' ||
1963: 'SET unattributed_flag = null ' ||
1964: 'WHERE Els_Trx_Src_Id IN (' || P_COPY_ID || ')';
1965:
1966: EXCEPTION

Line 2155: || ' FROM WMS_ELS_TRX_SRC '

2151: || ' , task_method_id ' --task_method_id
2152: || ' , ROUND(AVG(travel_and_idle_time),3) travel_and_idle_time ' --expected_travel_time
2153: || ' , ROUND(AVG(transaction_time),3) transaction_time' --expected_txn_time
2154: || ' , ROUND(AVG(idle_time),3) idle_time '
2155: || ' FROM WMS_ELS_TRX_SRC '
2156: || ' WHERE UNATTRIBUTED_FLAG = 1 '
2157: || ' AND organization_id = ' || p_org_id
2158: || ' AND group_id = 1 '
2159: || l_where_clause

Line 2271: || ' FROM WMS_ELS_TRX_SRC '

2267: || ' , task_method_id ' --task_method_id
2268: || ' , ROUND(AVG(travel_and_idle_time),3) travel_and_idle_time ' --expected_travel_time
2269: || ' , ROUND(AVG(transaction_time),3) transaction_time' --expected_txn_time
2270: || ' , ROUND(AVG(idle_time),3) idle_time '
2271: || ' FROM WMS_ELS_TRX_SRC '
2272: || ' WHERE UNATTRIBUTED_FLAG = 1 '
2273: || ' AND organization_id = ' || p_org_id
2274: || ' AND group_id = 2 '
2275: || l_where_clause

Line 2389: || ' FROM WMS_ELS_TRX_SRC '

2385: || ' , task_method_id ' --task_method_id
2386: || ' , ROUND(AVG(travel_and_idle_time),3) travel_and_idle_time ' --expected_travel_time
2387: || ' , ROUND(AVG(transaction_time),3) transaction_time' --expected_txn_time
2388: || ' , ROUND(AVG(idle_time),3) idle_time '
2389: || ' FROM WMS_ELS_TRX_SRC '
2390: || ' WHERE UNATTRIBUTED_FLAG = 1 '
2391: || ' AND organization_id = ' || p_org_id
2392: || ' AND group_id = 3 '
2393: || l_where_clause

Line 2576: ' FROM wms_els_trx_src' ||

2572: ' , count(*) task_range_from' ||
2573: ' , count(*) task_range_to' ||
2574: ' , sum(travel_and_idle_time) exp_travel_time' ||
2575: ' , sum(travel_and_idle_time) act_travel_Time' ||
2576: ' FROM wms_els_trx_src' ||
2577: ' where els_data_id is null' ||
2578: ' and organization_id = '|| p_org_id ||
2579: ' and unattributed_flag = 1 '||
2580: ' and grouped_Task_identifier IS NOT NULL ' ||

Line 2672: 'UPDATE wms_els_trx_src ' ||

2668:
2669: -- now make the unattributed_flag as null for these lines that have been standardized
2670:
2671: EXECUTE IMMEDIATE
2672: 'UPDATE wms_els_trx_src ' ||
2673: 'SET unattributed_flag = null ' ||
2674: 'WHERE organization_id = ' || p_org_id ||l_where_clause || l_not_in_clause ;
2675:
2676:

Line 2782: INSERT INTO WMS_ELS_TRX_SRC

2778: RETURN;
2779: END IF;
2780:
2781:
2782: INSERT INTO WMS_ELS_TRX_SRC
2783: (
2784: ELS_TRX_SRC_ID,
2785: TRANSACTION_DATE,
2786: ACTIVITY_ID,

Line 2815: WMS_ELS_TRX_SRC_S.NEXTVAL,

2811: LAST_UPDATED_BY
2812: )
2813: values
2814: (
2815: WMS_ELS_TRX_SRC_S.NEXTVAL,
2816: SYSDATE,
2817: P_ACTIVITY_ID,
2818: P_ACTIVITY_DETAIL_ID,
2819: P_OPERATION_ID,

Line 2847: debug('Successfully inserted record in WMS_ELS_TRX_SRC table');

2843: );
2844: commit;
2845:
2846: IF g_debug=1 THEN
2847: debug('Successfully inserted record in WMS_ELS_TRX_SRC table');
2848: END IF;
2849:
2850: EXCEPTION
2851: WHEN OTHERS THEN

Line 2855: debug('Insertion in WMS_ELS_TRX_SRC failed'||SQLERRM);

2851: WHEN OTHERS THEN
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853:
2854: IF g_debug=1 THEN
2855: debug('Insertion in WMS_ELS_TRX_SRC failed'||SQLERRM);
2856: END IF;
2857:
2858: END INSERT_ELS_TRX;
2859: