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_ARCHIVE_PVT dependencies on WMS_OP_PLAN_INSTANCES_ARCH

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 833: trace(l_proc || ' Start of insert into wms_op_plan_instances_arch ...');

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:
836: insert into wms_op_plan_instances_arch(
837: OP_PLAN_INSTANCE_ID

Line 836: insert into wms_op_plan_instances_arch(

832: if (l_debug = 1) then
833: trace(l_proc || ' Start of insert into wms_op_plan_instances_arch ...');
834: end if;
835:
836: insert into wms_op_plan_instances_arch(
837: OP_PLAN_INSTANCE_ID
838: ,OPERATION_PLAN_ID
839: ,STATUS
840: ,ORGANIZATION_ID

Line 915: trace(l_proc || ' End of insert into wms_op_plan_instances_arch ...');

911: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
912: end if;
913:
914: if (l_debug = 1) then
915: trace(l_proc || ' End of insert into wms_op_plan_instances_arch ...');
916: end if;
917:
918: -- @@@ Insert records from the wms_op_opertn_instances_hist into wms_op_opertn_instances_arch
919: if (l_debug = 1) then

Line 1503: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia

1499: ,wdta.TASK_METHOD
1500: ,wdta.TRANSACTION_TYPE_ID
1501: ,wdta.TRANSACTION_SOURCE_TYPE_ID
1502: ,wdta.TRANSACTION_ACTION_ID
1503: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia
1504: where wdta.last_update_date < l_min_date
1505: and wopia.op_plan_instance_id = wdta.op_plan_instance_id
1506: and wdta.organization_id = wopia.organization_id
1507: and wdta.organization_id = nvl(p_org_id, wdta.organization_id)

Line 1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia

1524: -- @@@ Delete this information from the wms_dispatched_tasks_arch table after inserting.
1525: delete from wms_dispatched_tasks_arch
1526: where task_id in (
1527: select wdta.task_id
1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia
1529: where wdta.last_update_date <= l_min_date
1530: and wopia.op_plan_instance_id = wdta.op_plan_instance_id
1531: and wdta.organization_id = wopia.organization_id
1532: and wdta.organization_id = nvl(p_org_id, wdta.organization_id)

Line 1982: -- @@@ Insert records from the wms_op_plan_instance_hist into wms_op_plan_instances_archive

1978: if (l_debug = 1) then
1979: trace(l_proc || ' End of insert into wms_dispatched_tasks_history ...');
1980: end if;
1981:
1982: -- @@@ Insert records from the wms_op_plan_instance_hist into wms_op_plan_instances_archive
1983: if (l_debug = 1) then
1984: trace(l_proc || ' Start of insert into wms_op_plan_instance_hist ...');
1985: end if;
1986:

Line 2055: from wms_op_plan_instances_arch wopia

2051: ,ORIG_SOURCE_SUB_CODE
2052: ,ORIG_SOURCE_LOC_ID
2053: ,ORIG_DEST_SUB_CODE
2054: ,ORIG_DEST_LOC_ID
2055: from wms_op_plan_instances_arch wopia
2056: where wopia.last_update_date > l_min_date
2057: and wopia.last_update_date <= l_max_date
2058: and wopia.organization_id = nvl(p_org_id, wopia.organization_id);
2059:

Line 2196: -- @@@ Delete records from the wms_op_plan_instances_arch table.

2192: if (l_debug = 1) then
2193: trace(l_proc || ' End of delete from wms_dispatched_tasks_arch ...');
2194: end if;
2195:
2196: -- @@@ Delete records from the wms_op_plan_instances_arch table.
2197: if (l_debug = 1) then
2198: trace(l_proc || ' Start of delete from wms_op_plan_instances_arch ...');
2199: end if;
2200:

Line 2198: trace(l_proc || ' Start of delete from wms_op_plan_instances_arch ...');

2194: end if;
2195:
2196: -- @@@ Delete records from the wms_op_plan_instances_arch table.
2197: if (l_debug = 1) then
2198: trace(l_proc || ' Start of delete from wms_op_plan_instances_arch ...');
2199: end if;
2200:
2201: delete from wms_op_plan_instances_arch wopia
2202: where wopia.last_update_date > l_min_date

Line 2201: delete from wms_op_plan_instances_arch wopia

2197: if (l_debug = 1) then
2198: trace(l_proc || ' Start of delete from wms_op_plan_instances_arch ...');
2199: end if;
2200:
2201: delete from wms_op_plan_instances_arch wopia
2202: where wopia.last_update_date > l_min_date
2203: and wopia.last_update_date <= l_max_date
2204: and wopia.organization_id = nvl(p_org_id, wopia.organization_id);
2205:

Line 2212: trace(l_proc || ' End of delete from wms_op_plan_instances_arch ...');

2208: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
2209: end if;
2210:
2211: if (l_debug = 1) then
2212: trace(l_proc || ' End of delete from wms_op_plan_instances_arch ...');
2213: end if;
2214:
2215: -- @@@ Delete records from the wms_op_opertn_instances_hist table
2216: if (l_debug = 1) then