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_EX_STG

Line 258: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_ex_stg'

254: ,p_owner => l_schema
255: ,p_retcode => retcode);
256: --
257: l_stmt_num := 40;
258: oki_dbi_scm_rsg_api_pvt.drop_index(p_table_name => 'opi_dbi_wms_ex_stg'
259: ,p_owner => l_schema
260: ,p_retcode => retcode);
261: --
262: bis_collection_utilities.put_line('Dropped the Indexes on Staging Tables');

Line 310: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_ex_stg'

306: ,p_owner =>l_schema
307: ,p_retcode =>retcode);
308: --
309: l_stmt_num := 40;
310: oki_dbi_scm_rsg_api_pvt.create_index(p_table_name=>'opi_dbi_wms_ex_stg'
311: ,p_owner =>l_schema
312: ,p_retcode =>retcode);
313: --
314: l_stmt_num := 50;

Line 365: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_ex_stg';

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');
368: --Truncate Fact Tables along with MV Logs
369: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema

Line 419: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.opi_dbi_wms_ex_stg';

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';
420: l_stmt_num := 50;
421: END IF;
422: l_stmt_num := 60;
423: EXCEPTION

Line 562: gather_stats('OPI_DBI_WMS_EX_STG');

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');
563: l_stmt_num := 40;
564: --
565: EXCEPTION
566: WHEN OTHERS THEN

Line 841: INTO opi_dbi_wms_ex_stg exs

837: --
838: --Collect all Exceptions into Exceptions Staging Table
839: --
840: INSERT /*+ append (exs) */
841: INTO opi_dbi_wms_ex_stg exs
842: (exs.exception_id
843: ,exs.task_id
844: ,exs.organization_id
845: ,exs.inventory_item_id

Line 977: FROM opi_dbi_wms_ex_stg ex

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
978: WHERE ex.operation_plan_indicator = 1
979: GROUP BY task_id ) exs
980: WHERE tasks.transaction_temp_id = exs.task_id(+)
981: AND tasks.task_type = 1

Line 1074: FROM opi_dbi_wms_ex_stg ex

1070: FROM opi_dbi_wms_op_stg ops
1071: ,(SELECT /*+ parallel (ex) use_hash (ex) */
1072: NVL(ex.op_plan_instance_id,0) op_plan_instance_id
1073: ,count(ex.exception_id) ex_cnt
1074: FROM opi_dbi_wms_ex_stg ex
1075: WHERE ex.operation_plan_indicator = 2
1076: GROUP BY nvl(ex.op_plan_instance_id,0)) exs
1077: WHERE ops.op_plan_instance_id = exs.op_plan_instance_id(+)
1078: GROUP BY ops.organization_id

Line 1164: FROM opi_dbi_wms_ex_stg exs

1160: ,g_request_id request_id
1161: ,g_program_application_id program_application_id
1162: ,g_program_id program_id
1163: ,g_sysdate program_update_date
1164: FROM opi_dbi_wms_ex_stg exs
1165: GROUP BY exs.organization_id
1166: ,exs.subinventory_code
1167: ,exs.inventory_item_id
1168: ,exs.operation_plan_id

Line 1371: INSERT INTO opi_dbi_wms_ex_stg exs

1367: l_stmt_num := 10;
1368: --
1369: --Collect all Exceptions into Exceptions Staging Table
1370: --
1371: INSERT INTO opi_dbi_wms_ex_stg exs
1372: (exs.exception_id
1373: ,exs.task_id
1374: ,exs.organization_id
1375: ,exs.inventory_item_id

Line 1473: FROM opi_dbi_wms_ex_stg ex

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
1475: GROUP BY task_id ) exs
1476: WHERE tasks.transaction_temp_id = exs.task_id(+)
1477: AND tasks.task_type = 1

Line 1589: FROM opi_dbi_wms_ex_stg ex

1585: ,sum(nvl(exs.ex_cnt,0)) exceptions
1586: FROM opi_dbi_wms_op_stg ops
1587: ,(SELECT NVL(ex.op_plan_instance_id,0) op_plan_instance_id
1588: ,count(ex.exception_id) ex_cnt
1589: FROM opi_dbi_wms_ex_stg ex
1590: WHERE ex.operation_plan_indicator = 2
1591: GROUP BY nvl(ex.op_plan_instance_id,0)) exs
1592: WHERE ops.op_plan_instance_id = exs.op_plan_instance_id(+)
1593: GROUP BY ops.organization_id

Line 1711: FROM opi_dbi_wms_ex_stg exs

1707: ,exs.operation_plan_status operation_plan_status
1708: ,exs.reason_id reason_id
1709: ,trunc(exs.completion_date) completion_date
1710: ,COUNT(exs.exception_id) exceptions
1711: FROM opi_dbi_wms_ex_stg exs
1712: GROUP BY exs.organization_id
1713: ,exs.subinventory_code
1714: ,exs.inventory_item_id
1715: ,exs.operation_plan_id