[Home] [Help]
114: WHERE organization_id = l_locator_rec.organization_id;
115:
116: SELECT *
117: INTO l_subinventory_code
118: FROM mtl_secondary_inventories
119: WHERE secondary_inventory_name = l_locator_rec.subinventory_code
120: AND organization_id = l_locator_rec.organization_id;
121:
122:
292: wdth.creation_date
293: FROM wsh_delivery_details wdd,
294: wsh_delivery_assignments_v wda,
295: mtl_item_locations mil,
296: mtl_secondary_inventories msi,
297: wms_dispatched_tasks_history wdth
298: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
299: wdd.released_status = 'Y' AND
300: wdd.locator_id = mil.inventory_location_id AND
314: FROM mtl_material_transactions_temp mmtt,
315: wsh_delivery_details wdd,
316: wsh_delivery_assignments_v wda,
317: mtl_item_locations mil,
318: mtl_secondary_inventories msi
319: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
320: mmtt.move_order_line_id = wdd.move_order_line_id AND
321: wdd.delivery_detail_id = wda.delivery_detail_id AND
322: wdd.released_status = 'S' AND
340: mtl_material_transactions_temp pmmtt,
341: wsh_delivery_details wdd,
342: wsh_delivery_assignments_v wda,
343: mtl_item_locations mil,
344: mtl_secondary_inventories msi
345: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
346: mmtt.move_order_line_id = wdd.move_order_line_id AND
347: wdd.delivery_detail_id = wda.delivery_detail_id AND
348: wdd.released_status = 'S' AND
371: FROM wsh_delivery_details wdd,
372: wsh_delivery_assignments_v wda,
373: mtl_txn_request_lines mol,
374: mtl_item_locations mil,
375: mtl_secondary_inventories msi,
376: wms_dispatched_tasks_history wdth
377: WHERE
378: mol.line_id = wdd.move_order_line_id AND
379: wdd.released_status = 'Y' AND
397: mtl_txn_request_lines mol,
398: wsh_delivery_details wdd,
399: wsh_delivery_assignments_v wda,
400: mtl_item_locations mil,
401: mtl_secondary_inventories msi
402: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
403: mmtt.move_order_line_id = mol.line_id AND
404: mol.carton_grouping_id = v_carton_grouping_id AND
405: mmtt.move_order_line_id = wdd.move_order_line_id AND
426: mtl_txn_request_lines mol,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: mtl_item_locations mil,
430: mtl_secondary_inventories msi
431: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
432: mmtt.move_order_line_id = mol.line_id AND
433: mol.carton_grouping_id = v_carton_grouping_id AND
434: mmtt.move_order_line_id = wdd.move_order_line_id AND
462: mil.subinventory_code subinventory_code,
463: mil.dropping_order,
464: mil.picking_order
465: FROM mtl_item_locations mil,
466: mtl_secondary_inventories msi,
467: mtl_material_transactions_temp mmtt
468: WHERE mmtt.transaction_temp_id = p_task_id
469: AND mil.subinventory_code = mmtt.transfer_subinventory
470: AND mil.organization_id = mmtt.organization_id
499: mil.subinventory_code subinventory_code,
500: mil.dropping_order,
501: mil.picking_order
502: FROM mtl_item_locations mil,
503: mtl_secondary_inventories msi,
504: mtl_material_transactions_temp mmtt,
505: mtl_material_transactions_temp pmmtt
506: WHERE mmtt.transaction_temp_id = p_task_id
507: AND mil.subinventory_code = pmmtt.subinventory_code
853: IF (p_call_mode <> 3) THEN
854: SELECT 1
855: INTO l_cons_loc_exists_flag
856: FROM mtl_item_locations mil,
857: mtl_secondary_inventories msi,
858: mtl_material_transactions_temp mmtt
859: WHERE mmtt.transaction_temp_id = p_task_id
860: AND mil.subinventory_code = mmtt.transfer_subinventory
861: AND mil.organization_id = mmtt.organization_id
868: ELSE
869: SELECT 1
870: INTO l_cons_loc_exists_flag
871: FROM mtl_item_locations mil,
872: mtl_secondary_inventories msi,
873: mtl_material_transactions_temp mmtt,
874: mtl_material_transactions_temp pmmtt
875: WHERE mmtt.transaction_temp_id = p_task_id
876: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
952: l_validate_loc_empty_flag,
953: l_loc_disable_date,
954: l_sub_disable_date
955: FROM mtl_item_locations mil,
956: mtl_secondary_inventories msi
957: WHERE mil.inventory_location_id = p_locator_id
958: AND msi.secondary_inventory_name = mil.subinventory_code
959: AND msi.organization_id = mil.organization_id
960: ;
1258: nvl(mil.inventory_location_type, 3) del_locator_type
1259: FROM wsh_delivery_details wdd,
1260: wsh_delivery_assignments_v wda,
1261: mtl_item_locations mil,
1262: mtl_secondary_inventories msi
1263: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
1264: wdd.released_status = 'Y' AND
1265: wdd.locator_id = mil.inventory_location_id AND
1266: (nvl(mil.inventory_location_type, g_loc_type_storage_loc) = G_LOC_TYPE_STAGING_LANE
1286: FROM wsh_delivery_details wdd,
1287: wsh_delivery_assignments_v wda,
1288: mtl_txn_request_lines mol,
1289: mtl_item_locations mil,
1290: mtl_secondary_inventories msi
1291: WHERE
1292: mol.line_id = wdd.move_order_line_id AND
1293: wdd.released_status = 'Y' AND
1294: wdd.locator_id = mil.inventory_location_id AND
1804: l_validate_loc_empty_flag,
1805: l_loc_disable_date,
1806: l_sub_disable_date
1807: FROM mtl_item_locations mil,
1808: mtl_secondary_inventories msi
1809: WHERE mil.inventory_location_id = p_locator_id
1810: AND msi.secondary_inventory_name = mil.subinventory_code
1811: AND msi.organization_id = mil.organization_id
1812: ;