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_ATF_DEST_LOC dependencies on WMS_OP_OPERTN_INSTANCES_HIST

Line 462: wms_op_opertn_instances_hist wooih,

458: --
459: cursor c_comp_wzone_wsub_witem is
460: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
461: from wms_op_plan_instances_hist wopih,
462: wms_op_opertn_instances_hist wooih,
463: mtl_secondary_inventories msi,
464: wms_zone_locators wzl,
465: wms_license_plate_numbers wlpn,
466: wms_dispatched_tasks_history wdth,

Line 506: from wms_op_opertn_instances_hist wooih2

502: and wdth.transaction_id = wooih.source_task_id
503: and wdth.inventory_item_id = p_item_id
504: and wdth.organization_id = l_organization_id -- new
505: and wooih.operation_sequence in (select max(operation_sequence)
506: from wms_op_opertn_instances_hist wooih2
507: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
508: and wooih2.operation_type_id in (2,9)
509: and wooih2.operation_status = 3)
510: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 523: wms_op_opertn_instances_hist wooih,

519: --
520: cursor c_comp_wzonesubitem_destsub is
521: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
522: from wms_op_plan_instances_hist wopih,
523: wms_op_opertn_instances_hist wooih,
524: mtl_secondary_inventories msi,
525: wms_zone_locators wzl,
526: wms_license_plate_numbers wlpn,
527: wms_dispatched_tasks_history wdth,

Line 567: from wms_op_opertn_instances_hist wooih2

563: and wdth.transaction_id = wooih.source_task_id
564: and wdth.inventory_item_id = p_item_id
565: and wdth.organization_id = l_organization_id -- new
566: and wooih.operation_sequence in (select max(operation_sequence)
567: from wms_op_opertn_instances_hist wooih2
568: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
569: and wooih2.operation_type_id in (2,9)
570: and wooih2.operation_status = 3)
571: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 635: wms_op_opertn_instances_hist wooih,

631: --
632: cursor c_comp_wzone_wsub_woitem is
633: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
634: from wms_op_plan_instances_hist wopih,
635: wms_op_opertn_instances_hist wooih,
636: mtl_secondary_inventories msi,
637: wms_zone_locators wzl,
638: wms_dispatched_tasks_history wdth,
639: wms_license_plate_numbers wlpn,

Line 675: from wms_op_opertn_instances_hist wooih2

671: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
672: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
673: and wdth.transaction_id = wooih.source_task_id
674: and wooih.operation_sequence in (select max(operation_sequence)
675: from wms_op_opertn_instances_hist wooih2
676: -- where wooih2.op_plan_instance_id = wooih.op_plan_instance_id
677: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
678: and wooih2.operation_type_id in (2,9)
679: and wooih2.operation_status = 3)

Line 693: wms_op_opertn_instances_hist wooih,

689: --
690: cursor c_comp_wzonesub_woitem_destsub is
691: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
692: from wms_op_plan_instances_hist wopih,
693: wms_op_opertn_instances_hist wooih,
694: mtl_secondary_inventories msi,
695: wms_zone_locators wzl,
696: wms_dispatched_tasks_history wdth,
697: wms_license_plate_numbers wlpn,

Line 733: from wms_op_opertn_instances_hist wooih2

729: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
730: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
731: and wdth.transaction_id = wooih.source_task_id
732: and wooih.operation_sequence in (select max(operation_sequence)
733: from wms_op_opertn_instances_hist wooih2
734: -- where wooih2.op_plan_instance_id = wooih.op_plan_instance_id
735: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
736: and wooih2.operation_type_id in (2,9)
737: and wooih2.operation_status = 3)

Line 811: wms_op_opertn_instances_hist wooih,

807: wms_zone_locators wzl,
808: -- ***** tables from the inner cursor *****
809: wms_license_plate_numbers wlpn,
810: wms_dispatched_tasks_history wdth,
811: wms_op_opertn_instances_hist wooih,
812: wms_op_plan_instances_hist wopih
813: where milk2.subinventory_code = msi.secondary_inventory_name
814: and milk2.organization_id = msi.organization_id
815: and ((milk2.disable_date is null and msi.disable_date is null)

Line 850: from wms_op_opertn_instances_hist wooih2

846: and wdth.organization_id = l_organization_id -- new
847: and wooih.organization_id = l_organization_id -- new
848: and wooih.to_subinventory_code = msi.secondary_inventory_name -- new
849: and wooih.operation_sequence in (select max(operation_sequence)
850: from wms_op_opertn_instances_hist wooih2
851: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
852: and wooih2.operation_type_id in (2,9)
853: and wooih2.operation_status = 3)
854: and wopih.op_plan_instance_id = wooih.op_plan_instance_id

Line 873: wms_op_opertn_instances_hist wooih,

869: wms_zone_locators wzl,
870: -- ***** tables from the inner cursor *****
871: wms_license_plate_numbers wlpn,
872: wms_dispatched_tasks_history wdth,
873: wms_op_opertn_instances_hist wooih,
874: wms_op_plan_instances_hist wopih
875: where milk2.subinventory_code = msi.secondary_inventory_name
876: and milk2.organization_id = msi.organization_id
877: and ((milk2.disable_date is null and msi.disable_date is null)

Line 912: from wms_op_opertn_instances_hist wooih2

908: and wdth.organization_id = l_organization_id -- new
909: and wooih.organization_id = l_organization_id -- new
910: and wooih.to_subinventory_code = msi.secondary_inventory_name -- new
911: and wooih.operation_sequence in (select max(operation_sequence)
912: from wms_op_opertn_instances_hist wooih2
913: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
914: and wooih2.operation_type_id in (2,9)
915: and wooih2.operation_status = 3)
916: and wopih.op_plan_instance_id = wooih.op_plan_instance_id

Line 980: wms_op_opertn_instances_hist wooih,

976: --
977: cursor c_comp_wzone_only_woitem is
978: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
979: from wms_op_plan_instances_hist wopih,
980: wms_op_opertn_instances_hist wooih,
981: mtl_secondary_inventories msi,
982: wms_zone_locators wzl,
983: wms_dispatched_tasks_history wdth,
984: wms_license_plate_numbers wlpn,

Line 1019: from wms_op_opertn_instances_hist wooih2

1015: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
1016: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
1017: and wdth.transaction_id = wooih.source_task_id
1018: and wooih.operation_sequence in (select max(operation_sequence)
1019: from wms_op_opertn_instances_hist wooih2
1020: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1021: and wooih2.operation_type_id in (2,9)
1022: and wooih2.operation_status = 3)
1023: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 1036: wms_op_opertn_instances_hist wooih,

1032: --
1033: cursor c_comp_wzoneonlywoitem_destsub is
1034: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
1035: from wms_op_plan_instances_hist wopih,
1036: wms_op_opertn_instances_hist wooih,
1037: mtl_secondary_inventories msi,
1038: wms_zone_locators wzl,
1039: wms_dispatched_tasks_history wdth,
1040: wms_license_plate_numbers wlpn,

Line 1075: from wms_op_opertn_instances_hist wooih2

1071: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
1072: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
1073: and wdth.transaction_id = wooih.source_task_id
1074: and wooih.operation_sequence in (select max(operation_sequence)
1075: from wms_op_opertn_instances_hist wooih2
1076: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1077: and wooih2.operation_type_id in (2,9)
1078: and wooih2.operation_status = 3)
1079: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 1146: wms_op_opertn_instances_hist wooih,

1142: --
1143: cursor c_comp_wozone_witem is
1144: select wlpn.subinventory_code, milk2.inventory_location_id
1145: from wms_op_plan_instances_hist wopih,
1146: wms_op_opertn_instances_hist wooih,
1147: mtl_secondary_inventories msi,
1148: wms_dispatched_tasks_history wdth,
1149: wms_license_plate_numbers wlpn,
1150: mtl_item_locations milk1,

Line 1185: from wms_op_opertn_instances_hist wooih2

1181: and wdth.transaction_id = wooih.source_task_id
1182: and wdth.organization_id = l_organization_id
1183: and wdth.inventory_item_id = p_item_id
1184: and wooih.operation_sequence in (select max(operation_sequence)
1185: from wms_op_opertn_instances_hist wooih2
1186: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1187: and wooih2.operation_type_id in (2,9)
1188: and wooih2.operation_status = 3)
1189: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 1203: wms_op_opertn_instances_hist wooih,

1199: --
1200: cursor c_comp_wozone_witem_destsub is
1201: select wlpn.subinventory_code, milk2.inventory_location_id
1202: from wms_op_plan_instances_hist wopih,
1203: wms_op_opertn_instances_hist wooih,
1204: mtl_secondary_inventories msi,
1205: wms_dispatched_tasks_history wdth,
1206: wms_license_plate_numbers wlpn,
1207: mtl_item_locations milk1,

Line 1242: from wms_op_opertn_instances_hist wooih2

1238: and wdth.transaction_id = wooih.source_task_id
1239: and wdth.organization_id = l_organization_id
1240: and wdth.inventory_item_id = p_item_id
1241: and wooih.operation_sequence in (select max(operation_sequence)
1242: from wms_op_opertn_instances_hist wooih2
1243: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1244: and wooih2.operation_type_id in (2,9)
1245: and wooih2.operation_status = 3)
1246: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 1306: wms_op_opertn_instances_hist wooih,

1302: --
1303: cursor c_comp_wozone_woitem is
1304: select wlpn.subinventory_code, milk2.inventory_location_id
1305: from wms_op_plan_instances_hist wopih,
1306: wms_op_opertn_instances_hist wooih,
1307: mtl_secondary_inventories msi,
1308: wms_dispatched_tasks_history wdth,
1309: wms_license_plate_numbers wlpn,
1310: mtl_item_locations milk1,

Line 1340: from wms_op_opertn_instances_hist wooih2

1336: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
1337: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
1338: and wdth.transaction_id = wooih.source_task_id
1339: and wooih.operation_sequence in (select max(operation_sequence)
1340: from wms_op_opertn_instances_hist wooih2
1341: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1342: and wooih2.operation_type_id in (2,9)
1343: and wooih2.operation_status = 3)
1344: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 1356: wms_op_opertn_instances_hist wooih,

1352: --
1353: cursor c_comp_wozone_woitem_destsub is
1354: select wlpn.subinventory_code, milk2.inventory_location_id
1355: from wms_op_plan_instances_hist wopih,
1356: wms_op_opertn_instances_hist wooih,
1357: mtl_secondary_inventories msi,
1358: wms_dispatched_tasks_history wdth,
1359: wms_license_plate_numbers wlpn,
1360: mtl_item_locations milk1,

Line 1390: from wms_op_opertn_instances_hist wooih2

1386: and wlpn.lpn_id = nvl(wdth.transfer_lpn_id, wdth.content_lpn_id)
1387: and wdth.status = 6 -- Completed. lookup_type is WMS_TASK_STATUS
1388: and wdth.transaction_id = wooih.source_task_id
1389: and wooih.operation_sequence in (select max(operation_sequence)
1390: from wms_op_opertn_instances_hist wooih2
1391: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
1392: and wooih2.operation_type_id in (2,9)
1393: and wooih2.operation_status = 3)
1394: and wooih.op_plan_instance_id = wopih.op_plan_instance_id