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.OPI_DBI_WMS_WAA_PKG dependencies on OPI_DBI_WMS_TASKS_STG

Line 248: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_tasks_stg'

244: ,status => l_status
245: ,industry => l_industry
246: ,oracle_schema => l_schema) THEN
247: l_stmt_num := 20;
248: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_tasks_stg'
249: ,p_owner => l_schema
250: ,p_retcode => retcode);
251: --
252: l_stmt_num := 30;

Line 300: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_tasks_stg'

296: ,status => l_status
297: ,industry => l_industry
298: ,oracle_schema => l_schema) THEN
299: l_stmt_num := 20;
300: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_tasks_stg'
301: ,p_owner =>l_schema
302: ,p_retcode =>retcode);
303: --
304: l_stmt_num := 30;

Line 363: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_tasks_stg';

359: --Truncate Staging Tables
360: l_stmt_num := 30;
361: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_op_stg';
362: l_stmt_num := 40;
363: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_tasks_stg';
364: l_stmt_num := 50;
365: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_ex_stg';
366: l_stmt_num := 60;
367: bis_collection_utilities.put_line('Truncated the Staging Tables');

Line 415: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_tasks_stg';

411: ,industry => l_industry
412: ,oracle_schema => l_schema) THEN
413: l_stmt_num := 20;
414: --Truncate Staging Tables
415: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_tasks_stg';
416: l_stmt_num := 30;
417: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_op_stg';
418: l_stmt_num := 40;
419: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_ex_stg';

Line 558: gather_stats('OPI_DBI_WMS_TASKS_STG');

554: l_stmt_num := 10;
555: --
556: -- Gather Status for all the Staging Tables
557: --
558: gather_stats('OPI_DBI_WMS_TASKS_STG');
559: l_stmt_num := 20;
560: gather_stats('OPI_DBI_WMS_OP_STG');
561: l_stmt_num := 30;
562: gather_stats('OPI_DBI_WMS_EX_STG');

Line 681: INTO opi_dbi_wms_tasks_stg tasks

677: --
678: --Collect all Pick Tasks into Tasks Staging Table
679: --
680: INSERT /*+ append parallel(tasks) */
681: INTO opi_dbi_wms_tasks_stg tasks
682: (tasks.task_id
683: ,tasks.organization_id
684: ,tasks.inventory_item_id
685: ,tasks.task_type

Line 784: FROM opi_dbi_wms_tasks_stg tasks

780: ,woiph.plan_execution_start_date plan_execution_start_date
781: ,woiph.plan_execution_end_date plan_execution_end_date
782: ,( woiph.plan_execution_end_date
783: - woiph.plan_execution_start_date)*24 plan_elapsed_time
784: FROM opi_dbi_wms_tasks_stg tasks
785: ,wms_op_plan_instances_hist woiph
786: ,wms_op_plans_b wop
787: ,mtl_system_items_b msi
788: ,mtl_secondary_inventories sinv

Line 867: FROM opi_dbi_wms_tasks_stg tasks

863: ,NULL operation_plan_status
864: ,NULL op_plan_instance_id
865: ,tasks.completion_date completion_date
866: ,wmx.reason_id reason_id
867: FROM opi_dbi_wms_tasks_stg tasks
868: ,wms_exceptions wmx
869: ,mtl_transaction_reasons mtr
870: WHERE wmx.task_id = tasks.transaction_temp_id
871: AND tasks.task_type = 1

Line 891: ,opi_dbi_wms_tasks_stg tasks

887: ,ops.plan_execution_end_date completion_date
888: ,wmx.reason_id reason_id
889: FROM opi_dbi_wms_op_stg ops
890: ,wms_exceptions wmx
891: ,opi_dbi_wms_tasks_stg tasks
892: ,mtl_transaction_reasons mtr
893: WHERE tasks.op_plan_instance_id = ops.op_plan_instance_id
894: AND tasks.task_type in (2,8)
895: AND wmx.task_id = tasks.transaction_temp_id

Line 973: FROM opi_dbi_wms_tasks_stg tasks

969: ,g_request_id request_id
970: ,g_program_application_id program_application_id
971: ,g_program_id program_id
972: ,g_sysdate program_update_date
973: FROM opi_dbi_wms_tasks_stg tasks
974: ,(SELECT /*+ parallel (ex) use_hash (ex) */
975: ex.task_id
976: ,COUNT(ex.exception_id) ex_cnt
977: FROM opi_dbi_wms_ex_stg ex

Line 1214: INSERT INTO opi_dbi_wms_tasks_stg tasks

1210: l_stmt_num := 10;
1211: --
1212: --Collect all Pick Tasks into Tasks Staging Table
1213: --
1214: INSERT INTO opi_dbi_wms_tasks_stg tasks
1215: (tasks.task_id
1216: ,tasks.organization_id
1217: ,tasks.inventory_item_id
1218: ,tasks.task_type

Line 1395: FROM opi_dbi_wms_tasks_stg tasks

1391: ,NULL operation_plan_status
1392: ,NULL op_plan_instance_id
1393: ,tasks.completion_date completion_date
1394: ,wmx.reason_id reason_id
1395: FROM opi_dbi_wms_tasks_stg tasks
1396: ,wms_exceptions wmx
1397: ,mtl_transaction_reasons mtr
1398: WHERE wmx.task_id = tasks.transaction_temp_id
1399: AND tasks.task_type = 1

Line 1470: FROM opi_dbi_wms_tasks_stg tasks

1466: ,TRUNC(tasks.completion_date) completion_date
1467: ,COUNT(tasks.task_id) picks
1468: ,COUNT(exs.task_id) picks_with_exceptions
1469: ,SUM(exs.ex_cnt) pick_exceptions
1470: FROM opi_dbi_wms_tasks_stg tasks
1471: ,(SELECT ex.task_id
1472: ,COUNT(ex.exception_id) ex_cnt
1473: FROM opi_dbi_wms_ex_stg ex
1474: WHERE ex.operation_plan_indicator = 1