[Home] [Help]
26: RETURN DATE IS
27: --
28: CURSOR c_opi_gsd IS
29: SELECT MIN(creation_date)
30: FROM wms_dispatched_tasks_history
31: WHERE transaction_temp_id IS NOT NULL;
32: --
33: CURSOR c_wms_gsd IS
34: SELECT last_run_date
701: ,CASE WHEN wdth.task_type = 1 THEN wdth.source_subinventory_code
702: WHEN wdth.task_type in (2,8) THEN wdth.dest_subinventory_code
703: END subinventory_code
704: ,wdth.transaction_temp_id transaction_temp_id
705: from wms_dispatched_tasks_history wdth
706: ,mtl_system_items_b msi
707: ,mtl_secondary_inventories sinv
708: where wdth.inventory_item_id = msi.inventory_item_id
709: AND wdth.organization_id = msi.organization_id
1230: ,wdth.op_plan_instance_id op_plan_instance_id
1231: ,nvl(wdth.is_parent,'Y') is_parent
1232: ,wdth.source_subinventory_code subinventory_code
1233: ,wdth.transaction_temp_id transaction_temp_id
1234: from wms_dispatched_tasks_history wdth
1235: ,mtl_system_items_b msi
1236: ,mtl_secondary_inventories sinv
1237: ,opi_dbi_conc_prog_run_log log
1238: where wdth.inventory_item_id = msi.inventory_item_id
1307: ,wopih.plan_execution_start_date plan_execution_start_date
1308: ,wopih.plan_execution_end_date plan_execution_end_date
1309: ,( wopih.plan_execution_end_date
1310: - wopih.plan_execution_start_date)*24 plan_elapsed_time
1311: FROM wms_dispatched_tasks_history wdth
1312: ,opi_dbi_conc_prog_run_log log
1313: ,wms_op_plan_instances_hist wopih
1314: ,wms_op_plans_b wop
1315: ,mtl_system_items_b msi
1413: ,ops.plan_execution_end_date completion_date
1414: ,wmx.reason_id reason_id
1415: FROM opi_dbi_wms_op_stg ops
1416: ,wms_exceptions wmx
1417: ,wms_dispatched_tasks_history wdth
1418: ,mtl_transaction_reasons mtr
1419: WHERE wdth.op_plan_instance_id = ops.op_plan_instance_id
1420: AND wdth.task_type in (2,8)
1421: AND wdth.transaction_temp_id IS NOT NULL