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 MTL_ITEM_LOCATIONS

Line 240: from mtl_item_locations milk,

236: -- The first MMTT will have an operation instance WOOI that is drop active.
237:
238: cursor c_subloc_pend_wozone_woitem is
239: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
240: from mtl_item_locations milk,
241: mtl_material_transactions_temp mmtt,
242: wms_op_operation_instances wooi,
243: wms_op_plan_instances wopi,
244: wms_license_plate_numbers wlpn1,

Line 264: from mtl_item_locations milk,

260: --
261: --
262: cursor c_subloc_pend_wzn_wosub_woitem is
263: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
264: from mtl_item_locations milk,
265: wms_zone_locators wzl,
266: mtl_material_transactions_temp mmtt,
267: wms_op_operation_instances wooi,
268: wms_op_plan_instances wopi,

Line 292: from mtl_item_locations milk,

288: --
289: --
290: cursor c_subloc_pend_wzn_wsub_woitem is
291: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
292: from mtl_item_locations milk,
293: wms_zone_locators wzl,
294: mtl_material_transactions_temp mmtt,
295: wms_op_operation_instances wooi,
296: wms_op_plan_instances wopi,

Line 322: from mtl_item_locations milk,

318: --
319:
320: cursor c_subloc_pend_wozone_witem is
321: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
322: from mtl_item_locations milk,
323: mtl_material_transactions_temp mmtt,
324: wms_op_operation_instances wooi,
325: wms_op_plan_instances wopi,
326: wms_license_plate_numbers wlpn1,

Line 347: from mtl_item_locations milk,

343: --
344: --
345: cursor c_subloc_pend_wzn_wosub_witem is
346: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
347: from mtl_item_locations milk,
348: wms_zone_locators wzl,
349: mtl_material_transactions_temp mmtt,
350: wms_op_operation_instances wooi,
351: wms_op_plan_instances wopi,

Line 376: from mtl_item_locations milk,

372: --
373: --
374: cursor c_subloc_pend_wzn_wsub_witem is
375: select milk.subinventory_code, nvl(milk.physical_location_id, milk.inventory_location_id)
376: from mtl_item_locations milk,
377: wms_zone_locators wzl,
378: mtl_material_transactions_temp mmtt,
379: wms_op_operation_instances wooi,
380: wms_op_plan_instances wopi,

Line 406: from mtl_item_locations milk1,

402:
403:
404: cursor c_act_wzone_wsub_witem is
405: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
406: from mtl_item_locations milk1,
407: mtl_item_locations milk2,
408: mtl_secondary_inventories msi,
409: wms_zone_locators wzl,
410: -- ***** tables from the inner cursor *****

Line 407: mtl_item_locations milk2,

403:
404: cursor c_act_wzone_wsub_witem is
405: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
406: from mtl_item_locations milk1,
407: mtl_item_locations milk2,
408: mtl_secondary_inventories msi,
409: wms_zone_locators wzl,
410: -- ***** tables from the inner cursor *****
411: mtl_material_transactions_temp mmtt,

Line 467: mtl_item_locations milk1,

463: mtl_secondary_inventories msi,
464: wms_zone_locators wzl,
465: wms_license_plate_numbers wlpn,
466: wms_dispatched_tasks_history wdth,
467: mtl_item_locations milk1,
468: mtl_item_locations milk2
469: where milk2.subinventory_code = msi.secondary_inventory_name
470: and milk2.organization_id = msi.organization_id
471: and ((milk2.disable_date is null and msi.disable_date is null)

Line 468: mtl_item_locations milk2

464: wms_zone_locators wzl,
465: wms_license_plate_numbers wlpn,
466: wms_dispatched_tasks_history wdth,
467: mtl_item_locations milk1,
468: mtl_item_locations milk2
469: where milk2.subinventory_code = msi.secondary_inventory_name
470: and milk2.organization_id = msi.organization_id
471: and ((milk2.disable_date is null and msi.disable_date is null)
472: or (not ( milk2.disable_date < l_sys_date

Line 528: mtl_item_locations milk1,

524: mtl_secondary_inventories msi,
525: wms_zone_locators wzl,
526: wms_license_plate_numbers wlpn,
527: wms_dispatched_tasks_history wdth,
528: mtl_item_locations milk1,
529: mtl_item_locations milk2
530: where milk2.subinventory_code = msi.secondary_inventory_name
531: and milk2.organization_id = msi.organization_id
532: and ((milk2.disable_date is null and msi.disable_date is null)

Line 529: mtl_item_locations milk2

525: wms_zone_locators wzl,
526: wms_license_plate_numbers wlpn,
527: wms_dispatched_tasks_history wdth,
528: mtl_item_locations milk1,
529: mtl_item_locations milk2
530: where milk2.subinventory_code = msi.secondary_inventory_name
531: and milk2.organization_id = msi.organization_id
532: and ((milk2.disable_date is null and msi.disable_date is null)
533: or (not ( milk2.disable_date < l_sys_date

Line 585: mtl_item_locations milk1,

581: --
582: cursor c_act_wzone_wsub_woitem is
583: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
584: from
585: mtl_item_locations milk1,
586: mtl_item_locations milk2,
587: mtl_secondary_inventories msi,
588: wms_zone_locators wzl,
589: -- ***** tables from the inner cursor *****

Line 586: mtl_item_locations milk2,

582: cursor c_act_wzone_wsub_woitem is
583: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
584: from
585: mtl_item_locations milk1,
586: mtl_item_locations milk2,
587: mtl_secondary_inventories msi,
588: wms_zone_locators wzl,
589: -- ***** tables from the inner cursor *****
590: wms_op_operation_instances wooi,

Line 640: mtl_item_locations milk1,

636: mtl_secondary_inventories msi,
637: wms_zone_locators wzl,
638: wms_dispatched_tasks_history wdth,
639: wms_license_plate_numbers wlpn,
640: mtl_item_locations milk1,
641: mtl_item_locations milk2
642: where milk2.subinventory_code = msi.secondary_inventory_name
643: and milk2.organization_id = msi.organization_id
644: and ((milk2.disable_date is null and msi.disable_date is null)

Line 641: mtl_item_locations milk2

637: wms_zone_locators wzl,
638: wms_dispatched_tasks_history wdth,
639: wms_license_plate_numbers wlpn,
640: mtl_item_locations milk1,
641: mtl_item_locations milk2
642: where milk2.subinventory_code = msi.secondary_inventory_name
643: and milk2.organization_id = msi.organization_id
644: and ((milk2.disable_date is null and msi.disable_date is null)
645: or (not ( milk2.disable_date < l_sys_date

Line 698: mtl_item_locations milk1,

694: mtl_secondary_inventories msi,
695: wms_zone_locators wzl,
696: wms_dispatched_tasks_history wdth,
697: wms_license_plate_numbers wlpn,
698: mtl_item_locations milk1,
699: mtl_item_locations milk2
700: where milk2.subinventory_code = msi.secondary_inventory_name
701: and milk2.organization_id = msi.organization_id
702: and ((milk2.disable_date is null and msi.disable_date is null)

Line 699: mtl_item_locations milk2

695: wms_zone_locators wzl,
696: wms_dispatched_tasks_history wdth,
697: wms_license_plate_numbers wlpn,
698: mtl_item_locations milk1,
699: mtl_item_locations milk2
700: where milk2.subinventory_code = msi.secondary_inventory_name
701: and milk2.organization_id = msi.organization_id
702: and ((milk2.disable_date is null and msi.disable_date is null)
703: or (not ( milk2.disable_date < l_sys_date

Line 751: from mtl_item_locations milk1,

747: --
748: --
749: cursor c_act_wzone_only_witem is
750: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
751: from mtl_item_locations milk1,
752: mtl_item_locations milk2,
753: mtl_secondary_inventories msi,
754: wms_zone_locators wzl,
755: -- ***** tables from the inner cursor *****

Line 752: mtl_item_locations milk2,

748: --
749: cursor c_act_wzone_only_witem is
750: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
751: from mtl_item_locations milk1,
752: mtl_item_locations milk2,
753: mtl_secondary_inventories msi,
754: wms_zone_locators wzl,
755: -- ***** tables from the inner cursor *****
756: mtl_material_transactions_temp mmtt,

Line 804: from mtl_item_locations milk1,

800: --
801: --
802: cursor c_comp_wzone_only_witem is
803: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
804: from mtl_item_locations milk1,
805: mtl_item_locations milk2,
806: mtl_secondary_inventories msi,
807: wms_zone_locators wzl,
808: -- ***** tables from the inner cursor *****

Line 805: mtl_item_locations milk2,

801: --
802: cursor c_comp_wzone_only_witem is
803: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
804: from mtl_item_locations milk1,
805: mtl_item_locations milk2,
806: mtl_secondary_inventories msi,
807: wms_zone_locators wzl,
808: -- ***** tables from the inner cursor *****
809: wms_license_plate_numbers wlpn,

Line 866: from mtl_item_locations milk1,

862: --
863: --
864: cursor c_comp_wzoneonlyitem_destsub is
865: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
866: from mtl_item_locations milk1,
867: mtl_item_locations milk2,
868: mtl_secondary_inventories msi,
869: wms_zone_locators wzl,
870: -- ***** tables from the inner cursor *****

Line 867: mtl_item_locations milk2,

863: --
864: cursor c_comp_wzoneonlyitem_destsub is
865: select wooih.to_subinventory_code, milk2.inventory_location_id, wzl.zone_id
866: from mtl_item_locations milk1,
867: mtl_item_locations milk2,
868: mtl_secondary_inventories msi,
869: wms_zone_locators wzl,
870: -- ***** tables from the inner cursor *****
871: wms_license_plate_numbers wlpn,

Line 929: from mtl_item_locations milk1,

925: --
926: --
927: cursor c_act_wzone_only_woitem is
928: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
929: from mtl_item_locations milk1,
930: mtl_item_locations milk2,
931: mtl_secondary_inventories msi,
932: wms_zone_locators wzl,
933: -- ***** tables from the inner cursor *****

Line 930: mtl_item_locations milk2,

926: --
927: cursor c_act_wzone_only_woitem is
928: select wooi.from_subinventory_code, milk2.inventory_location_id, wzl.zone_id
929: from mtl_item_locations milk1,
930: mtl_item_locations milk2,
931: mtl_secondary_inventories msi,
932: wms_zone_locators wzl,
933: -- ***** tables from the inner cursor *****
934: wms_op_operation_instances wooi,

Line 985: mtl_item_locations milk1,

981: mtl_secondary_inventories msi,
982: wms_zone_locators wzl,
983: wms_dispatched_tasks_history wdth,
984: wms_license_plate_numbers wlpn,
985: mtl_item_locations milk1,
986: mtl_item_locations milk2
987: where milk2.subinventory_code = msi.secondary_inventory_name
988: and milk2.organization_id = msi.organization_id
989: and ((milk2.disable_date is null and msi.disable_date is null)

Line 986: mtl_item_locations milk2

982: wms_zone_locators wzl,
983: wms_dispatched_tasks_history wdth,
984: wms_license_plate_numbers wlpn,
985: mtl_item_locations milk1,
986: mtl_item_locations milk2
987: where milk2.subinventory_code = msi.secondary_inventory_name
988: and milk2.organization_id = msi.organization_id
989: and ((milk2.disable_date is null and msi.disable_date is null)
990: or (not ( milk2.disable_date < l_sys_date

Line 1041: mtl_item_locations milk1,

1037: mtl_secondary_inventories msi,
1038: wms_zone_locators wzl,
1039: wms_dispatched_tasks_history wdth,
1040: wms_license_plate_numbers wlpn,
1041: mtl_item_locations milk1,
1042: mtl_item_locations milk2
1043: where milk2.subinventory_code = msi.secondary_inventory_name
1044: and milk2.organization_id = msi.organization_id
1045: and ((milk2.disable_date is null and msi.disable_date is null)

Line 1042: mtl_item_locations milk2

1038: wms_zone_locators wzl,
1039: wms_dispatched_tasks_history wdth,
1040: wms_license_plate_numbers wlpn,
1041: mtl_item_locations milk1,
1042: mtl_item_locations milk2
1043: where milk2.subinventory_code = msi.secondary_inventory_name
1044: and milk2.organization_id = msi.organization_id
1045: and ((milk2.disable_date is null and msi.disable_date is null)
1046: or (not ( milk2.disable_date < l_sys_date

Line 1093: mtl_item_locations milk1,

1089: --
1090: cursor c_act_wozone_witem is
1091: select wooi.from_subinventory_code, milk2.inventory_location_id
1092: from
1093: mtl_item_locations milk1,
1094: mtl_item_locations milk2,
1095:
1096: mtl_secondary_inventories msi,
1097: -- ***** tables from the inner cursor *****

Line 1094: mtl_item_locations milk2,

1090: cursor c_act_wozone_witem is
1091: select wooi.from_subinventory_code, milk2.inventory_location_id
1092: from
1093: mtl_item_locations milk1,
1094: mtl_item_locations milk2,
1095:
1096: mtl_secondary_inventories msi,
1097: -- ***** tables from the inner cursor *****
1098: mtl_material_transactions_temp mmtt,

Line 1150: mtl_item_locations milk1,

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,
1151: mtl_item_locations milk2
1152: where milk2.subinventory_code = msi.secondary_inventory_name
1153: and milk2.organization_id = msi.organization_id
1154: and ((milk2.disable_date is null and msi.disable_date is null)

Line 1151: mtl_item_locations milk2

1147: mtl_secondary_inventories msi,
1148: wms_dispatched_tasks_history wdth,
1149: wms_license_plate_numbers wlpn,
1150: mtl_item_locations milk1,
1151: mtl_item_locations milk2
1152: where milk2.subinventory_code = msi.secondary_inventory_name
1153: and milk2.organization_id = msi.organization_id
1154: and ((milk2.disable_date is null and msi.disable_date is null)
1155: or (not ( milk2.disable_date < l_sys_date

Line 1207: mtl_item_locations milk1,

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,
1208: mtl_item_locations milk2
1209: where milk2.subinventory_code = msi.secondary_inventory_name
1210: and milk2.organization_id = msi.organization_id
1211: and ((milk2.disable_date is null and msi.disable_date is null)

Line 1208: mtl_item_locations milk2

1204: mtl_secondary_inventories msi,
1205: wms_dispatched_tasks_history wdth,
1206: wms_license_plate_numbers wlpn,
1207: mtl_item_locations milk1,
1208: mtl_item_locations milk2
1209: where milk2.subinventory_code = msi.secondary_inventory_name
1210: and milk2.organization_id = msi.organization_id
1211: and ((milk2.disable_date is null and msi.disable_date is null)
1212: or (not ( milk2.disable_date < l_sys_date

Line 1261: mtl_item_locations milk1,

1257: --
1258: cursor c_act_wozone_woitem is
1259: select wooi.from_subinventory_code, milk2.inventory_location_id
1260: from
1261: mtl_item_locations milk1,
1262: mtl_item_locations milk2,
1263: mtl_secondary_inventories msi,
1264: -- ***** tables from the inner cursor *****
1265: wms_op_operation_instances wooi,

Line 1262: mtl_item_locations milk2,

1258: cursor c_act_wozone_woitem is
1259: select wooi.from_subinventory_code, milk2.inventory_location_id
1260: from
1261: mtl_item_locations milk1,
1262: mtl_item_locations milk2,
1263: mtl_secondary_inventories msi,
1264: -- ***** tables from the inner cursor *****
1265: wms_op_operation_instances wooi,
1266: wms_op_operation_instances wooi2,

Line 1310: mtl_item_locations milk1,

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,
1311: mtl_item_locations milk2
1312: where milk2.subinventory_code = msi.secondary_inventory_name
1313: and milk2.organization_id = msi.organization_id
1314: and ((milk2.disable_date is null and msi.disable_date is null)

Line 1311: mtl_item_locations milk2

1307: mtl_secondary_inventories msi,
1308: wms_dispatched_tasks_history wdth,
1309: wms_license_plate_numbers wlpn,
1310: mtl_item_locations milk1,
1311: mtl_item_locations milk2
1312: where milk2.subinventory_code = msi.secondary_inventory_name
1313: and milk2.organization_id = msi.organization_id
1314: and ((milk2.disable_date is null and msi.disable_date is null)
1315: or (not ( milk2.disable_date < l_sys_date

Line 1360: mtl_item_locations milk1,

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,
1361: mtl_item_locations milk2
1362: where milk2.subinventory_code = msi.secondary_inventory_name
1363: and milk2.organization_id = msi.organization_id
1364: and ((milk2.disable_date is null and msi.disable_date is null)

Line 1361: mtl_item_locations milk2

1357: mtl_secondary_inventories msi,
1358: wms_dispatched_tasks_history wdth,
1359: wms_license_plate_numbers wlpn,
1360: mtl_item_locations milk1,
1361: mtl_item_locations milk2
1362: where milk2.subinventory_code = msi.secondary_inventory_name
1363: and milk2.organization_id = msi.organization_id
1364: and ((milk2.disable_date is null and msi.disable_date is null)
1365: or (not ( milk2.disable_date < l_sys_date

Line 1407: mtl_item_locations milk,

1403: --
1404: cursor c_aux_wzone_wsub is
1405: select milk.inventory_location_id, milk.subinventory_code, wzl.zone_id
1406: from mtl_secondary_inventories msi,
1407: mtl_item_locations milk,
1408: wms_zone_locators wzl
1409: where milk.subinventory_code = msi.secondary_inventory_name
1410: and milk.organization_id = msi.organization_id
1411: and ((milk.disable_date is null and msi.disable_date is null)

Line 1436: mtl_item_locations milk,

1432: --
1433: cursor c_aux_wzone_only is
1434: select milk.inventory_location_id, milk.subinventory_code, wzl.zone_id
1435: from mtl_secondary_inventories msi,
1436: mtl_item_locations milk,
1437: wms_zone_locators wzl
1438: where milk.subinventory_code = msi.secondary_inventory_name
1439: and milk.organization_id = msi.organization_id
1440: and ((milk.disable_date is null and msi.disable_date is null)

Line 1463: mtl_item_locations milk

1459: --
1460: cursor c_aux_wsub_only is
1461: select milk.inventory_location_id, milk.subinventory_code
1462: from mtl_secondary_inventories msi,
1463: mtl_item_locations milk
1464: where ((milk.disable_date is null and msi.disable_date is null)
1465: or (not ( milk.disable_date < l_sys_date
1466: or msi.disable_date < l_sys_date))
1467: or ( msi.disable_date = to_date('01/01/1700', 'DD/MM/RRRR')