APPS.WMS_ARCHIVE_PVT dependencies on WMS_OP_PLAN_INSTANCES_HIST

Line 657: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih

653: ,wdth.TASK_METHOD
654: ,wdth.TRANSACTION_TYPE_ID
655: ,wdth.TRANSACTION_SOURCE_TYPE_ID
656: ,wdth.TRANSACTION_ACTION_ID
657: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih
658: where wdth.last_update_date > l_min_date
659: and wdth.last_update_date <= l_max_date
660: and wdth.parent_transaction_id is not null
661: and wdth.task_type in (2,8)

Line 831: -- @@@ Insert records into the wms_op_plan_instances_arch from the wms_op_plan_instances_hist

827: trace(l_proc || ' End of insert into wms_dispatched_tasks_arch ...');
828: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
829: end if;
830:
831: -- @@@ Insert records into the wms_op_plan_instances_arch from the wms_op_plan_instances_hist
832: if (l_debug = 1) then
833: trace(l_proc || ' Start of insert into wms_op_plan_instances_arch ...');
834: end if;
835:

Line 904: from wms_op_plan_instances_hist wopih

900: ,ORIG_SOURCE_SUB_CODE
901: ,ORIG_SOURCE_LOC_ID
902: ,ORIG_DEST_SUB_CODE
903: ,ORIG_DEST_LOC_ID
904: from wms_op_plan_instances_hist wopih
905: where wopih.last_update_date > l_min_date
906: and wopih.last_update_date <= l_max_date
907: and wopih.organization_id = nvl(p_org_id, wopih.organization_id);
908:

Line 1031: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih

1027:
1028: delete from wms_dispatched_tasks_history
1029: where task_id in (
1030: select wdth.task_id
1031: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih
1032: where wdth.last_update_date > l_min_date
1033: and wdth.last_update_date <= l_max_date
1034: and wdth.parent_transaction_id is not null
1035: and wdth.task_type in (2,8)

Line 1072: -- @@@ Delete records from the wms_op_plan_instances_hist table.

1068: trace(l_proc || ' End of delete from wms_dispatched_tasks_history ...');
1069: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
1070: end if;
1071:
1072: -- @@@ Delete records from the wms_op_plan_instances_hist table.
1073: if (l_debug = 1) then
1074: trace(l_proc || ' Start of delete from wms_op_plan_instances_hist ...');
1075: end if;
1076:

Line 1074: trace(l_proc || ' Start of delete from wms_op_plan_instances_hist ...');

1070: end if;
1071:
1072: -- @@@ Delete records from the wms_op_plan_instances_hist table.
1073: if (l_debug = 1) then
1074: trace(l_proc || ' Start of delete from wms_op_plan_instances_hist ...');
1075: end if;
1076:
1077: delete from wms_op_plan_instances_hist wopih
1078: where wopih.last_update_date > l_min_date

Line 1077: delete from wms_op_plan_instances_hist wopih

1073: if (l_debug = 1) then
1074: trace(l_proc || ' Start of delete from wms_op_plan_instances_hist ...');
1075: end if;
1076:
1077: delete from wms_op_plan_instances_hist wopih
1078: where wopih.last_update_date > l_min_date
1079: and wopih.last_update_date <= l_max_date
1080: and wopih.organization_id = nvl(p_org_id, wopih.organization_id);
1081:

Line 1088: trace(l_proc || ' End of delete from wms_op_plan_instances_hist ...');

1084: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1085: end if;
1086:
1087: if (l_debug = 1) then
1088: trace(l_proc || ' End of delete from wms_op_plan_instances_hist ...');
1089: end if;
1090:
1091: -- @@@ Delete records from the wms_op_opertn_instances_hist table
1092: if (l_debug = 1) then

Line 1987: insert into wms_op_plan_instances_hist(

1983: if (l_debug = 1) then
1984: trace(l_proc || ' Start of insert into wms_op_plan_instance_hist ...');
1985: end if;
1986:
1987: insert into wms_op_plan_instances_hist(
1988: OP_PLAN_INSTANCE_ID
1989: ,OPERATION_PLAN_ID
1990: ,STATUS
1991: ,ORGANIZATION_ID