[Home] [Help]
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,
412: wms_op_operation_instances wooi,
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,
467: mtl_item_locations milk1,
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,
528: mtl_item_locations milk1,
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,
591: wms_op_operation_instances wooi2,
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,
640: mtl_item_locations milk1,
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,
698: mtl_item_locations milk1,
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,
757: wms_op_operation_instances wooi,
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,
810: wms_dispatched_tasks_history wdth,
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,
872: wms_dispatched_tasks_history wdth,
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,
935: wms_op_operation_instances wooi2,
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,
985: mtl_item_locations milk1,
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,
1041: mtl_item_locations milk1,
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,
1099: wms_op_operation_instances wooi,
1100: wms_op_operation_instances wooi2,
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,
1151: mtl_item_locations milk2
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,
1208: mtl_item_locations milk2
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,
1267: wms_op_plan_instances wopi
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,
1311: mtl_item_locations milk2
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,
1361: mtl_item_locations milk2
1402: --
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
1431: --
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
1458: --
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))