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_PLAN_INSTANCES_HIST

Line 461: from wms_op_plan_instances_hist wopih,

457: --
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,

Line 522: from wms_op_plan_instances_hist wopih,

518: --
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,

Line 634: from wms_op_plan_instances_hist wopih,

630: --
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,

Line 692: from wms_op_plan_instances_hist wopih,

688: --
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,

Line 812: wms_op_plan_instances_hist wopih

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)
816: or (not ( milk2.disable_date < l_sys_date

Line 874: wms_op_plan_instances_hist wopih

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)
878: or (not ( milk2.disable_date < l_sys_date

Line 979: from wms_op_plan_instances_hist wopih,

975: --
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,

Line 1035: from wms_op_plan_instances_hist wopih,

1031: --
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,

Line 1145: from wms_op_plan_instances_hist wopih,

1141: --
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,

Line 1202: from wms_op_plan_instances_hist wopih,

1198: --
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,

Line 1305: from wms_op_plan_instances_hist wopih,

1301: --
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,

Line 1355: from wms_op_plan_instances_hist wopih,

1351: --
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,